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.

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

01

MS Word

02

MS Powerpoint

03

MS Access

04

Shortcut Keys

Q111.

In MS-Excel accounting style shows negative numbers in

Bold

Brackets

Parentheses

None of these

Discuss

Answer: (c).Parentheses

Q112.

In MS-Excel you can zoom a worksheet

With the mouse pointer in Print Preview

With the zoom button on the Print Preview toolbar

With the Zoom command on the view menu

All of the above

Discuss

Answer: (d).All of the above

Q113.

You can link MS-Excel worksheet data to a Word document

With the right drag method

With a hyperlink

With the copy and paste buttons on the standard toolbar

None of these

Discuss

Answer: (b).With a hyperlink

Q114.

In MS-Excel the chart wizard

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

Can only place a chart on new chart sheet

Can only place a chart on a new blank worksheet

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

Word processing

Database

Spreadsheets

Both (b) and (c)

Discuss

Answer: (c).Spreadsheets

Q116.

In MS-Excel the auto calculate feature

Can add values in a range of cells

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

Automatically creates formula and adds them to a worksheet

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

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

Double clicking the format painter button

Pressing the Ctrl key and clicking the format painter button

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

Callout

Comment

Dialog

All of these

Discuss

Answer: (b).Comment

Q119.

In MS-Excel the drag and drop method of copying or moving

Can be used between a worksheet but not workbooks

Can be used between both workbooks an worksheets

Can be used between workbooks but not worksheets

None of these

Discuss

Answer: (d).None of these

Q120.

In MS-Excel to delete an embedded object

Double click the object

Select the object by clicking it

Press the Alt + Delete keys

Select it and then press the delete key

Discuss

Answer: (d).Select it and then press the delete key

Page 12 of 47

Welcome to the MS Excel MCQs Page

MS Excel MCQs | Page 12 of 47

Explore more Topics under MS Office

MS Word

MS Powerpoint

MS Access

Shortcut Keys

Suggested Topics

Management Information Systems

Data Science

HTML

Human Computer Interaction

Object Oriented Programming Using C++

Embedded Systems

Microprocessor

UNIX

Software Engineering