If we move a cell containing a formula having reference to another cell in the worksheet what will happen to the cell number used in the formula
Answers
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.
Answer:
Moving the formula.
Explanation:
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.
If you move a cell containing a formula that references another cell in the same worksheet, the cell references in the formula will be updated automatically to reflect the new location of the cell. For example, if you have a formula in cell A1 that references cell B1, and you move cell A1 to a new location, say C1, the formula in C1 will also update to reference cell B1 instead of A1. This is because when you move a cell, Excel adjusts the cell references in any formulas that use those cells, so that the formulas continue to point to the correct data.
This is true for relative cell references (e.g. B1), and the relative references will change based on the movement of the cell. Absolute cell references (e.g. $B$1) will not change regardless of the movement of the cell.
To know about formula, click on the link below:
https://brainly.in/question/7987673
To know about worksheet, click on the link below:
https://brainly.in/question/7696377
#SPJ3