Question

Classify the type of references.

=A1+A2

=$A$1+$A$2

=$A1+A$2​

Answer 1

1 circular reference
2 absolute reference
Absolute

Answer 2

Answer:

What is an Absolute Reference in Excel?

Absolute references are used when you want to fix a cell location. These cell references are preceded by a dollar sign. By doing this, you are fixing the value of a particular cell reference.

For example, if you type the formula = A1+A2 into A3 and copy it to another location: B3, the formula will change to = B1+B2.

But, if you type the formula as an absolute reference such as = $A$1+$A$2, and then copy the formula to any other location, it remains fixed as = $A$1+$A$2.

You will learn how to make an absolute cell reference in the next section, so stay tuned.