MS Excel MCQs

Question 1

What is represented by the small, black square in the lower-right corner of an active cell or range?

Accepted Answer

Fill handle

Answer

Copy handle

Answer

Insert handle

Answer

Border

Question 2

In Excel, a Data Series is defined as what?

Accepted Answer

A collection of related data

Answer

A type of chart

Answer

A cell reference

Answer

A division of results

Question 3

In Excel, the Fill Color button on the Formatting toolbar is used for what?

Accepted Answer

To add shading or color to a cell range

Answer

To insert a background

Answer

To add borders

Answer

To select a distribution of figures

Question 4

In help menu of Excel, which of the following tabs are found?

Accepted Answer

all of the above

Answer

Contents tab

Answer

Answer Wizard tab

Answer

Index tab

Question 5

A ________ is a grid with labeled columns and rows.

Accepted Answer

Worksheet

Answer

Dialog box

Answer

Clipboard

Answer

Toolbar

Question 6

The active cell:

Accepted Answer

Only A and B

Answer

Is defined by a bold border around the cell

Answer

Receives the data the user enters

Answer

It is the formula bar

Question 7

Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

Accepted Answer

Financial

Answer

Logical

Answer

Math & Trigonometry

Answer

Statistical

Question 8

B7:B9 indicates:

Accepted Answer

Cells B7 through B9

Answer

Cells B7 and cell B9 only

Answer

Cell B8 only

Answer

None of the above

Question 9

The Cancel and Enter buttons appear in the:

Accepted Answer

Formula bar

Answer

Title bar

Answer

Menu bar

Answer

Sheet tabs