Question

absolute reference the cell address does not change even during copying a formula

​

Answer 1

Answer:

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.