InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Explain the difference between relative cell reference and absolute cell reference? |
|
Answer» 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. |
|