Explaining the meaning of Absolute cell referencing and Relative Cell Referencing
Solution
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.
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.