Question

what is cell reference? Explain the different types of cell references.​

Answer 1

Answer:

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied

Answer 2

Answer:

Cell referencing in which the cells are referred by their relative position in the worksheet relative to a particular cell is called relative referencing.

Explanation:

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.