Question

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

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.

Answer 2

If we move cell reference to another cell relative cell references will change.

Explanation:

• Changing a formula: No matter what sort of cell reference you use, the cell references inside the formula do not change.

• Copying a formula: The relative cell references change when you copy a formula.

• A cell reference specifies how far a cell or group of cells inside the same spreadsheet is from another cell.

• The relative cell relation when dealing with a table formulation is the default action of a formula.

Learn More:

brainly.in/question/3042220