233k views
5 votes
Explain cell reference and its types with examples?​

1 Answer

5 votes

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.

User Trickedoutdavid
by
5.6k points