nmdcat.online
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

Facebook Twitter LinkedIn WhatsApp

🧭 Navigate Questions

Previous Question

Which Excel feature allows you to highlight cells based on their values (e.g., top 10%, values greater than)?

Next Question

What is the shortcut key to insert a new worksheet in Excel?

Back to All Questions

🔗 Related MCQs

Exudate does NOT contain:
June 6, 2026
Rubor refers to:
June 6, 2026
Necrotic tissue refers to:
June 6, 2026
True about endotoxins:
June 6, 2026
Bacteria avoiding WBC engulfment:
June 6, 2026

Categories

View all →