Question

How many types of cell references are used in Excel? Explain each one with their purpose and suitable examples.

Answer 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.