BS Nursing Computer skills
nmdcat.online June 6, 2026

What is the purpose of absolute cell referencing (e.g., $A$1) in Excel?

A. It changes when a formula is copied to another cell.
B. It remains constant when a formula is copied to another cell.
C. It refers to a cell on another worksheet.
D. It refers to a cell in a different workbook.

📖 Additional Information

  • It changes when a formula is copied to another cell.
  • It remains constant when a formula is copied to another cell.
  • It refers to a cell on another worksheet.
  • It refers to a cell in a different workbook.

🔗 Share This Question

Categories

View all →