Identify the types of referencing from the following =C1 ,=D$2, =$W2, =$E$4
Answers
Answered by
0
The types of cell referencing are as follows-
1. =C1
Relative referencing is used when the same formula is to be used for multiple cells. The formula remains the same, value changes.
2. =D$2 and =$W2
Mixed referencing is used when either the row or the column has to be fixed as its value is to be used to calculate the values in other cells as well.
3. =$E$4
Absolute referencing fixes both the row and the column and the value remains unchanged throughout.
Similar questions