# Excel 2010 Test

25 Questions

A test for students beginning a unit on Excel 2010 to baseline their current knowledge of Excel and to determine their learning by comparing the results against a Post test to be given at the end of the unit of instruction.

• 1.
Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
• A.

Count

• B.

Average

• C.

Sum

• D.

• 2.
Is it possible to insert an image from a file into an Excel spreadsheet?
• A.

Yes

• B.

No

• 3.
The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____
• A.

A1-J15

• B.

A1.J15

• C.

A1;J15

• D.

A1:J15

• 4.
“Month 1, Month 2, Month 3” is an example of what?
• A.

Series

• B.

Function

• C.

Formula

• D.

Syntax

• 5.
How does a relative reference differ from an absolute reference?
• A.

A relative reference specifies column and row references

• B.

A relative reference adjusts to its location on the worksheet

• C.

A relative reference refers to an existing cell reference

• D.

A relative reference refers to an original value

• 6.
Which of the following is an absolute cell reference?
• A.

P72

• B.

G\$9

• C.

\$K356

• D.

\$F\$8

• 7.
What is the name given to a value that does NOT change when used within a formula?
• A.

Reference

• B.

Constant

• C.

Function

• D.

• 8.
What name is given to the chart background?
• A.

Chart area

• B.

Background area

• C.

Legend area

• D.

Plot area

• 9.
The Chart Tools commands are found in these three tabs?
• A.

Design, Shape, Layout

• B.

Layout, Format, Type

• C.

Design, Layout, Format

• D.

Styles, Shapes, Effects

• 10.
Which of the following is an mixed cell reference with a fixed column address?
• A.

P72

• B.

G\$9

• C.

\$K356

• D.

\$F\$8

• 11.
Which of the following is mixed cell reference with a fixed row address?
• A.

P72

• B.

G\$9

• C.

\$K356

• D.

\$F\$8

• 12.
Which of the following is a relative cell reference?
• A.

P72

• B.

G\$9

• C.

\$K356

• D.

\$F\$8

• 13.
• A.

:

• B.

{

• C.

=

• D.

/

• 14.
• A.

A worksheet tab is used to access tools associated with the worksheet

• B.

A worksheet tab is used to move from one cell to the next cell in a worksheet

• C.

A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet

• D.

A worksheet tab is used to get help when working with Microsoft Excel 2010.

• 15.
• A.

Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing

• B.

No, data in a cell can only be changed by creating a copy of the original spreadsheet into a new spreadsheet

• C.

No, once a file is saved, cell data cannot be changed

• D.

Yes, but the file must be saved with a different file name

• 16.
Which feature in Excel allows you to view two spreadsheets in one window?
• A.

Freeze panes

• B.

Split

• C.

View side by side

• D.

Mirror

• 17.
Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?
• A.

#

• B.

%

• C.

&

• D.

\$

• 18.
• A.

The formula in the cell is wrong

• B.

There are too many characters in the cell to be displayed with the current cell width

• C.

The decimal point placement in the cell is wrong

• D.

All of the above

• 19.
• A.

Seperate the page into two for easier printing

• B.

Use the Fit to Page option

• C.

Highlight all cells to print and print selection

• D.

None of the above

• 20.
• A.

The #REF! error value occurs when a cell reference is not valid.

• B.

The #REF! error value occurs when a cell has been formatted as a currency but contains text.

• C.

The #REF! error value occurs when a cell contains a number with two decimal separators (points) present.

• D.

None of the above

• 21.
How do you select noncontiguous cells?
• A.

Click a cell, then hold down SHIFT on the keyboard and select the other cells

• B.

Click in a cell, then hold down ALT on the keyboard as you select the other cells

• C.

Click in a cell, hold down CTRL on the keyboard and then select the other cells

• D.

Click in a cell, then hold down SHIFT as you move from cell to cell using the Arrow keys on the keyboard

• 22.
Which function would you use to find the largest number of a selected range?
• A.

MAXIMUM

• B.

MAX

• C.

LARGE

• D.

LARGEST

• 23.
According to the picture the selected cell in yellow corresponds to:
• A.

Column A, Row A11, Cell 11

• B.

Column 11, Row A, Cell 11A

• C.

Column 11, Row A, Cell A11

• D.

Column A, Row 11, Cell A11

• 24.
Inserting Page Number is in Header and Footer
• A.

True

• B.

False

• 25.
A_________ is a built in mathematical formula included in excel.
• A.

Function

• B.

Cell

• C.

Formula

• D.

Range

Related Quizzes
Featured Quizzes
Related Topics