adplus-dvertising
frame-decoration

Question

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

a.

From Edit menu choose Clear and then Formats

b.

From Edit menu choose Delete

c.

Click on Remove Formatting tool on Standard Toolbar

d.

Double click the Format Painter and then press Esc key in keyboard

Posted under MS Office

Answer: (a).From Edit menu choose Clear and then Formats

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
Add Comment

Similar Questions

Discover Related MCQs

Q. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

View solution

Q. Which of the following action removes a sheet from workbook?

View solution

Q. While Finding and Replacing some data in Excel, which of the following statement is valid?

View solution

Q. Which of the following is not true about Find and Replace in Excel

View solution

Q. You can move a sheet from one workbook into new book by

View solution

Q. What is the short cut key to replace a data with another in sheet?

View solution

Q. Comments put in cells are called .....

View solution

Q. Comments can be added to cells using ......

View solution

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

View solution

Q. Getting data from a cell located in a different sheet is called ......

View solution

Q. Which of the following is not a valid data type in Excel?

View solution

Q. Which elements of a worksheet can be protected from accidental modification?

View solution

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

View solution

Q. Concatenation of text can be done using

View solution

Q. Which area in an Excel window allows entering values and formulas?

View solution

Q. Multiple calculations can be made in a single formula using .......

View solution

Q. An Excel Workbook is a collection of .......

View solution

Q. What do you mean by a Workspace?

View solution

Q. MS-EXCEL is based on .........?

View solution

Q. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?

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!

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

Java Programming

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

Reverse Engineering

Strengthen your understanding of Reverse Engineering with our curated set of MCQs....

Compiler Design

Unravel the process of translating source code into executable programs with our...

Digital Logic Design

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

HTML

Start your journey in web development with our HTML MCQs. Learn the building blocks...

Cloud Computing

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

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...