What does the symbol $ represent in a cell reference like $A$1?

In a cell reference like $A$1, the dollar symbol ($) represents an absolute reference. An absolute reference locks either the column, the row, or both, so that when a formula containing this reference is copied to other cells, the locked part of the reference does not change. This is crucial for maintaining consistent references to specific cells in complex calculations.

• A relative reference (A) is incorrect; a relative reference (e.g., A1) changes when copied, adjusting based on its new position.
• A text string (B) is incorrect; while text can be in cells, the dollar sign here has a specific functional meaning in formulas.
• A currency value (D) is incorrect; although the dollar sign is a currency symbol, in the context of cell references, it denotes absolute referencing, not a currency format.