Question

what is cell reference give an example

Answer 1

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

Answer 2

cell reference are relative reference when copied across multiple cells change based on the relative position of rows and columns ex- if you copy the formula A1 +B1 from row 1 to row 2 the formula become =A2+B2