MS Excel MCQs

Question 1

You can use the horizontal and vertical scroll bars to

Accepted Answer

View different rows and columns edit the contents of a cell

Answer

Split a worksheet into two panes

Answer

Edit the contents of a cell

Answer

View different worksheets

Question 2

Multiple calculations can be made in a single formula using

Accepted Answer

Array formula

Answer

Standard formulas

Answer

Complex formulas

Answer

Smart formula

Question 3

Hyperlinks can be

Accepted Answer

All of above

Answer

Text

Answer

Drawing objects

Answer

Pictures

Question 4

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

Accepted Answer

None of the above

Answer

The Alt key

Answer

The Tab key

Answer

The Enter key

Question 5

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

Accepted Answer

The autosum button

Answer

The Formula button

Answer

The quicktotal button

Answer

The total button

Question 6

When the formula bar is active, you can see

Accepted Answer

All of the above

Answer

The edit formula button

Answer

The cancel button

Answer

The enter button

Question 7

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

Accepted Answer

The Format Painter button on the standard toolbar

Answer

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

Answer

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

Answer

There is no way to copy and apply formatting in Excel – You have to do it manually

Question 8

In a worksheet you can select

Accepted Answer

All of the above

Answer

The entire worksheet

Answer

Rows

Answer

Columns

Question 9

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

Accepted Answer

The word document contains a reference to the original source application

Answer

The word document cannot be edit

Answer

The word document must contain a hyperlink

Answer

The word document contains a copy of the actual data