Ms. Davis Office 2 Final Exam
True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
Field
names can contain periods but not square brackets ([ ]).
|
|
|
2.
|
Portrait orientation means a printout is across the length of a page.
|
|
|
3.
|
In a
report, the detail lines are lines that print for each record and contain only specified
fields.
|
|
|
4.
|
To
find all customers whose current due amount is $0.00, enter 0 (zero) as a
criterion for the Current Due field.
|
|
|
5.
|
Comparison operators such as greater than (>) and less than (<) can be used only
with numeric fields.
|
|
|
6.
|
A
field has the format > in the Format property box. If phd is typed in the
field it will display as PHD.
|
|
|
7.
|
If a
user violates a validation rule when entering data into a table, the database will not be updated
until the error is corrected.
|
|
|
8.
|
A
combo box is a box that allows a user to select entries from a list.
|
|
|
9.
|
The
Report window uses small squares called grippers to indicate which portion of the report currently is
selected.
|
|
|
10.
|
To
create a very simple form that includes all fields in the table or query, use AutoForm.
|
|
|
11.
|
To
add a title to a form, use the Text Box tool in the toolbox.
|
|
|
12.
|
If a
relationship is one-to-many, every occurrence of A is related to many occurrences of B and every
occurrence of B is related to many occurrences of A.
|
|
|
13.
|
To
bold text in a label, change the Font Style property.
|
|
|
14.
|
The
Maximize macro action requires an argument.
|
|
|
15.
|
Menus
display some dimmed commands, that appear gray or dimmed instead of black, which indicates they are
available for the current selection.
|
|
|
16.
|
The
AVERAGE function requires that the range (the argument) be included within parentheses before the
function name.
|
|
|
17.
|
The
Decrease Decimal button removes a decimal place from the selected cell each time it is
clicked.
|
|
|
18.
|
The
values version of a worksheet shows the results of formulas entered, rather than the actual
formulas.
|
|
|
19.
|
Sheet
names can be up to 31 characters (including spaces) in length.
|
|
|
20.
|
Worksheets normally are small, seldom extending beyond the size of the
window.
|
|
|
21.
|
The
Columns command on the Insert menu requires that an entire column (or columns) be selected to insert
a column (or columns).
|
|
|
22.
|
At
any time, the Cancel button in any of the Chart Wizard dialog boxes can be clicked to create the
chart with the options selected thus far.
|
|
|
23.
|
Excel
allows a percent magnification between 10 and 400 to be entered in the Zoom box for worksheets and
chart items.
|
|
|
24.
|
Using
a column as a separator between sections on a worksheet is a common technique used by spreadsheet
specialists.
|
|
|
25.
|
To
include additional formulas in a one-input data table, enter them in adjacent cells in the same row
as the current formulas and then define the entire new range as a data table by using the Table
command on the Data menu.
|
|
|
26.
|
It is
strongly recommended that background formula checking be used when creating certain types of
worksheets that may violate the formula rules until referenced cells contain data.
|
|
|
27.
|
A
computational field displays results based on other fields in the database.
|
|
|
28.
|
Although Excel requires a database title to be entered, it is poor practice to include
one on the worksheet.
|
|
|
29.
|
When
creating a database, a basic guideline is that each column should have different data; for example,
company start date should be in a different column for each company.
|
|
|
30.
|
The
phrase, sort by quota within education within level, means that the records first are arranged in
ascending sequence by quota.
|
|
|
31.
|
A
criteria range is independent of the criteria set up in a data form.
|
|
|
32.
|
An
asset is an amount owed by a corporation to its creditors.
|
|
|
33.
|
When
a new custom format code is created, Excel adds it to the bottom of the Type list in the Numbers
sheet in the Format Cells dialog box to make it available for future use.
|
|
|
34.
|
The
three panes – outline, slide sorter, and notes – shown in normal view also display in
outline view.
|
|
|
35.
|
The
content placeholders on a slide may be to the right or left of the text, above the text, or below the
text.
|
|
|
36.
|
Once
you insert clip art on a slide, you cannot reposition it.
|
|
|
37.
|
When
you ungroup a clip art picture, PowerPoint breaks it into its component objects.
|
|
|
38.
|
Typically, you would use an organization chart to show the structure of people or
departments within an organization.
|
|
|
39.
|
The
four buttons on the left edge of the horizontal scroll bar can be used to change the format of a
document.
|
|
|
40.
|
A
dimmed command on a short or full menu indicates that it is not available for a current selection in
a menu.
|
|
|
41.
|
Windows screen size and Word resolution are the two factors that affect how much of
the ruler displays in the document window.
|
|
|
42.
|
A
raised dot (·) shows where the ENTER key was pressed.
|
|
|
43.
|
To
count words, click Tools on the menu bar and then point to Word Count.
|
|
|
44.
|
In
creating an alphabetical works cited page, the first line of each entry begins at the left
margin.
|
|
|
45.
|
You
can click the ruler to set a custom tab stop at the right margin.
|
|
|
46.
|
To
chart a Word table, first start Graph and then select the table elements to be charted.
|
|
|
47.
|
If
the result of an expression in an IF field is true, then the false text is evaluated; otherwise, the
true text is evaluated.
|
|
|
48.
|
Continuous means a new section is on the same page as a previous
section.
|
|
|
49.
|
Word
inserts a continuous section break above the insertion point.
|
|
|
50.
|
In
newsletters, ruling lines often are used to separate columns.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
51.
|
If a
width is not assigned to a text field, Access assumes the width is __________.
|
|
|
52.
|
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 | | | | |
|
|
|
|
|
|
53.
|
To
find all customers whose names begin with Ba, enter __________ in the Criteria row of the Name column
in the accompanying figure.
|
|
|
54.
|
Less
than (<), greater than (>), and NOT (not equal to) are examples of __________. a. | comparison
operators | c. | compound
values | b. | compound conditions | d. | conditions | | | | |
|
|
|
55.
|
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 ((
)) | | | | |
|
|
|
56.
|
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 _________. a. | Enlarge | c. | Magnify | b. | Zoom | d. | Size | | | | |
|
|
|
57.
|
To
create an update query, create a new query, right-click the upper pane in the Select Query window,
click Query Type on the shortcut menu, and then click __________. a. | Append
Query | c. | Update
Query | b. | Change Query | d. | Maintain Query | | | | |
|
|
|
58.
|
A
field has the format < in the Format box. If you type me93 in the field it
will display as __________.
|
|
|
59.
|
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 | | | | |
|
|
|
|
|
|
60.
|
The
portions of the Report window (for example, Page Header, Detail) that display in the accompanying
figure are called __________. a. | slices | c. | sections | b. | areas | d. | segments | | | | |
|
|
|
61.
|
When
you create a calculated control, field names used in the expression must be enclosed in
__________. a. | parentheses (
) | c. | brackets [
] | b. | curly braces {
} | d. | single quotes
‘ ‘ | | | | |
|
|
|
62.
|
The
best size mode to use for photographs is _________ size mode. a. | Zoom | c. | Clip | b. | Crop | d. | Stretch | | | | |
|
|
|
63.
|
To
change the size mode of a picture, right-click the picture, click Properties from the shortcut menu,
and then click the _________ property box. a. | Picture Mode | c. | Object Mode | b. | Size
Mode | d. | Graphic
Mode | | | | |
|
|
|
64.
|
To
create a macro, click Macros on the Objects bar and then click the _________ button. a. | New | c. | Start | b. | Begin | d. | Create | | | | |
|
|
|
65.
|
To
run a macro, click the Macros object in the Database window, right-click the macro, and then click
__________ on the shortcut menu.
|
|
|
66.
|
To
use a switchboard, click the Forms object in the Database window, right-click the switchboard, and
then click __________ on the shortcut menu. a. | Open | c. | Execute | b. | Run
Switchboard | d. | Do | | | | |
|
|
|
67.
|
To
complete an entry into a cell, click the __________. a. | Enter
box | c. | Cancel
box | b. | Function
box | d. | Name
box | | | | |
|
|
|
68.
|
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 | | |
|
|
|
69.
|
In
Excel, a blank cell has __________. a. | no numerical value | c. | a numerical value of one | b. | a numerical
value of zero | d. | a numerical
value of two | | | | |
|
|
|
70.
|
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 | | | | |
|
|
|
71.
|
To
set a column width to best fit, __________ boundary of the column heading above row
1. a. | click the
left | c. | click the
right | b. | double-click the left | d. | double-click the right | | | | |
|
|
|
72.
|
The
general form of the IF function is __________. a. | =IF(logical_test, value_if_true,
value_if_false) | b. | =IF(logical_test, value_if_false,
value_if_true) | c. | =IF(value_if_true, logical_test,
value_if_false) | d. | =IF(value_if_false, logical_test,
value_if_true) | | |
|
|
|
73.
|
The
formula checker is invoked by clicking the __________ on the Tools menu. a. | Spelling
command | c. | Scenarios
command | b. | Error Checking command | d. | Formula Checking command | | | | |
|
|
|
74.
|
To
move from field to field in a data form, use the TAB key or hold down the __________ key and press
the key that corresponds to the underlined letter in the name of the desired field. a. | ALT | c. | CTRL | b. | SHIFT | d. | INSERT | | | | |
|
|
|
75.
|
Displaying records that pass a test is called __________ the
database. a. | sorting | c. | creating | b. | querying | d. | redefining | | | | |
|
|
|
76.
|
When
a new workbook is opened, Excel assigns the __________ style to all cells. a. | Comma | c. | Percent | b. | Currency | d. | Normal | | | | |
|
|
|
77.
|
The
Ask a Question box is used to __________. a. | suggest more efficient ways to complete a
task | b. | display a list
of topics related to a question you type | c. | provide an explanation of objects on the
screen | d. | group Help topics by general
categories | | |
|
|
|
78.
|
The
__________ sheet in PowerPoint Help groups Help topics by general categories. a. | Index | c. | Office
Assistant | b. | Category | d. | Contents | | | | |
|
|
|
79.
|
The
__________ button on the Outlining toolbar displays the titles and all collapsed text of selected
slides. a. | Increase | c. | Show
All | b. | Expand | d. | Unhide | | | | |
|
|
|
80.
|
A
slide icon displays when the insertion point or paragraph reaches the __________
level. a. | first | c. | third | b. | second | d. | fourth | | | | |
|
|
|
81.
|
Imported outlines can contain up to __________ outline levels. a. | six | c. | eleven | b. | nine | d. | twelve | | | | |
|
|
|
82.
|
Pictures in the Microsoft Clip Gallery that have the file extension __________ are
examples of bitmap graphic files.
|
|
|
83.
|
In
the Format WordArt dialog box, the __________ area allows you to change an object’s size while
maintaining its aspect ratio. a. | Size and rotate | c. | Original size | b. | Scale | d. | Revolve | | | | |
|
|
|
84.
|
__________ 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 | | | | |
|
|
|
85.
|
__________ are types of changes that occur when text has been omitted from a document
and must be inserted later. a. | Additions | c. | Modifications | b. | Deletions | d. | All of the
above | | | | |
|
|
|
86.
|
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 | | | | |
|
|
|
87.
|
The
MLA style specifies that a superscript be used for a note reference mark to signal an explanatory not
exists either at the bottom of the page as a(n) __________ or at the end of the document as a(n)
__________. a. | footnote;
startnote | c. | footnote;
endnote | b. | headnote; endnote | d. | headnote; startnote | | | | |
|
|
|
88.
|
In
normal view, automatic page breaks __________. a. | do not display | b. | display on the
Word screen as a single, dotted horizontal line | c. | display on the
Word screen above the header and beneath the footer | d. | display on the
Word screen as a line separated by the words, Page Break | | |
|
|
|
89.
|
With
Word’s AutoCorrect entries, to display an indifferent face (K) type
__________.
|
|
|
90.
|
With
the __________ available, Word notifies that a smart tag is available by displaying a smart tag
indicator on the screen. a. | AutoCorrect Options | c. | both a and c | b. | Smart Tag
Actions | d. | neither a nor
c | | | | |
|
|
|
91.
|
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 | | |
|
|
|
92.
|
If
present, the __________ begins two lines below the last line of the inside address in a business
letter. a. | salutation | c. | message | b. | date line | d. | complimentary close | | | | |
|
|
|
93.
|
The
__________ is one method of specifying the point size, color, shading, and placement of a
border. a. | Tables
toolbar | c. | Borders
toolbar | b. | Tables and Borders toolbar | d. | Clip Art toolbar | | | | |
|
|
|
94.
|
To
place a border using the same settings as the most recently defined border, click the
__________. a. | Border button on
the Formatting toolbar | b. | Insert Table button on the Standard
toolbar | c. | Insert Border button on the Standard
toolbar | d. | Tables and Borders button on the Formatting
toolbar | | |
|
|
|
95.
|
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 | | | | |
|
|
|
96.
|
A
shape that Word has predefined is called a(n) __________. a. | rectangle | c. | AutoShape | b. | banner | d. | drawing canvas | | | | |
|
|
|
97.
|
Field
names __________. a. | must be
unique | b. | cannot contain more than 20
characters | c. | must begin with a number | d. | all of the
above | | |
|
|
|
98.
|
The
phrase that appears after the word IF is called a(n) __________. a. | operator | c. | field | b. | expression | d. | condition | | | | |
|
|
|
99.
|
To
balance columns, a __________ is inserted at the end of the text on the page. a. | next page
break | c. | text wrapping
break | b. | continuous section break | d. | column break | | | | |
|
|
|
100.
|
To
use the Format Painter on several selected items, __________. a. | click the Format
Painter button | b. | double-click the Format Painter
button | c. | right-click the selected item, then click the Format Painter
button | d. | click the Format Painter button and then double-click the
selected item | | |
|