Microsoft Excel Questions

MCQ bookmark_border

121.

To activate the previous cell in a pre-selected range, press

A

The Alt key

B

The Tab key

C

The Enter key

D

None of the above

Correct Answer: D

To go to previous cell we use Go To function Ctrl + G.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

122.

Which button do you click to add up a series of numbers?

A

The autosum button

B

The Formula button

C

The quicktotal button

D

The total button

Correct Answer: A

AutoSum is a Microsoft Excel function that adds together a range of cells and displays the total in the cell below the selected range.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

123.

When the formula bar is active, you can see

A

The edit formula button

B

The cancel button

C

The enter button

D

All of the above

Correct Answer: D

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

124.

To copy formatting from one area in a worksheet and apply it to another area you would use:

A

The Edit > Copy Format and Edit>Paste Format commands form the menu

B

The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu

C

There is no way to copy and apply formatting in Excel

D

The Format Painter button on the standard toolbar

Correct Answer: D

The Format Painter copies formatting from one place and applies it to another.
The Format Painter button on the standard toolbar in Excel 2003 and earlier version.
Home tab, in the Clipboard group, click Format Painter in 2007 and higher version.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

125.

To copy formatting from one area in a worksheet and apply it to another area you would use:

A

The Edit > Copy Format and Edit>Paste Format commands form the menu

B

The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu

C

There is no way to copy and apply formatting in Excel

D

The Format Painter button on the standard toolbar

Correct Answer: D

The Format Painter copies formatting from one place and applies it to another.
The Format Painter button on the standard toolbar in Excel 2003 and earlier version.
Home tab, in the Clipboard group, click Format Painter in 2007 and higher version.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

126.

When you link data maintained in an excel workbook to a word document

A

The word document cannot be edit

B

The word document contains a reference to the original source application

C

The word document must contain a hyperlink

D

The word document contains a copy of the actual data

Correct Answer: B

When we link data maintained in an excel workbook to a word document the document contains a reference to the original source application.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

127.

Which area in an excel window allows entering values and formulas

A

Title bar

B

Menu bar

C

Formula bar

D

Standard toolbar

Correct Answer: C

Formula Bar is where data or formulas we enter into a worksheet appear for the active cell. The Formula Bar can also be used to edit data or formula in the active cell.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

128.

To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

A

Unfreeze panes command on the window menu

B

Freeze panes command on the window menu

C

Hold titles command on the edit menu

D

Split command on the window menu

Correct Answer: B

When we want to scroll down the worksheet, and lock the heading rows in place, so it is always visible, we can use one of the Freeze Panes commands.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

129.

To edit in an embedded excel worksheet object in a word document

A

Use the excel menu bar and toolbars inside the word application

B

Edit the hyperlink

C

Edit the data in a excel source application

D

Use the word menu bar and toolbars

Correct Answer: A

Use the excel menu bar and toolbars inside the word application to edit in an embedded excel worksheet object in a word document.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

130.

To edit in an embedded excel worksheet object in a word document

A

Use the excel menu bar and toolbars inside the word application

B

Edit the hyperlink

C

Edit the data in a excel source application

D

Use the word menu bar and toolbars

Correct Answer: A

Use the excel menu bar and toolbars inside the word application to edit in an embedded excel worksheet object in a word document.

Check Answer report_problem Report forum Discussion