When you copy a formula – McqOptions

MCQOPTIONS

1.	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» C. Excel adjusts absolute cell references

Discussion

No Comment Found

Related MCQs

<p>Which among the following will not set text in selected cells to italics?</p>
<p>Youar German supplier still invoices for parts in deutsche marks. How does Excel convert those sums to Euros?</p>
<p>Which among the following methods can not be used to enter data in a cell?</p>
<p>How should you print a selected area of a worksheet if a different area needs to printed ?</p>
<p>What is a function inside another function is called ?</p>
<p>Which among the following is a correct order of precedence in a formula calculation?</p>
<p>What kind of charts can an excel produce ?</p>
<p>You can open the Highlight Changes dialog box by choosing Track Changes from the . Menu.</p>
<p>To protect a worksheet, you can choose Protection and the Protect Sheet from the .. menu</p>
<p>You can quickly change the appearance of your work by choosing Auto Format from the . Menu</p>