MS Excel MCQs

Question 1

You can select a single range of cells by

Accepted Answer

Dragging over the desired cells

Answer

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

Answer

Pressing the Ctrl key while dragging over the desired cells

Answer

Pressing the Shift key and an arrow key

Question 2

Which elements of worksheet can be protected from accidental modification

Accepted Answer

All of above

Answer

Contents

Answer

Objects

Answer

Scenarios

Question 3

You can use the drag and drop method to

Accepted Answer

A and B both

Answer

Copy cell contents

Answer

Move cell contents

Answer

Add cell contents

Question 4

It is acceptable to let long text flow into adjacent cells on a worksheet when

Accepted Answer

No data will be entered in the adjacent cells

Answer

Data will be entered in the adjacent cells

Answer

There is no suitable abbreviation of the text

Answer

There is not time to format the next

Question 5

How can you delete a record?

Accepted Answer

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

Answer

Delete the column from the worksheet

Answer

Select Data > Delete Record from the menu

Answer

Click the Delete button on the Standard toolbar

Question 6

Right clicking something in Excel:

Accepted Answer

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

Answer

Deletes the object

Answer

Nothing the right mouse button is there for left handed people

Answer

Selects the object

Question 7

Documentation should include

Accepted Answer

All of the above

Answer

Destination and users of the output data

Answer

Source of input data

Answer

Information on the purpose of the workbook

Question 8

Files created with Lotus 1-2-3 have an extension

Accepted Answer

123

Answer

DOC

Answer

XLS

Answer

WK1

Question 9

To delete an embedded objects, first

Accepted Answer

Select it and then press the delete key

Answer

Double click the object

Answer

Select the object by clicking it

Answer

Press the Shift + Delete keys