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!

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...

Digital Logic Design

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

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...

Cyber Security

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

Software Engineering

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

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...

Java Spring Framework

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

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...