Midterms

Front 1

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

Back 1

Cell styles

Front 2

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

Back 2

AutoFill options

Front 3

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 3

Mixed cell reference

Front 4

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

Back 4

Print entire workbook

Front 5

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

Back 5

Validation

Front 6

Other than using Microsoft Excel 2010 as a
spreadsheet tool, what other function can it
serve?

Back 6

Database tool

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

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

Back 8

Delete key

Front 9

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

Back 9

AutoComplete

Front 10

What is the proper method for adding
(inserting) columns into a worksheet?

Back 10

Click the Insert button on the Home
ribbon and choose the Insert Column
option

Front 11

Which Microsoft Excel 2010 feature
automatically inserts words, numbers, or
formulas that are a part of a series?

Back 11

AutoFill

Front 12

Where are user created styles able to be
used?

Back 12

In the workbook for which they are
created

Front 13

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

Back 13

String.

Front 14

70. Which area of the Microsoft Excel 2010
window displays the name of the workbook
that is active?

Back 14

Title bar