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