Question

What symbol is used to indicate that an absolute reference should be used when a formula is copied? In Excel

=
^
$
()

Answer 1

The answer to your question is: The $ symbol shows an absolute reference.

Answer 2

Answer:

$

Explanation:

In excel, to make an absolute reference to a character (or symbol) in a cell, we engage the $ symbol.

For instance, to engage the symbol in cell J1, we use $J$1 to avoid a copied formula that involves cell J1 from changing to J2.

As such, the answer is $.