R

Ram Sharma • 193.86K 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.

Be the first to start discuss.

Related MCQs on Microsoft Excel

Q. Give me an example of a cell address.

Q. Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?

Q. A numeric value can be treated as label value if …… precedes it.

Q. In Excel how do you delete a column?

Q. In Excel the function calculates depreciation at the same amount each year over an asset’s useful life

Q. Which of the following is not true regarding Conditional Formatting?

Q. A circular reference is

Q. In Excel when the formula bar is active, you can see

Q. What is the use of VLOOKUP function in MS Excel?

Q. Multiple calculations can be done in a single formula using _______

Learn All Microsoft Excel MCQs