Question

Discuss briefly about ‘Absolute Cell Reference’ and ‘Relative Cell Reference’.​

Answer 1

Answer:

please mark me as brainliest

Explanation:

When relative cell references are copied to more than one row or column, they change depending on their position, which is useful for performing the same calculation in each row or column. In contrast, the definition of absolute cell reference is one that does not change when it's moved, copied or filled.

Answer 2

Explanation:

The type of refrencing in which cell refrences change relative to their location when copied, is called relative refrences.example A1,A2

The type of references in which cell references never change relative to their location when copied, is called absolute cell refrences.example$A,$1.