Question

If we move a cell containing a formula having reference to another cell in the worksheet what will happen to the cell numbers used in the formula


a) The cell row and columns are changed at destination.
b) The cell row change at destination.
c) The cell columns are changed at destination.
d) No change will occur.

​

Answer 1

Answer:

Moving a formula: When you move a formula, the cell references within the formula do not change no matter what type of cell reference that you use. Copying a formula: When you copy a formula, relative cell references will change.

Explanation:

mark me as a brainlist answer plz