Question

Example of Relative cell Reference is

A1+ B1

$A$1+ $B1

A1+B$1​

Answer 1

Answer:

Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell. Situations arise in which the cell reference must remain the same when copied or when using AutoFill.