Question

=$A1 is an example of relative reference.​

Answer 1

Answer:

Absolute and Relative References

Relative references point to a cell based on its position relative to the current cell. ... For example, suppose the formula =B1+B2+B3 is located in cell A1. When you copy the formula and paste it down two rows into cell A3, the formula will be adjusted down two rows, to =B3+B4+B5 .

Answer 2

Answer:

The row and column portions of a relative reference are not preceded by a “$” – for example, A1 is a relative reference to cell A1. If moved or copied, the reference changes by the same number of rows and coulmns as it was moved.

Miss phenomenal