True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
A worksheet is a much more effective way to communicate data to an audience than
a chart.
|
|
|
2.
|
Excel provides many tools for creating charts to help you communicate key trends
and facts about your worksheet data.
|
|
|
3.
|
A trendline is a line that connects high or low points in a data series and
shows a trend.
|
|
|
4.
|
After creating a chart you cannot change the chart type.
|
|
|
5.
|
Once you have created a chart you cannot change the size of it.
|
|
|
6.
|
You can change the positioning and attributes of individual chart objects by
choosing from additional preset options on the Chart Tools Layout tab, or by making custom choices in
the Format dialog box.
|
|
|
7.
|
A data table in a chart is a grid containing the chart’s underlying
worksheet data.
|
|
|
8.
|
Excel only has a couple of styles and effects to improve the appearance of a
chart and increase its visual appeal and effectiveness.
|
|
|
9.
|
You can used Microsoft Word to create a database to help you manage and track a
large collection of related data.
|
|
|
10.
|
A database is limited to what type of information it can contain.
|
|
|
11.
|
By default, Access 2010 saves new databases with the extension .mdb.
|
|
|
12.
|
When you start working in a new database, a blank table opens in Datasheet
view.
|
|
|
13.
|
Design view is the best view for modifying a table’s structure.
|
|
|
14.
|
You can apply a filter to an Access table to display only those records that
meet criteria that you specify.
|
|
|
15.
|
In Edit view, you can add or delete fields, specify a sort order for one or more
fields, or specify criteria for fields.
|
|
|
16.
|
You can use Design view instead of a Query Wizard to create a query.
|
|
|
17.
|
Criteria is case sensitive.
|
|
|
18.
|
Spotting statistical trends in a large database is usually easy.
|
|
|
19.
|
You may need to move or resize columns in a report so that all the fields and
data are visible and look good on the page.
|
|
|
20.
|
Report data can be from one or multiple database objects.
|
Modified True/False
Indicate
whether the statement is true or false. If false, change the identified word or phrase to make the
statement true.
|
|
|
21.
|
A(n) data series is a sequence of related numbers that shows a trend.
__________________________
|
|
|
22.
|
When you create a chart, each chart object has default layout settings
applied. __________________________
|
|
|
23.
|
The Chart Tools Layout tab contains buttons and commands for changing the
layout of a selected chart. __________________________
|
|
|
24.
|
You can select an object by clicking it or by using the Chart Elements list
arrow on the Graph Tools Format tab. __________________________
|
|
|
25.
|
Data series identify the values on each axis.
__________________________
|
|
|
26.
|
Legends are helpful when your chart contains data from another worksheet
or location. __________________________
|
|
|
27.
|
Creating a database from a(n) template can save time because it contains
ready-made database objects, such as tables structured with field names, appropriate to a particular
type of database. __________________________
|
|
|
28.
|
Before you begin adding fields to a table it is a good idea to review the
table. __________________________
|
|
|
29.
|
In Datasheet view you can add fields to a table and view any data that
the table contains. __________________________
|
|
|
30.
|
To rename a field, single click the field name and then type the new
name. __________________________
|
|
|
31.
|
Databases usually contain many worksheets.
__________________________
|
|
|
32.
|
You must save changes to an object before switching views.
__________________________
|
|
|
33.
|
You use the Navigation Pane to view and change properties for a selected
field. __________________________
|
|
|
34.
|
You can press F11 to open or close the Navigation Pane.
__________________________
|
|
|
35.
|
The simplest way to sort a table is to select a field that matches your
criterion, and then use the Equals command to display those records that match the selection.
_________________________
|
|
|
36.
|
To specify multiple criteria for a field, type additional criteria in the
Or cell for that field in the query design grid. _________________________
|
|
|
37.
|
You can add fields to a report in Layout view.
_________________________
|
|
|
38.
|
You can add summary information to a report while creating the report with the
Report Wizard. _________________________
|
|
|
39.
|
Applying numerical formatting is a great way to draw attention to
information that meets specific criteria. _________________________
|
|
|
40.
|
When viewing a report, the Zoom Out pointer appears when you place the
pointer over the report. _________________________
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
41.
|
____ are tiny charts that fit in one cell and illustrate trends in selected
cells.
a. | Firelines | c. | Sparklines | b. | Fireboxes | d. | Sparkboxes |
|
|
|
|
|
|
42.
|
In the accompanying figure, item 3 points to a ____.
a. | record | c. | database | b. | field | d. | set of tables |
|
|
|
43.
|
You can create a database in Access by starting with a ____.
a. | blank database | c. | Both a and b. | b. | template | d. | None of the
above. |
|
|
|
|
|
|
44.
|
In the accompanying figure, item 3 points to the____.
a. | featured templates | c. | available template categories | b. | recently opened
databases | d. | Blank Database
icon |
|
|
|
45.
|
When sorting on more than one field, the field that is the primary sort
field, is called the ____ sort field.
a. | outside | c. | innermost | b. | outermost | d. | inside |
|
|
|
46.
|
You can apply a(n) ____ Filter to a selected field to filter records that are
greater than, less than, or equal to a specific number, or between two different numbers.
a. | Number | c. | Equation | b. | Mathematical | d. | Limiting |
|
|
|
47.
|
A query that retrieves or selects data from one or more tables or queries
according to your criteria is known as a(n) ____ query.
a. | filter | c. | select | b. | object | d. | retrieve |
|
|
|
|
|
|
48.
|
In the accompanying figure, item 2 points to a ____.
a. | record | c. | query | b. | field | d. | filter |
|
|
|
49.
|
____ view looks similar to Print Preview, except that it displays the report in
a continuous flow, without page breaks.
a. | Document | c. | Report | b. | Page | d. | Design |
|
|
|
50.
|
The summary calculation that calculates the largest value in the field is
____.
|
Completion
Complete each
statement.
|
|
|
51.
|
_____________________ is the data type that assigns unique sequential numbers to
each new record, which cannot be edited.
|
|
|
52.
|
Every table in a database must contain one field that is designated as the
_____________________ field.
|
|
|
53.
|
A(n) ____ is a combination of fields, values, and mathematical operators.
|
|
|
54.
|
When you enforce ____ in related tables, any changes you make to fields in one
table are instantly reflected in all related tables on queries that contain that field.
|
|
|
55.
|
____________________ information in a report displays statistics about one or
more fields in a database.
|