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

Explore more Topics under MS Office

Q261.
You can edit a cell by

a.

Clicking the formula button

b.

Double clicking the cell to edit it in-place

c.

Selecting Edit>Edit Cell from the menu

d.

None of above

Discuss
Answer: (b).Double clicking the cell to edit it in-place
Q262.
You can select a single range of cells by

a.

Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

b.

Pressing the Ctrl key while dragging over the desired cells

c.

Pressing the Shift key and an arrow key

d.

Dragging over the desired cells

Discuss
Answer: (d).Dragging over the desired cells
Q263.
Which elements of worksheet can be protected from accidental modification

a.

Contents

b.

Objects

c.

Scenarios

d.

All of above

Discuss
Answer: (d).All of above
Q264.
You can use the drag and drop method to

a.

Copy cell contents

b.

Move cell contents

c.

Add cell contents

d.

a and b

Discuss
Answer: (d).a and b
Q265.
How can you delete a record?

a.

Delete the column from the worksheet

b.

Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button

c.

Select Data > Delete Record from the menu

d.

Click the Delete button on the Standard toolbar

Discuss
Answer: (b).Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
Q266.
Right clicking something in Excel:

a.

Deletes the object

b.

Nothing the right mouse button is there for left handed people

c.

Opens a shortcut menu listing everything you can do to the object

d.

Selects the object

Discuss
Answer: (c).Opens a shortcut menu listing everything you can do to the object
Q267.
Documentation should include

a.

Destination and users of the output data

b.

Source of input data

c.

Information on the purpose of the workbook

d.

All of the above

Discuss
Answer: (d).All of the above
Q268.
Files created with Lotus 1-2-3 have an extension

a.

DOC

b.

XLS

c.

123

d.

WK1

Discuss
Answer: (c).123
Q269.
To delete an embedded objects, first

a.

Double click the object

b.

Select the object by clicking it

c.

Press the Shift + Delete keys

d.

Select it and then press the delete key

Discuss
Answer: (d).Select it and then press the delete key
Q270.
Comments can be added to cells using

a.

Edit > Comments

b.

Insert > Comments

c.

File > Comments

d.

View > Comments

Discuss
Answer: (b).Insert > Comments
Page 27 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!

Management Information Systems

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

Formal Languages and Automata Theory

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

Reverse Engineering

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

Computer Hardware

Explore the tangible components of computers with our Computer Hardware MCQs. Learn...

C# programming

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

Hadoop

Dive into the world of big data with our Hadoop MCQs. Cover key concepts including...

Wireless and Mobile Communications

Get to grips with modern communication technologies with our Wireless and Mobile...

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...

Human Computer Interaction

Enhance your knowledge of Human-Computer Interaction with our specialized MCQs....