Question

what are the types of referencing in MS Excel explain each one​

Answer 1

$\huge{\underline{\color{purple}{\mathfrak{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.

Answer 2

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.

Explanation: