Question

What is difference between relative and absolute cell referencing?

Answer 1

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