In Excel, which symbol is used to lock a cell reference in an absolute reference?

In Excel, which symbol is used to lock a cell reference in an absolute reference?

• A. % (Percent).
• B. $ (Dollar sign).
• C. & (Ampersand).
• D. # (Hash).

Answer: (B)

Locking a cell reference in Excel is done with the dollar sign. It fixes the reference so it doesn’t change when you copy a formula. For a fully fixed reference, use the dollar sign before both the column and the row, like $A$1. If you want only the column fixed, use $A1; if you want only the row fixed, use A$1. The other symbols have different uses: % is a percentage, & concatenates text or values, and # often indicates an error or a spill, not locking references.

Locking a cell reference in Excel is done with the dollar sign. It fixes the reference so it doesn’t change when you copy a formula. For a fully fixed reference, use the dollar sign before both the column and the row, like $A$1. If you want only the column fixed, use $A1; if you want only the row fixed, use A$1. The other symbols have different uses: % is a percentage, & concatenates text or values, and # often indicates an error or a spill, not locking references.