Google News
logo
Microsoft Excel - Quiz(MCQ)
Which of the following is an absolute cell reference?
A)
A1
B)
#a#1
C)
!A!1
D)
$A$1

Correct Answer : Option (D) :   $A$1


Explanation : The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.

Advertisement