# Test Your Knowledge On Microsoft Excel Quiz

20 Questions  Settings  MULTIPLE CHOICE QUESTIONS AND TRUE/FALSE            Put your answers to the left of the numberaNS

Related Topics
• 1.
Tutorial 1Excel is an electronic version of a(n)
• A.

Database

• B.

• C.

Expression

• D.

Formula

• 2.
Tutorial 1Excel stores its documents as files called
• A.

Worksheets

• B.

Sheet tabs

• C.

Workbooks

• D.

Books

• 3.
Tutorial 1A(n) ____ is a group of cells.
• A.

Cluster

• B.

• C.

Selection

• D.

Range

• 4.
Tutorial 1The characters +, -, *, and / are examples of
• A.

Formulas

• B.

Values

• C.

Arithmetic operators

• D.

Calculations

• 5.
Tutorial 1The formula used to multiply cell A1 by cell C1 is ____.
• A.

=A1*C1

• B.

C1*A1

• C.

=A1/C1

• D.

A1*C1

• 6.
Tutorial 2 TRUE/FALSE          Formatting changes only the appearance of data - it does not affect the data itself.
• A.

True

• B.

False

• 7.
Tutorial 2 TRUE/FALSE                    You can use a picture or image as the background for all the cells in a worksheet.
• A.

True

• B.

False

• 8.
Tutorial 2 TRUE/FALSEBackground images do not print in Excel.
• A.

True

• B.

False

• 9.
Tutorial 2 TRUE/FALSEWhen using a data bar, changing the value of one cell in the range will not affect the size of all the other cells’ data bars.
• A.

True

• B.

False

• 10.
Tutorial 2 TRUE/FALSEIn Excel, if the built-in styles don’t meet your needs, you can modify an existing style or create a new one.
• A.

True

• B.

False

• 11.
Tutorial 3The PMT function is a(n) ____ function.
• A.

Date

• B.

IF

• C.

Financial

• D.

Statistical

• 12.
Tutorial 3 The F  FV function stands for ____.
• A.

Function value

• B.

Future value

• C.

Financial value

• D.

Formulated value

• 13.
Tutorial 3  Abs     Abolute references are marked with a ____.
• A.

• B.

:

• C.

\$

• D.

!

• 14.
Tutorial 3           When  you copy a formula that contains an absolute reference to a new location, the reference ____.
• A.

Is updated automatically

• B.

Does not change

• C.

Becomes bold

• D.

Has a dotted outline in its cell

• 15.
Tutorial 3Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?
• A.

SUM

• B.

COUNT

• C.

COUNTA

• D.

AUTOSUM

• 16.
Tutorial 4Every chart must have a data source.
• A.

True

• B.

False

• 17.
Tutorial 4 For     For  which of the following reasons would you choose to use a chart or graph?
• A.

To organize information in columns and rows

• B.

To show trends or relationships across data

• C.

To present data using text only

• D.

To add color to a report

• 18.
Tutorial 4To move or resize an embedded chart, ____.
• A.

Select the chart and drag the selection box

• B.

Drag the resize handle on the selection box

• C.

Select the chart and press Tab

• D.

Both a and b

• 19.
Tutorial 4A(n) ____________________ is a visual representation of a set of data.
• A.

Chart

• B.

Graph

• 20.
Tutorial 4Excel supports ____________________ built-in charts.
• A.

73

• B.

75