Question

What is relative and absolute cell address in the 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.

The key difference between relative and absolute cells is that relative cell references move when you copy them, but absolute references do not. Absolute references are noted by a dollar sign in front of the cell reference.

Explanation:

Answer 2

Relative cell - In this reference the row no. gets one added when we drag the formula downward in column and in the same way

Absolute Cell - In absolute referencing a $ symbol is used before the column name as well as row number to make it constant in any formula