Question

what is relative cell referencing? How is it useful?​

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.

Explanation:

Answer 2

Answer:

A cell reference or relative cell reference describes how far away a cell or group of cells is from another cell in the same spreadsheet. When dealing with a spreadsheet formula, the relative cell reference is the default behavior of a formula.