Question

Which of the following is an absolute cell reference?
A1
$A$1
!A!!
#a#1

Answer 1

An absolute cell reference is a celladdress that contains a dollar sign ($) in the row or column coordinate, or both. When you enter a cell referencein a formula, Excel assumes it is a relative reference unless you change it to an absolute reference

if you like my answer pls follow me

Answer 2

$A$1 is an absolute cell reference.

• Absolute cell referencing is a feature of MS Excel. It is very useful and makes the work easier.
• An absolute cell reference stays constant and freezes the respective row and column.
• The shortcut key to make a cell reference absolute is pressing the F4 key on the keyboard.
• It can also be done by adding the $ sign manually.