Question

what is cell reference ? Explain it types​

Answer 1

Answer:

A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

There are two types of cell references :- relative and absolute. 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:

✏There are 2 types of cell references :

✏Relative

✏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.

HOPE IT HELPS YOU DEAR...

❤❤❤❤❤