Question

(vii) Relative Reference formed by row 19 and column AB.​

Answer 1

Answer:

Relative Reference formed by row 19 and column AB is AB19

Answer 2

Relative Reference formed by row 19 and column AB.​

• By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A)—in the same row (2).
• All cell references are by default relative references. They modify based on the relation between rows and columns when copied across multiple cells. For instance, the formula =A1+B1 will become =A2+B2 if you transfer it from row 1 to row 2. When you need to repeat the same calculation across numerous rows or columns, relative references are extremely useful.
• The first cell in a new Excel spreadsheet that you open is automatically picked; this is cell A1 (the first cell of row A and column one). The active cell is the position of the last used active cell if you've previously worked on an Excel spreadsheet.

#SPJ2