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? How we can move a cell to
another cell?
(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 changes​

Answer 1

Answer:

if the cell reference have($) symbol either before row no ro column letter from it will not change because it is absulote but the reference is for eg. C5 while copying it to the another cell it will not change.

Explanation:

mark as brainliest!!! please

Answer 2

Answer:

Hii dear

Here is your answer

if the cell reference have($) symbol either before row no ro column letter from it will not change because it is absulote but the reference is for eg. C5 while copying it to the another cell it will not change.

Explanation:

mark as brainliest!!! please