Q179
Which of the following is an absolute cell reference?
A.
!A!1
B.
1
AnswerC.
#a#1
D.
A1
Answer: Option B
Solution
Answer: Option B
Solution:
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.