Question

What will happen when you copy a formula ?

• A. Excel erases the original copy of the formula
• B. Excel edits cell references in the newly copied formula
• C. Excel adjusta absolute cell references
• D. Excel doesn't adjust relative cell references

Answer 1

Answer:

B. Excel edits cell references in the newly copied formula