Skip to main contentSkip to solution

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.

Keyboard Shortcuts

  • Left arrow: Previous question
  • Right arrow: Next question
  • S key: Jump to solution
  • Q key: Jump to question