11. define relative, absolute and mixed referencimg.
Answers
Answered by
1
weryuiopsdgklzcvnndjkkruop
Answered by
1
Many formulas in Excel contain references to other cells. These references allow formulas to dynamically update their contents.
We can distinguish three types of cell references: relative, absolute and mixed.
Relative cell references
This is the standard type of reference. Look at the following examples:
Example 1:
If cell A1 contains value 2, and cell B1 contains formula =A1+2 (referring to cell A1), then the formula B1 contains value 4. If you change the value in cell A1 to 5, then the value in cell B1 automatically changes to 7.
We can distinguish three types of cell references: relative, absolute and mixed.
Relative cell references
This is the standard type of reference. Look at the following examples:
Example 1:
If cell A1 contains value 2, and cell B1 contains formula =A1+2 (referring to cell A1), then the formula B1 contains value 4. If you change the value in cell A1 to 5, then the value in cell B1 automatically changes to 7.
Similar questions