Microsoft Excel Questions

MCQ bookmark_border

161.

To save a workbook, you:

A

Click the save button on the standard toolbar from the menu

B

Press Ctrl+ F5

C

Click Save on the Windows Start button

D

Select Edit > Save

Correct Answer: A

Click the save button on the standard toolbar from the menu

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

162.

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

Correct Answer: B

Double clicking the cell to edit it in-place

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

163.

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

Correct Answer: D

We can select a single range of cells by dragging cursor over the desired cells.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

164.

Which elements of worksheet can be protected from accidental modification

A

Contents

B

Objects

C

Scenarios

D

All of above

Correct Answer: D

All elements of a worksheet can be protected from accidental modification.
To protect a worksheet in Excel 2007 and higher versions, click the Review tab, click Protect Worksheet (or Protect Sheet), and click OK.
Excel 2003 and Earlier Versions click Tools > Protection, click Protect Sheet, and click OK.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

165.

Which elements of worksheet can be protected from accidental modification

A

Contents

B

Objects

C

Scenarios

D

All of above

Correct Answer: D

All elements of a worksheet can be protected from accidental modification.
To protect a worksheet in Excel 2007 and higher versions, click the Review tab, click Protect Worksheet (or Protect Sheet), and click OK.
Excel 2003 and Earlier Versions click Tools > Protection, click Protect Sheet, and click OK.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

166.

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

A

Data will be entered in the adjacent cells

B

No data will be entered in the adjacent cells

C

There is no suitable abbreviation of the text

D

There is not time to format the next

Correct Answer: B

When there is no data in in the adjacent cells, long text flows into adjacent cells on a worksheet. As soon as data is entered into in the adjacent cells, text will be visible upto cell length in which data is entered, For full visibility of data either we need to increase the length of cell or wrap text in particular cell.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

167.

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

Correct Answer: B

Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button in Excel 2003 and earlier version.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

168.

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

Correct Answer: C

Right clicking something in Excel opens a shortcut menu listing everything you can do to the object.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

169.

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

Correct Answer: D

Documentation should include
Source of input data
Destination and users of the output data
Information on the purpose of the workbook.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

170.

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

Correct Answer: D

Documentation should include
Source of input data
Destination and users of the output data
Information on the purpose of the workbook.

Check Answer report_problem Report forum Discussion