1. Relative Cell references:
By default cell reference is relative; which means that as a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the new location.
2. Absolute Cell reference:
The absolute cell reference consists of the column letter and row number surrounded by dollar ($) signs. Eg $A$5. An absolute cell reference is used when we want a cell reference to stay fixed on a specific cell.