Microsoft Excel Questions

MCQ bookmark_border

151.

The Paste Special command lets you copy and paste:

A

Multiply the selection by a copied value

B

Cell comments

C

Formatting options

D

The resulting values of a formula instead of the actual formula

Correct Answer: D

The Paste Special command lets you copy and paste the resulting values of a formula instead of the actual formula.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

152.

The numbers in our worksheet look like this 1000: You want them to look like this: $1,000.How can you accomplish this?

A

You have to retype everything and manually add the dollar signs, commas, and decimals

B

Select Format > Money from the menu

C

Click the Currency Style button on the formatting toolbar

D

None of these

Correct Answer: C

Click the Currency Style button on the formatting toolbar

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

153.

Excel worksheet cells work very similarly to what common element of the windows graphical user interface

A

Option buttons

B

List boxes

C

Text boxes

D

Combo boxes

Correct Answer: C

Excel worksheet cells work very similarly to Text boxes graphical user interface.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

154.

Which of the following options is not located in the Page Setup dialog box?

A

Page Break Preview

B

Page Orientation

C

Margins

D

Headers and Footers

Correct Answer: A

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

155.

Which of the following options is not located in the Page Setup dialog box?

A

Page Break Preview

B

Page Orientation

C

Margins

D

Headers and Footers

Correct Answer: A

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

156.

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

A

Press Ctrl + Home

B

Press Home

C

Press Shift + Home

D

Press Alt + Home

Correct Answer: A

Ctrl + Home key is the fastest way of getting to cell A1 in a spreadsheet.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

157.

Which of the following methods can not be used to edit the contents of a cell?

A

Press the Alt key

B

Clicking the formula bar

C

Pressing the F2 key

D

Double clicking the cell

Correct Answer: A

A cell can be edited through Press the F2 key or Click the formula bar or Double click the cell.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

158.

If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you:

A

Press the Erase key

B

Press Esc

C

Press the Enter button

D

Press the Edit Formula button

Correct Answer: B

Pressing the Esc key while editing a cell aborts the operation and leaves the cell in it's original state.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

159.

To view a cell comment

A

Click the edit comment command on the insert menu

B

Click the display comment command on the window menu

C

Position the mouse pointer over the cell

D

Click the comment command on the view menu

Correct Answer: C

Position the mouse pointer over the cell to view a cell comment.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

160.

To view a cell comment

A

Click the edit comment command on the insert menu

B

Click the display comment command on the window menu

C

Position the mouse pointer over the cell

D

Click the comment command on the view menu

Correct Answer: C

Position the mouse pointer over the cell to view a cell comment.

Check Answer report_problem Report forum Discussion