Mr. Winter Office 1 Final Exam
True/False
Indicate whether the sentence or statement is true or
false.
|
|
|
1.
|
To find the largest amount paid amount for a customer, select LARGE as the entry
in the Total row for the Amount Paid column.
|
|
|
2.
|
To filter records based on values in more than one field, click the Filter By
Form button rather than the Filter By Selection button.
|
|
|
3.
|
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.
|
|
|
4.
|
The formulas version of a worksheet usually is significantly narrower than the
values version.
|
|
|
5.
|
To create a compound criterion using OR, enter each criterion on different
lines.
|
|
|
6.
|
Excel has hundreds of toolbar buttons, most of which display on 19 built-in
toolbars.
|
|
|
7.
|
The column border, the border to the right of a column, can be dragged until a
row is at a desired height.
|
|
|
8.
|
Fields can be added to a table structure and deleted from a table
structure.
|
|
|
9.
|
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.
|
|
|
10.
|
In a business letter, the inside address, placed three to eight lines below the
date line, usually contains the sender’s title plus full name, business affiliation, and full
geographical address.
|
|
|
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.
|
When you click Header and Footer on the View menu bar, Word switches from print
layout view to normal view and displays the Header and Footer toolbar.
|
|
|
13.
|
When a multiple-field index is created, Access automatically assigns a name to
the index.
|
|
|
14.
|
When you change the margin settings in the text boxes in the Page Setup dialog
box, the Preview area adjusts to reflect a changed margin setting.
|
|
|
15.
|
A dimmed command on a short or full menu indicates that it is not available for
a current selection in a menu.
|
|
|
16.
|
The basic content of a group of form letters is the same; however, items like
name and address are the different from one letter to the next.
|
|
|
17.
|
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.
|
|
|
18.
|
The first step in the mail merge process is to identify the main
document.
|
|
|
19.
|
It is possible that the same document could wordwrap on different words if
printed on different printers.
|
|
|
20.
|
When you drag the Hanging Indent marker, the Left Indent marker moves with
it.
|
|
|
21.
|
When the system date is entered, the date displays left-aligned in the cell
because Excel treats the date as text.
|
|
|
22.
|
If a print area is not selected, Excel automatically prints all 16,777,216 cells
in the worksheet.
|
|
|
23.
|
A docked toolbar is attached to the edge of the Word window.
|
|
|
24.
|
When a window is split into panes, any change made in one pane has no effect in
the other panes.
|
|
|
25.
|
In Access, all the tables, report, forms, and queries are stored in separate
files. Collectively, these files are called a database.
|
|
|
26.
|
The asterisk (*) wildcard represents any individual character.
|
|
|
27.
|
When a word has been flagged with a red wavy underline it indicates that it is
not in Word’s dictionary.
|
|
|
28.
|
Word provides an Undo button on the Standard toolbar that can be used to cancel
the most recent command or action, including typing.
|
|
|
29.
|
In Access, a database consists of a collection of tables.
|
|
|
30.
|
To split the window into four panes, first select the cell where the panes
should intersect.
|
|
|
31.
|
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.
|
|
|
32.
|
Tables can be centered horizontally between the left and right margins.
|
|
|
33.
|
Columns in which the text in each column uses the same amount of vertical space
are said to be snaking columns.
|
|
|
34.
|
Most formats assigned to a cell will display on the Standard toolbar when the
cell is selected.
|
|
|
35.
|
When goal seeking, the cell to change has to be referenced directly in the
formula or function
|
|
|
36.
|
The shortcut keys, CTRL+ENTER, instruct Word to insert an automatic page break
immediately above the insertion point and position the insertion point immediately below the
automatic page break.
|
|
|
37.
|
An add query adds a group of records from one table to the end of another
table.
|
|
|
38.
|
The end mark will display one blank line above the insertion point when line
spacing is single.
|
|
|
39.
|
A password can be up to 15 characters long and is case-sensitive, meaning Excel
can differentiate between uppercase and lowercase letters.
|
|
|
40.
|
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.
|
|
|
41.
|
Each row in a data source is called a __________.
a. | header row | c. | data field | b. | footer row | d. | record |
|
|
|
42.
|
To instruct Word to stop bulleting paragraphs, press the ENTER key __________
the Bullets button.
a. | once or click | c. | once or double-click | b. | twice or click | d. | twice or
double-click |
|
|
|
43.
|
In print preview, the Print Preview toolbar displays __________.
a. | above the menu bar, but below the Standard and Formatting
toolbars | b. | below the menu bar; the Standard and Formatting toolbars disappear from the
screen | c. | above the Standard and Formatting toolbars, but below the menu
bar | d. | below the Standard and Formatting toolbars; the menu bar disappears from the
screen |
|
|
|
44.
|
The difference between a text box and a frame is that __________.
a. | a frame has more graphical formatting options than does a text
box | b. | a frame is more versatile | c. | a text box has more graphical formatting
options than does a frame | d. | there is no
difference |
|
|
|
45.
|
When creating a hyperlink, as soon as the ENTER key is pressed after typing a
Web address, the Web address is __________.
a. | italicized and colored red | c. | underlined and colored
red | b. | italicized and colored blue | d. | underlined and colored blue |
|
|
|
46.
|
With Word’s AutoCorrect entries, to display an indifferent face (K) type __________.
|
|
|
47.
|
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 |
|
|
|
48.
|
Moving from left to right in a formula, the order of operations is as follows:
first negation (-), then all __________.
a. | exponentiations (^), then all percentages (%), then all multiplications (*) and
divisions (/), and finally, all additions (+) and subtractions (–) | b. | percentages (%),
then all exponentiations (^), then all multiplications (*) and divisions (/), and finally, all
additions (+) and subtractions (–) | c. | exponentiations (^), then all percentages (%),
then all additions (+) and subtractions (–), and finally, all multiplications (*) and divisions
(/) | d. | percentages (%), then all exponentiations (^), then all additions (+) and
subtractions (–), and finally, all multiplications (*) and divisions
(/) |
|
|
|
49.
|
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! |
|
|
|
50.
|
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 |
|
|
|
|
|
|
51.
|
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 |
|
|
|
52.
|
A(n) __________ contains information about a given person, product, or
event.
a. | attribute | c. | field | b. | column | d. | record |
|
|
|
53.
|
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 |
|
|
|
54.
|
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 |
|
|
|
55.
|
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 |
|
|
|
56.
|
Each time the __________ key is pressed, the paragraph formatting in the
previous paragraph is carried forward to the next paragraph.
a. | ENTER | c. | CTRL | b. | SHIFT | d. | ALT |
|
|
|
57.
|
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 |
|
|
|
|
|
|
58.
|
In the accompanying figure, the __________ text box can be used to display a
specific record in the main document.
a. | View Merged Data | c. | Go to Record | b. | Sort Records | d. | Mail Merge |
|
|
|
59.
|
The Word Count dialog box presents a variety of statistics about the current
document, including number of __________.
a. | lines | c. | paragraphs | b. | characters | d. | all of the
above |
|
|
|
60.
|
The thickness of a 3-D Pie chart can be controlled by entering a percent smaller
or larger than the default 100% in the __________ in the 3-D View dialog box.
a. | Elevation text box | c. | Height text box | b. | Rotation text box | d. | Apply text box |
|
|
|
61.
|
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 |
|
|
|
62.
|
When a text entry in the Office Clipboard gallery of the Office task pane is
pointed to, __________.
a. | the first several characters of text in the item display as a
ScreenTip | b. | the text entry is deleted from the Office Clipboard gallery | c. | the text entry is
pasted into the document at the location of the insertion point | d. | all of the
above |
|
|
|
63.
|
A(n) __________ is a collection of data organized in a manner that allows
access, retrieval, and use of that data.
a. | file management system | c. | integrated system | b. | database management system | d. | database |
|
|
|
64.
|
A short horizontal line indicating the conclusion of a document is the
__________.
a. | insertion point | c. | status indicator | b. | end mark | d. | scroll box |
|
|
|
65.
|
The shortcut keys for the __________ character formatting are CTRL+SHIFT+PLUS
SIGN.
a. | case of letters | c. | superscript | b. | underline words, not spaces | d. | all capital
letters |
|
|
|
66.
|
After you click the Draw Table button, the mouse pointer changes to the shape of
a(n) __________.
a. | pencil | c. | crosshair | b. | eraser | d. | block arrow |
|
|
|
67.
|
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 |
|
|
|
68.
|
The Mail Merge Wizard is accessed through the _________ menu.
a. | File | c. | Format | b. | Insert | d. | Tools |
|
|
|
69.
|
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 |
|
|
|
70.
|
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 |
|
|
|
71.
|
Applying a gradient color to a WordArt drawing object is done by using the
__________ toolbar.
a. | Picture | c. | WordArt | b. | Drawing | d. | Formatting |
|
|
|
72.
|
Basic installations of Word support __________ types of main documents.
a. | one | c. | five | b. | three | d. | unlimited |
|
|
|
73.
|
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 |
|
|
|
74.
|
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 |
|
|
|
75.
|
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 |
|
|
|
|
|
|
76.
|
Within the body of a newsletter, a heading, such as LUNCHEON in the accompanying
figure, is called a(n) __________.
a. | subhead | c. | issue information line | b. | nameplate or
banner | d. | run-around |
|
|
|
77.
|
Word 2002 includes a series of predefined graphics called __________ that can be
inserted into a Word document.
a. | clip art | c. | captions | b. | hyperlinks | d. | bookmarks |
|
|
|
78.
|
In Word, the default alignment for paragraphs is __________.
a. | left-aligned, or flush margins at the left edge and jagged edges at the right
edge | b. | centered, or equidistant from both the left edge and the right
edge | c. | right-aligned, or flush margins at the right edge and jagged edges at the left
edge | d. | justified, or flush margins at both the left and right
edges |
|
|
|
79.
|
The horizontal lines in the nameplate are called __________.
a. | subheads | c. | rules or ruling lines | b. | references | d. | run-arounds |
|
|
|
80.
|
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 |
|
|
|
81.
|
A field has the format < in the Format box. If you type me93 in the field it will display as __________.
|
|
|
82.
|
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 (( )) |
|
|
|
83.
|
The first step in creating a data source is to __________.
a. | create the main document | b. | merge the data source with the main
document | c. | generate the form letters | d. | decide which fields it will
contain |
|
|
|
84.
|
To save an active document with a new file name, click __________ on the menu
bar and then click Save As.
a. | Edit | c. | View | b. | File | d. | Tools |
|
|
|
85.
|
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 |
|
|
|
86.
|
__________ is the process of changing the way letters, numbers, punctuation
marks, and symbols appear on the screen and in print.
a. | Document formatting | c. | Paragraph formatting | b. | Character formatting | d. | Object
formatting |
|
|
|
87.
|
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 |
|
|
|
88.
|
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 |
|
|
|
89.
|
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 |
|
|
|
90.
|
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 |
|
Completion
Complete each sentence or statement.
|
|
|
91.
|
The _________________________ is a small box or bar that, when clicked, selects
the entire row.
|
|
|
92.
|
A(n) _________________________ contains information about a given person,
product, or event.
|
|
|
93.
|
If no width is assigned to a text field, Access assumes the width is
_________________________.
|
|
|
94.
|
A(n) _________________________ is an application software package that can be
used to create a database; add, change, and delete data in the database; sort and retrieve data; and
create forms and reports using the data in the database.
|
|
|
95.
|
A field name can be up to _________________________ characters in length.
|
|
|
96.
|
A(n) _________________________ contains a specific piece of information within a
record.
|
|
|
97.
|
Every record in a table has a unique identifier that also is called a(n)
_________________________.
|
|
|
98.
|
In Access, a(n) _________________________ consists of a collection of
tables.
|
|
|
99.
|
A field with a data type of _________________________ can contain any
characters.
|
|
|
100.
|
A field with a data type of _________________________ can contain only dollar
amounts.
|