Midterm

Front 1

Which key on the keyboard is used to
display KeyTip in Access 2010?

Back 1

ALT

Front 2

Which command on the Home Ribbon is
used to search for records that satisfy a
specific criterion

Back 2

Find

Front 3

What part of the formula is entered directly
as a value?

Back 3

constant.

Front 4

What allows the user to organize
multiple workbook windows so that all are
visible?

Back 4

Arrange

Front 5

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

Back 5

Chart

Front 6

What are questions asked of a database in
which the answers are given through the
data in the database called?

Back 6

Queries

Front 7

In Access 2010, which area provides
indicators and buttons based on
information you type or tasks that are
performed?

Back 7

Status bar

Front 8

If the data is too large for the cell and is
typed into the adjacent cells where data is
already located, what happens to the data?

Back 8

The overlapping data is truncated.

Front 9

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

Back 9

Unbound controls

Front 10

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

Back 10

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

Front 11

Which command on the Home Ribbon is
used to search a field for a collection of
selected characters?

Back 11

Selection

Front 12

What must be done to include multiple
tables that contain identical values in
matching fields?

Back 12

Join

Front 13

When operating an Access 2010 Database,
why would a security warning appear
below the Ribbon area?

Back 13

To notify you that some content is
disabled due to your computer's security
settings

Front 14

What is used to remove at once all records
that meet specific criteria?

Back 14

Delete Query

Front 15

Aligning data within a cell is completed by
clicking on which group on the Home
ribbon?

Back 15

Alignment

Front 16

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

Back 16

String.

Front 17

What key will allow the user to select nonadjacent
cells?

Back 17

CTRL key

Front 18

Why do users want to modify an existing
style?

Back 18

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

Front 19

Which function will find the minimum
value in a selected area?

Back 19

Min

Front 20

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

Back 20

File Tab

Front 21

What ribbon is used to create charts in a
workbook?

Back 21

Insert ribbon

Front 22

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 22

Rows to repeat at the top

Front 23

What is the process used when copying a
worksheet in one workbook and pasting it
into another workbook?

Back 23

Right-click the sheet tab to choose move
or copy from the shortcut menu and then
choose the destination workbook from the
drop-down list.

Front 24

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

Back 24

Validation

Front 25

Which type of operator enables a user to
equate two values in a Query criterion

Back 25

Comparison

Front 26

When entering data into a table which is
NOT a method to correct typing errors?

Back 26

Delete the entire record, by clicking the
record selector and choosing the delete
command

Front 27

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

Back 27

Print entire workbook

Front 28

Which window component in Access 2010
enables a user to navigate through different
portions of an object in a work area?

Back 28

Scroll bars

Front 29

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

Back 29

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

Front 30

The area of the Microsoft Excel that
contains the view and zoom buttons is
known as the

Back 30

status bar.

Front 31

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 31

Shorcut Menu

Front 32

Which is NOT one of the three basic parts
of the report

Back 32

Page border

Front 33

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

Back 33

Grouping & Tools

Front 34

How is a Query stored after it is created
and saved?

Back 34

As a database object

Front 35

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

Back 35

Delete key