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