Vidyalelo
Computer Fundamentals · Q176

Microsoft Excel

Computer Related · Computer Fundamentals · question 176

Q176

When you copy a formula

A.
Excel erases the original copy of the formula
B.
Excel edits cell references in the newly copied formula
Answer
C.
Excel adjusts absolute cell references
D.
Excel doesn’t adjust relative cell references

Answer: Option B

Solution

Answer: Option B
Solution:
When you copy a formula Excel edits cell references in the newly copied formula.