Question

Explain how formula copying takes place in case of relative cell reference.

Answer 1

Explanation:

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.

references in a formula

Click the cell in which you want to enter the formula.

In the formula bar. , type = (equal sign).

Do one of the following, select the cell that contains the value you want or type its cell reference. ...

Press Enter.

I hope you like my answer

Answer 2

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