Question

What is relative and absolute cell address in a spreadsheet

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.

Explanation: