Test Correction

Front 1

Which Microsoft Excel 2010 feature
automatically inserts data into a cell that
begins with the same characters as a
previous entry?

Back 1

AutoComplete

Front 2

Which command appears in the lower right
corner of pasted cells and enables the user
to specify how to past the information?

Back 2

Paste options

Front 3

Which command appears in the lower right
corner of pasted cells and enables the user
to specify how to past the information?

Back 3

Paste options

Front 4

The command on the Page Layout ribbon
that refers to data printed on the top of
each worksheet page is the:

Back 4

Header.

Front 5

When saving a file in Microsoft Excel 2010,
which symbol is NOT to be used in the file
name?

Back 5

/ (forward slash)

Front 6

In Microsoft Excel 2010, a single character,
word, or phrase is referred to as the:

Back 6

String.

Front 7

In Microsoft Excel 2010, which is a
graphical representation of data that is
created from information in a workbook?

Back 7

Chart

Front 8

Which number format button does NOT
appear in the number group on the Home
ribbon?

Back 8

102 (scientific)

Front 9

Which command in the Print tab backstage
view must be selected to print all sheets in a
workbook?

Back 9

Print entire workbook

Front 10

18. On multi-page worksheets, what page
layout option should you choose in order to
have information repeated along the top of
each page and make the data easily
readable?

Back 10

Rows to repeat at the top

Front 11

Where is the command to create a new
folder in the user's storage device for
Microsoft Excel 2010 files located?

Back 11

File tab, open button

Front 12

Which command appears in the lower right
corner of pasted cells and enables the user
to specify how to past the information?

Back 12

Paste options

Front 13

Which built-in Microsoft Excel 2010
feature ensures that data entered into a cell
range of cells is within limits?

Back 13

Validation

Front 14

Which Microsoft Excel 2010 feature
automatically inserts data into a cell that
begins with the same characters as a
previous entry?

Back 14

AutoComplete

Front 15

Where are user created styles able to be
used?

Back 15

In the workbook for which they are
created

Front 16

When entering data into a cell, which
keyboard key is used to remove characters
to the right of the insertion point?

Back 16

Delete key

Front 17

Where is the command to create a new
folder in the user's storage device for
Microsoft Excel 2010 files located?

Back 17

File tab, open button

Front 18

Since cells in a chart are linked to the data
in the worksheet, how would you update
data on a chart?

Back 18

Change the data on the corresponding
worksheet, and the chart will
automatically be updated.