Question

On copying a formula , in which type of cell reference does the formula change ? *

1 point

(a) Absolute

(b) Relative

(c) Mixed

(d) Both a and b​

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. Place a "$" before the column letter if you want that to always stay the same.

Answer 2

Answer:

Both a and b

HOPE IT HELPED