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.