Question

xiv) Which of these formulas use relative cell references?
a) =5 10+20
b) =$A$10/100
C) =F18+F19/21​

Answer 1

Answer:

By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.