Absolute reference is represented by which symbol?

Correct answer: $. The dollar sign ($) fixes the row or column of a cell reference, such as $A$1.

• #: # appears in error values such as #REF!.
• @: @ is used in e-mail addresses and some references, but not absolute references.
• &: & joins text in a formula.