Question

How are ‘absolute cell references’ and ‘mixed references’ identified in Excel?

• A. using \$ sign
• B. using £ sign
• C. using \# sign
• D. using \~ sign

Hint:

Use absolute references to lock cell references during calculations. Mixed references allow flexibility by fixing either the row or column.

Answer 1

The Correct Option is A

Absolute cell references in Excel are denoted by a \$ sign before the column and/or row. For example: \[ \text{Absolute Reference: } \$A\$1 \] Mixed references, on the other hand, have a \$ sign before either the row or column but not both. For example: \[ \text{Mixed Reference: } \$A1 \, \text{or} \, A\$1 \]