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!

HTML

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

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

Formal Languages and Automata Theory

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

Software Engineering

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

C Programming

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

Computer Hardware

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

Data Warehousing and OLAP

Strengthen your knowledge of Data Warehousing and OLAP with our specialized MCQs....

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...