adplus-dvertising
frame-decoration

Question

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

Posted under MS Office

Answer: (b).Excel edits cell references in the newly copied formula

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. When you copy a formula
Add Comment

Similar Questions

Discover Related MCQs

Q. The autofill feature

View solution

Q. Which menu option can be sued to split windows into two

View solution

Q. What symbol is used before a number to make it a label?

View solution

Q. Which symbol must all formula begin with?

View solution

Q. Which of the following formulas is not entered correctly?

View solution

Q. Which of the following formulas will Excel Not be able to calculate?

View solution

Q. A typical worksheet has ..... Number of columns

View solution

Q. How many characters can be typed in a single cell in Excel?

View solution

Q. A worksheet can have a maximum of .... Number of rows

View solution

Q. Which of the following is not an example of a value?

View solution

Q. The chart wizard term data series refers to

View solution

Q. The Chart wizard term data categories refers to;

View solution

Q. A worksheet range is a

View solution

Q. Tab scrolling button

View solution

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

View solution

Q. Data can be arranged in a worksheet in a easy to understand manner using

View solution

Q. You can use drag-and-drop to embed excel worksheet data in a word document

View solution

Q. The auto calculate feature

View solution

Q. Excel uniquely identifies cells within a worksheet with a cell name

View solution

Q. MS-EXCEL can be used to automate

View solution
View All MCQs on MS Office

Suggested Topics

Are you eager to expand your knowledge beyond MS Office? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Data Warehousing and OLAP

Strengthen your knowledge of Data Warehousing and OLAP with our specialized MCQs....

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...

MATLAB

Hone your computational mathematics skills with our MATLAB MCQs. Understand...

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

Formal Languages and Automata Theory

Discover the mathematical models of computation with our Formal Languages and...

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

Hadoop

Dive into the world of big data with our Hadoop MCQs. Cover key concepts including...

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...

Cloud Computing

Stay on top of the biggest trend in IT with our Cloud Computing MCQs. These questions...