Sagot :
Answer:
There are 3 types of cell referencing in EXCEL, they are RELATIVE CELL REFERENCING,
FIXED CELL REFERENCING,
MIXED CELL REFERENCING.
There is no any Absolute Cell Referencing. But, I think, absolute cell referencing means Fixed Cell Referencing.
To make an Absolute or Fixed Cell Reference, we have to use the “$” symbol.
For example,
“A1” is the Relative Cell Reference,
“$A$1” is the Absolute or Fixed Cell Reference,
“$A1” or “A$1” is the Mixed Cell Reference.
Explanation: