Question

Difference between absolute and relative cell reference

Answer 1

Answer:

Relative References

No dollar signs at all! If you copy this from place to place, the formula will move with it. So if you type =A1+A2 into cell A3, then copy and paste that formula into cell B3, it will automatically change the formula to =B1+B2.

Absolutely Absolute

All dollar signs. If you type =$A$1+$A$2 into cell A3, then copy and paste that formula into cell B3, it will stay =$A$1+$A$2. Amazing!

Answer 2

Answer:

Explanation:

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant, no matter where they are copied.