Question

In Microsoft Excel, what is the purpose of the '$' sign in a cell reference (e.g., `$A$1`)?

A It indicates a named range.
B It makes the row and column absolute, preventing them from changing when copied.
C It signifies a formula error.
D It denotes a currency format.
E None of the above
Practice Next

Hey! Ask a query

🎓
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
  • 200 Questions with Detailed Solutions
  • Section-wise Coverage (GA, English, Quant & Reasoning)