Question

What happens by default when you copy a formula from one cell to another cell?

a. the cell address in the formula changes to reflect the cell address of the new location.

b. the cell address in the formula remains the same.

c. the formula in the original cell changes per the formula of the new location.

d. the cell address of the original cell changes to the cell address of the new location.

Answer 1

a

Step-by-step explanation:

Answer 2

A) Excel automatically changes the cell addresses to reflect the destination location