Question

Which of the given cell reference can be used in a relative reference?

​

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

A3

A3 the given cell reference can be used in a relative reference

• A cell reference is by default a relative reference, which denotes that the reference is relative to where the cell is located. When you refer to cell A2 from cell C2, for instance, you are actually referring to a cell that is two columns to the left (C minus A)—in the same row (2).

• They modify based on the relation between rows and columns when replicated across many cells. For instance, the formula =A1+B1 will become =A2+B2 if you transfer it from row 1 to row 2.
• A formula's relative references are altered when it is copied to another cell.
• When you wish to fix the location of a cell, you utilise absolute references. A dollar sign is placed before each of these cell references. You are fixing the value of a specific cell reference by doing this. For instance, the formula will become = B1+B2 if you enter = A1+A2 into A3 and duplicate it to another location: B3.

#SPJ3