Question

What is relative relative and absolute cell address in the spreadsheet?

Answer 1

Answer:

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.

Thanks^∆^....,.......

Explanation:

Answer 2

Relative and Absolute reference

• Relative reference is the default cell reference in a spreadsheet. It is simply the combination of column name and row number without any dollar ($) sign. The relative reference changes when copying the formula from one cell to another.
• Absolute reference is the cell reference where the dollar ($) sign is added before the column name and row number. The absolute reference will not change when copying the formula from one cell to other.