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 12 of 47

Explore more Topics under MS Office

Q111.
In MS-Excel accounting style shows negative numbers in

a.

Bold

b.

Brackets

c.

Parentheses

d.

None of these

Discuss
Answer: (c).Parentheses
Q112.
In MS-Excel you can zoom a worksheet

a.

With the mouse pointer in Print Preview

b.

With the zoom button on the Print Preview toolbar

c.

With the Zoom command on the view menu

d.

All of the above

Discuss
Answer: (d).All of the above
Q113.
You can link MS-Excel worksheet data to a Word document

a.

With the right drag method

b.

With a hyperlink

c.

With the copy and paste buttons on the standard toolbar

d.

None of these

Discuss
Answer: (b).With a hyperlink
Q114.
In MS-Excel the chart wizard

a.

Can place a chart on a new chart sheet or on any sheet in the workbook

b.

Can only place a chart on new chart sheet

c.

Can only place a chart on a new blank worksheet

d.

None of these

Discuss
Answer: (a).Can place a chart on a new chart sheet or on any sheet in the workbook
Q115.
MS-Excel is similar to which of the following accounting worksheets

a.

Word processing

b.

Database

c.

Spreadsheets

d.

Both (b) and (c)

Discuss
Answer: (c).Spreadsheets
Q116.
In MS-Excel the auto calculate feature

a.

Can add values in a range of cells

b.

Provides a quick way to view the results of an arithmetic operation on a range of cells

c.

Automatically creates formula and adds them to a worksheet

d.

All of these

Discuss
Answer: (d).All of these
Q117.
In MS-Excel you can use the format painter multiple times before you turn it off by

a.

You can use the format painter button only one time when you click it

b.

Double clicking the format painter button

c.

Pressing the Ctrl key and clicking the format painter button

d.

None of these

Discuss
Answer: (b).Double clicking the format painter button
Q118.
In MS-Excel following term describes explanatory text attached to a cell

a.

Callout

b.

Comment

c.

Dialog

d.

All of these

Discuss
Answer: (b).Comment
Q119.
In MS-Excel the drag and drop method of copying or moving

a.

Can be used between a  worksheet but not workbooks

b.

Can be used between both workbooks an worksheets

c.

Can be used between workbooks but not worksheets

d.

None of these

Discuss
Answer: (d).None of these
Q120.
In MS-Excel to delete an embedded object

a.

Double click the object

b.

Select the object by clicking it

c.

Press the Alt + Delete keys

d.

Select it and then press the delete key

Discuss
Answer: (d).Select it and then press the delete key
Page 12 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!

Artificial Intelligence

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

Reverse Engineering

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

Cyber Security

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

C Programming

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

CompTIA PenTest+ Certification Exam PT0 002

Prepare for the CompTIA PenTest+ PT0-002 exam with our targeted MCQs. Covering...

HTML

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

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

Management Information Systems

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

C# programming

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