Question

A formula with a dase cell reference change as you copy it from one cell to another​

Answer 1

Answer:

These are called "relative" cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references.

Answer 2

Answer:

Relative vs. Absolute Cell References in Spreadsheets

In working with spreadsheets, you need to know about relative vs. absolute cell references.

Here is the issue: when you COPY A FORMULA that contains cell references, what happens to the cell references?

Usually the CELL REFERENCES will CHANGE! If you copy a formula 2 rows to the right, then the cell references in the formula will shift 2 cells to the right. If you copy a formula 3 rows down and 1 row left, then the cell references in the formula will shift 3 rows down and 1 row left. These are called "relative" cell references, since they change relative to where you copy the formula.

FOLLOW ME