Pretest Vocab

Front 1

Which Group on the Report Layout Tools
Design Ribbon contains the command to
include an automatic calculation on a
Report?

Back 1

Grouping & Tools

Front 2

What helps in navigating a worksheet?

Back 2

Scroll bars

Front 3

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

Back 3

AutoFill options

Front 4

Where are the command buttons to cut,
copy, or paste items in Microsoft Excel
2010 located?

Back 4

Home ribbon

Front 5

Which print orientation displays the
printout across the 8.5 inch width of the
page?

Back 5

Portrait

Front 6

Which view is used to make changes to a
Report but does not display the actual
Report?

Back 6

Design view

Front 7

What type of query calculates a statistic for
data that is grouped by two different types
of information?

Back 7

Crosstab

Front 8

Which of the following is divided into
various sections to help clarify the
presentation of the data from the
database?

Back 8

Report

Front 9

In a table, which is a way of exclusively
identifying each record in the database?

Back 9

Unique identifier

Front 10

Which area contains the command to view
or change information about a database
file?

Back 10

File Tab

Front 11

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

Back 11

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

Front 12

Which type of relationship means that a
record in the first table is related or
matches more than one record in the
second table?

Back 12

One to Many

Front 13

What is the name of the small arrow in the
lower right corner of a Ribbon group that
provides access to additional options for the
group?

Back 13

Dialog Box Launcher

Front 14

Which Access 2010 feature provides onscreen
notes containing the name of the
command, available keyboard shortcuts, a
description of the command, and directions
for getting help using the command?

Back 14

Enhanced ScreenTip

Front 15

Where is the command to undo your most
recent change in Access 2010 located?

Back 15

Shortcut menu

Front 16

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

Back 16

Validation

Front 17

Where are user created styles able to be
used?

Back 17

In the workbook for which they are
created

Front 18

When a user of Access 2010 right clicks on
an object, what is the name of the list of
frequently used commands that displays?

Back 18

Shorcut Menu

Front 19

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

Back 19

String.

Front 20

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

Back 20

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

Front 21

What is the process for creating a hyperlink
to an existing web page in Microsoft Excel
2010?

Back 21

Type in the web address and by default
automatic hyperlink formatting is turned
on.

Front 22

When a formula is copied from one cell to
another, what allows the cell address to
adjust the column letter and row number to
the new copy location?

Back 22

Relative cell reference

Front 23

Which of the following is a formatted
document containing fields with data that is
typically used for data entry in Access
2010?

Back 23

Form

Front 24

What type of join displays all records from
one table and the common records from
another table?

Back 24

Outer

Front 25

Which order must be followed from left to
right if more than two operators are used in
a formula?

Back 25

Order of operation

Front 26

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

Back 26

Header.

Front 27

Which term describes the process of
periodically making a copy of a database to
protect it in the event of failure or
damage?

Back 27

Backing up

Front 28

What do you insert into a worksheet to
cause the data start on a new page when
printing?

Back 28

Page Break

Front 29

Why do users want to modify an existing
style?

Back 29

Once modified, all cells formatted with
that style will be automatically updated.

Front 30

What will divide a worksheet into multiple
panes in order to have more cells visible?

Back 30

Split

Front 31

Which of the following is used to display
information that does not come from the
database in a report?

Back 31

Sections

Front 32

What controls the landscape or portrait
print function?

Back 32

Orientation