Question

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

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

Hint:

Absolute references (\$A\$1) lock both column and row. Mixed references (\$A1 or A\$1) lock only one of them.

Answer 1

The Correct Option is A

In Excel, absolute cell references are indicated by the use of a \$ sign before the column and row references (e.g., \$A\$1). Mixed references use the \$ sign only before either the column or the row reference (e.g., \$A1 or A\$1).