Missed Test Vocab

Front 1

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

Back 1

Forward Slash

Front 2

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 2

Rows to repeat at the top

Front 3

Which button appears when cells are filled
with data in a series?

Back 3

AutoFill options

Front 4

When a formula contains references that
allow both the address to adjust and the
reference to remain constant, what is this
type of reference considered?

Back 4

Mixed cell reference

Front 5

What command on the Home ribbon allows
the user to search for AND replace specific
text in a worksheet are?

Back 5

Find

Front 6

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

Back 6

String.

Front 7

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

Back 7

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

Front 8

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

Back 8

File tab, open button

Front 9

Where are user created styles able to be
used?

Back 9

In the workbook for which they are
created

Front 10

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

Back 10

Chart

Front 11

Where are user created styles able to be
used?

Back 11

In the workbook for which they are
created

Front 12

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

Back 12

Validation

Front 13

Which command is used on the Home
ribbon to apply a style to selected cells in a
workbook?

Back 13

Cell styles