Absolute reference?

Question

What is the absolute reference of a spread sheet?I'm learning exel at school but can't work out what is the absolute reference of a spreadsheet,can anyone plz help me :((

Answer 1

=A1.

Sometimes you'd also have to specify the sheet.

=Sheet1!A1

That's

=[SHEETNAME] ! [CELL}

== EDIT - Above is RELATIVE - ==

Absolute:
In a formula, the exact address of a cell, regardless of the position of the cell that contains the formula. An absolute cell reference takes the form $A$1.)