Which cell reference is used when we want a cell reference to stay fixed on a specific cell, which means that when a formula or function is copied and pasted to other cells, it does not change?
Which cell reference is used when we want a cell reference to stay fixed on a specific cell, which means that when a formula or function is copied and pasted to other cells, it does not change?
Solution
✅ Correct Option: 4
An absolute cell reference locks both the row and the column using the dollar sign notation, so copying the formula to other cells does not change the cell it points to. A relative reference shifts with the formula's position.
Related questions:
2025: 27 May Shift 2
2025: 30 May Shift 1
2025: 30 May Shift 2
2022: 20 Aug Shift 2
2025: 27 May Shift 2