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!

Object Oriented Programming Using C++

Enhance your programming skills with our MCQs on Object Oriented Programming using...

SQL Server

Master Microsoft's database server with our SQL Server MCQs. Topics cover database...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...

Hadoop

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

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....

Software Engineering

Learn about the systematic approach to developing software with our Software...

Internet of Things (IoT)

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

Neural Networks

Dive into the world of Artificial Intelligence with our Neural Networks MCQs. Uncover...

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....