[Solved] In Excel when you copy a formula

McqMate

Q.	In Excel 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 adjusts absolute cell references
D.	Excel doesn’t adjust relative cell references
Answer» B. Excel edits cell references in the newly copied formula

1k

0

Do you find this helpful?

1

View all MCQs in

Microsoft Excel (MS Excel)

Discussion

No comments yet

Related MCQs

In Excel say that you want to paste a formula result – but not the underlying formula – to another cell. In excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to what next?
If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?
In Excel when you want to insert a blank imbedded excel object in a word document you can
When you copy a formula
In Excel you can copy cell formats from one cell to another by using the
In Excel the Paste Special command lets you copy and paste
In Excel you can copy data or formulas
In Excel you can use the formula palette to
In Excel to add two cells (A1 and A2) together you use the following formula
In Excel to create a formula, you first