Question

what is relative cell reference​

Answer 1

Answer:

Relative references chang when a formula is copied to another cell

Explanation:

SUM(B5:B8)as shown below

Answer 2

$\huge{ \underline{ \mathcal{ \red{Relative \:Cell\: Reference}}}}$

The cell reference in this type is a normal cell address like A1, C3, H5, etc.

In relative referencing, the formulae in the copied cell changes according to the change in the position of the cell pointer. If the formula is copied across rows or down columns, the formula or cell reference changes automatically.

For example, if the formula in D4 is B4*C4, when the formula is copied vertically down notice that the cell address in the formula had automatically changed.

$\large{Hope\:this\: helps}$