Ms. Davis Office 1 Final Exam Short
True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
In
Access, a database consists of a collection of tables.
|
|
|
2.
|
In
Access, all the tables, report, forms, and queries are stored in separate files. Collectively, these
files are called a database.
|
|
|
3.
|
To
move from Form view to Datasheet view, click the View button down arrow on the Form View toolbar and
then click Datasheet View in the list that displays.
|
|
|
4.
|
The
asterisk (*) wildcard represents any individual character.
|
|
|
5.
|
To
create a compound criterion using OR, enter each criterion on different lines.
|
|
|
6.
|
To
display the entire entry for a calculated field, select the column in the Field row, right-click to
display the shortcut menu, and then click Zoom.
|
|
|
7.
|
To
find the largest amount paid amount for a customer, select LARGE as the entry in the Total row for
the Amount Paid column.
|
|
|
8.
|
To
filter records based on values in more than one field, click the Filter By Form button rather than
the Filter By Selection button.
|
|
|
9.
|
Fields can be added to a table structure and deleted from a table
structure.
|
|
|
10.
|
An
add query adds a group of records from one table to the end of another table.
|
|
|
11.
|
To
specify a required field validation rule for a field, select the field, click the Required property
box in the Field Properties area, click the down arrow that displays, and then click Yes in the
list.
|
|
|
12.
|
To
obtain a printed copy of the relationships within a database, display the Relationships window, click
File on the menu bar, and then click Print Relationships.
|
|
|
13.
|
Most
formats assigned to a cell will display on the Standard toolbar when the cell is
selected.
|
|
|
14.
|
A
password can be up to 15 characters long and is case-sensitive, meaning Excel can differentiate
between uppercase and lowercase letters.
|
|
|
15.
|
If a
print area is not selected, Excel automatically prints all 16,777,216 cells in the
worksheet.
|
|
|
16.
|
The
formulas version of a worksheet usually is significantly narrower than the values
version.
|
|
|
17.
|
When
the system date is entered, the date displays left-aligned in the cell because Excel treats the date
as text.
|
|
|
18.
|
To
enter an absolute reference, the dollar sign ($) can be typed as part of the cell reference or with
the insertion point to the right of the cell reference to be changed to absolute, the F4 key can be
pressed.
|
|
|
19.
|
To
split the window into four panes, first select the cell where the panes should
intersect.
|
|
|
20.
|
When
a window is split into panes, any change made in one pane has no effect in the other
panes.
|
|
|
21.
|
When
goal seeking, the cell to change has to be referenced directly in the formula or
function
|
|
|
22.
|
A
dimmed command on a short or full menu indicates that it is not available for a current selection in
a menu.
|
|
|
23.
|
A
docked toolbar is attached to the edge of the Word window.
|
|
|
24.
|
When
a word has been flagged with a red wavy underline it indicates that it is not in Word’s
dictionary.
|
|
|
25.
|
Each
time the ENTER key is pressed Word creates a new paragraph.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
26.
|
A(n)
__________ contains information about a given person, product, or event. a. | attribute | c. | field | b. | column | d. | record | | | | |
|
|
|
27.
|
The
general name for the type of approach that Access uses for querying a database is QBE, which means
__________. a. | Query-By-Example | c. | Question-By-Entering | b. | Question-By-Example | d. | Query-By-Entering | | | | |
|
|
|
28.
|
The
set of records that make up the answer to a query will be displayed in __________
view. a. | Virtual | c. | Form | b. | Datasheet | d. | Dynamic | | | | |
|
|
|
29.
|
When
an expression is entered for a calculated field, the field names used in the expression must be
enclosed in __________. a. | square brackets ([ ]) | c. | quotation marks (“ “) | b. | curly braces ({
}) | d. | parentheses ((
)) | | | | |
|
|
|
30.
|
To
use a built-in statistic in a query, include the statistic in the _________ row in the design
grid. a. | Field | c. | Total | b. | Sort | d. | Criteria | | | | |
|
|
|
31.
|
To
include the Total row in the design grid, right-click the grid, and then click ________on the
shortcut menu. a. | Totals | c. | Function | b. | Statistics | d. | Calculations | | | | |
|
|
|
32.
|
To
make changes to the structure of a table, right-click the table in the Database window and then click
__________ on the shortcut menu. a. | Change | c. | Structure | b. | Restructure | d. | Design
View | | | | |
|
|
|
33.
|
To
use a delete query to delete all records with the value GA in the State field, create a new query for
the Client table, select Delete from the Query Type on the shortcut menu, place the State field in
the design grid, and then enter GA in the __________ row. a. | Criteria | c. | Show | b. | Delete | d. | Update To | | | | |
|
|
|
34.
|
A
field has the format < in the Format box. If you type me93 in the field it
will display as __________.
|
|
|
35.
|
A(n)
__________ key is a field in one table whose values are required to match a primary key of another
table. a. | secondary | c. | foreign | b. | auxiliary | d. | matching | | | | |
|
|
|
36.
|
To
order records in the Customer table in ascending order by amount paid amount, click the Amount Paid
field and then click the __________ button on the toolbar. a. | Records
Ascending | c. | Sort
Ascending | b. | Order Ascending | d. | Sort Same | | | | |
|
|
|
37.
|
To
display the Language bar, point to the Speech command on the __________ and then click the Speech
Recognition command on the Speech submenu. a. | Edit menu | c. | Tools menu | b. | Insert
menu | d. | Window
menu | | | | |
|
|
|
|
|
|
38.
|
In
the AutoFormat dialog box shown in the accompanying figure, the __________ allows additional formats
to be selected and assigned as part of the selected customized format. a. | Cancel
button | c. | Question Mark
button | b. | OK button | d. | Options button | | | | |
|
|
|
39.
|
When
the Tools button in the Save As dialog box is clicked, the __________ in the list that displays
allows a backup copy of the workbook to be saved, a password to limit access to the workbook to be
created, and other functions to be carried out. a. | Add to Favorites command | c. | Properties command | b. | Web Options
command | d. | General Options
command | | | | |
|
|
|
40.
|
The
__________ close Excel. a. | Close button and Control-menu icon on the menu
bar | b. | Minimize button
and Restore icon on the menu bar | c. | Close button and Control-menu icon on the title
bar | d. | Minimize button
and Restore icon on the title bar | | |
|
|
|
41.
|
To
clear an entire worksheet, click the __________ and then press the DELETE key. a. | Undo button on
the Standard toolbar or press CTRL+U | b. | None button in the AutoCalculate area or press
CTRL+N | c. | Cells button on the Formatting toolbar or press
CTRL+C | d. | Select All button on the worksheet or press
CTRL+A | | |
|
|
|
42.
|
In
Excel, functions can be entered using any of the following methods except the
__________. a. | Function command
on the Tools menu | b. | keyboard or mouse | c. | Insert Function
box on the formula bar | d. | AutoSum menu or Voice Command mode | | |
|
|
|
43.
|
The
__________ in the Conditional Formatting dialog box can be used to remove one or more active
conditions. a. | Add
button | c. | Cancel
button | b. | Delete button | d. | Format button | | | | |
|
|
|
44.
|
To
save a workbook a second time using a new name or on a different drive, __________. a. | click Save on
the File menu | c. | click Save As on
the File menu | b. | press SHIFT+F12 | d. | press CTRL+S | | | | |
|
|
|
45.
|
If
formulas located in other cells reference cells in a deleted row or column, Excel displays the error
message __________ in those cells to indicate a cell reference error. a. | #VALUE! | c. | #NULL! | b. | #N/A! | d. | #REF! | | | | |
|
|
|
46.
|
In
any of the four Chart Wizard dialog boxes, the __________ button can be clicked to return to the
previous Chart Wizard dialog box. a. | Cancel | c. | Next | b. | Back | d. | Finish | | | | |
|
|
|
47.
|
If
the result a formula should produce is known, the __________ on the Tools menu can be used to
determine the value of a cell on which the formula depends. a. | Track Changes
command | c. | Share Workbook
command | b. | Data Analysis command | d. | Goal Seek command | | | | |
|
|
|
48.
|
Goal
seeking assumes the value of __________ referenced directly or indirectly can be
changed. a. | no
cells | c. | two or more
cells | b. | only one cell | d. | any number of cells | | | | |
|
|
|
49.
|
A
short horizontal line indicating the conclusion of a document is the __________. a. | insertion
point | c. | status
indicator | b. | end mark | d. | scroll box | | | | |
|
|
|
50.
|
The
scroll box on the vertical scroll bar indicates the __________. a. | position of the
insertion point from the top of the page | b. | distance of the insertion point from the left
margin | c. | current relative location of the insertion point in the
document | d. | rank of the word in which the insertion point is
found | | |
|