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