adplus-dvertising

Welcome to the MS Excel MCQs Page

Dive deep into the fascinating world of MS Excel with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of MS Excel, a crucial aspect of MS Office. In this section, you will encounter a diverse range of MCQs that cover various aspects of MS Excel, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within MS Office.

frame-decoration

Check out the MCQs below to embark on an enriching journey through MS Excel. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of MS Office.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of MS Excel. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

MS Excel MCQs | Page 5 of 47

Explore more Topics under MS Office

Q41.
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

Discuss
Answer: (a).From Edit menu choose Clear and then Formats
Q42.
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

a.

Right click on Sheet Tab of third sheet and choose Delete from the context menu

b.

Click on Sheet 3 and from Edit menu choose Delete

c.

Both of above

d.

None of above

Discuss
Answer: (a).Right click on Sheet Tab of third sheet and choose Delete from the context menu
Q43.
Which of the following action removes a sheet from workbook?

a.

Select the sheet, then choose Edit >> Delete Sheet

b.

Select the sheet then choose Format >> Sheet >> Hide

c.

Both of above

d.

None of above

Discuss
Answer: (a).Select the sheet, then choose Edit >> Delete Sheet
Q44.
While Finding and Replacing some data in Excel, which of the following statement is valid?

a.

You can Find and Replace within the sheet or workbook

b.

Excel does not have option to match case for find

c.

Both are valid

d.

None are valid

Discuss
Answer: (a).You can Find and Replace within the sheet or workbook
Q45.
Which of the following is not true about Find and Replace in Excel

a.

You can search for bold and replace with italics

b.

You can decide whether to look for the whole word or not

c.

You can search in formula too

d.

You can search by rows or columns or sheets

Discuss
Answer: (d).You can search by rows or columns or sheets
Q46.
You can move a sheet from one workbook into new book by

a.

From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK

b.

From Edit menu choose Move of Copy then choose (Move to end) and click OK

c.

From Edit menu choose Move or Copy then select (new book) from To Book list and click OK

d.

None of above

Discuss
Answer: (c).From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
Q47.
What is the short cut key to replace a data with another in sheet?

a.

Ctrl + R

b.

Ctrl + Shift + R

c.

Ctrl + H

d.

Ctrl + F

Discuss
Answer: (c).Ctrl + H
Q48.
Comments put in cells are called .....

a.

Smart Tip

b.

Cell Tip

c.

Web Tip

d.

Soft Tip

Discuss
Answer: (b).Cell Tip
Q49.
Comments can be added to cells using ......

a.

Edit -> Comments

b.

Insert -> Comment

c.

File -> Comments

d.

View –> Comments

Discuss
Answer: (b).Insert -> Comment
Q50.
Which menu option can be used to split windows into two?

a.

Format -> Window

b.

View -> Window-> Split

c.

Window -> Split

d.

View –> Split

Discuss
Answer: (c).Window -> Split
Page 5 of 47

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!

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Cyber Security

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

Internet of Things (IoT)

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

Computer Graphics

Step into the visual side of computing with our Computer Graphics MCQs. Cover topics...

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

Formal Languages and Automata Theory

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

MATLAB

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

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...