Question

An example of Relative cell reference.
1 point
1.=A1+B1

2.=$D$2

3.=$A4+B$2​

Answer 1

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.

EXAMPLE

(1) SUM(B5:B8)

(2) SUM(C5:C8)