Correct option is D
The correct answer is: (d) $
Explanation:
In Excel, the $ symbol is used to indicate an absolute cell reference. When you add a dollar sign before the row number and/or column letter (e.g., $A$1), it locks the reference to that specific cell, meaning it does not change when you copy the formula to other cells.
- $A$1: Both the column (A) and the row (1) are absolute.
- A$1: Only the row is absolute.
- $A1: Only the column is absolute.
The other symbols (#, @, &) are not used for cell references in Excel.