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 formula ?
(a) The cell row and columns are changed at destination
(b) The cell row numbers are changed at destination
(c) The cell column numbers are changed at destination
(d) Nothing will be changed​

Answer 1

Explanation:

a)The cell row and columns are changed at destination