R

Ram Sharma • 193.84K Points
Coach 

Q. When you copy a formula

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

Correct answer: Option(C)

Microsoft Excel Share

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on Microsoft Excel

Q. Which function returns the most common value in a data set

Q. In Excel A data map is helpful

Q. The multiplication arithmetic operator is represented by which of the following symbols ?

Q. Selecting the Column G & H then choose Insert->Column, What will happen?

Q. In Excel you can zoom a worksheet

Q. In Excel which of the following is not a worksheet design criterion?

Q. Which one/are the Chart Tool tab/tabs that adds in the ribbon when you display a chart

Q. To copy formatting from one area in a worksheet and apply it to another area you would use ?

Q. In Excel constant is another name for this type of data

Q. How should you print a selected area of a worksheet, if you'll want to print a different area next time ?

Learn All Microsoft Excel MCQs