How many types of cell references are used in Excel? Explain each one with their purpose and suitable examples.
Answers
Answered by
1
Answer:
There are 3 types of cell reference in excel:
1. Relative cell reference : It is when the formulae in the copied cell changes according to change in the position of the cell pointer.
2. Absolute cell reference : It is specified by using the $ sign along with the column and the row number in the cell. Using $ means it is fixed to a specified location.
3. Mixed cell reference : It is when one part of the cell address is relative and the other is absolute.
Similar questions