Mr. Winter Office 2 Final Exam
True/False
Indicate whether the sentence or statement is true or
false.
|
|
|
1.
|
Typically, you would use an organization chart to show the structure of people
or departments within an organization.
|
|
|
2.
|
To find all customers whose current due amount is $0.00, enter 0 (zero) as a criterion for the Current Due field.
|
|
|
3.
|
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.
|
|
|
4.
|
A field has the format > in the Format property box. If phd is typed in the field it will display as PHD.
|
|
|
5.
|
A combo box is a box that allows a user to select entries from a list.
|
|
|
6.
|
Menus display some dimmed commands, that appear gray or dimmed instead of black,
which indicates they are available for the current selection.
|
|
|
7.
|
In creating an alphabetical works cited page, the first line of each entry
begins at the left margin.
|
|
|
8.
|
The three panes – outline, slide sorter, and notes – shown in normal
view also display in outline view.
|
|
|
9.
|
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.
|
|
|
10.
|
Comparison operators such as greater than (>) and less than (<) can be
used only with numeric fields.
|
|
|
11.
|
Although Excel requires a database title to be entered, it is poor practice to
include one on the worksheet.
|
|
|
12.
|
An asset is an amount owed by a corporation to its creditors.
|
|
|
13.
|
The content placeholders on a slide may be to the right or left of the text,
above the text, or below the text.
|
|
|
14.
|
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.
|
|
|
15.
|
The Report window uses small squares called grippers to indicate which portion
of the report currently is selected.
|
|
|
16.
|
The Maximize macro action requires an argument.
|
|
|
17.
|
To count words, click Tools on the menu bar and then point to Word Count.
|
|
|
18.
|
A computational field displays results based on other fields in the
database.
|
|
|
19.
|
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.
|
|
|
20.
|
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.
|
|
|
21.
|
You can click the ruler to set a custom tab stop at the right margin.
|
|
|
22.
|
Portrait orientation means a printout is across the length of a page.
|
|
|
23.
|
A criteria range is independent of the criteria set up in a data form.
|
|
|
24.
|
The values version of a worksheet shows the results of formulas entered, rather
than the actual formulas.
|
|
|
25.
|
Field names can contain periods but not square brackets ([ ]).
|
|
|
26.
|
The phrase, sort by quota within education within level, means that the records
first are arranged in ascending sequence by quota.
|
|
|
27.
|
The Decrease Decimal button removes a decimal place from the selected cell each
time it is clicked.
|
|
|
28.
|
Using a column as a separator between sections on a worksheet is a common
technique used by spreadsheet specialists.
|
|
|
29.
|
To create a very simple form that includes all fields in the table or query, use
AutoForm.
|
|
|
30.
|
When you ungroup a clip art picture, PowerPoint breaks it into its component
objects.
|
|
|
31.
|
The four buttons on the left edge of the horizontal scroll bar can be used to
change the format of a document.
|
|
|
32.
|
To chart a Word table, first start Graph and then select the table elements to
be charted.
|
|
|
33.
|
A dimmed command on a short or full menu indicates that it is not available for
a current selection in a menu.
|
|
|
34.
|
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.
|
|
|
35.
|
Once you insert clip art on a slide, you cannot reposition it.
|
|
|
36.
|
The Columns command on the Insert menu requires that an entire column (or
columns) be selected to insert a column (or columns).
|
|
|
37.
|
Worksheets normally are small, seldom extending beyond the size of the
window.
|
|
|
38.
|
To bold text in a label, change the Font Style property.
|
|
|
39.
|
Continuous means a new section is on the same page as a previous section.
|
|
|
40.
|
To add a title to a form, use the Text Box tool in the toolbox.
|
Multiple Choice
Identify the letter of the choice that best
completes the statement or answers the question.
|
|
|
41.
|
The __________ sheet in PowerPoint Help groups Help topics by general
categories.
a. | Index | c. | Office Assistant | b. | Category | d. | Contents |
|
|
|
42.
|
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 |
|
|
|
|
|
|
43.
|
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 |
|
|
|
44.
|
Field names __________.
a. | must be unique | b. | cannot contain more than 20
characters | c. | must begin with a number | d. | all of the
above |
|
|
|
45.
|
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 (( )) |
|
|
|
46.
|
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 |
|
|
|
47.
|
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 |
|
|
|
48.
|
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 |
|
|
|
49.
|
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 |
|
|
|
50.
|
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 |
|
|
|
51.
|
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 |
|
|
|
52.
|
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 |
|
|
|
53.
|
A field has the format < in the Format box. If you type me93 in the field it will display as __________.
|
|
|
54.
|
Pictures in the Microsoft Clip Gallery that have the file extension __________
are examples of bitmap graphic files.
|
|
|
55.
|
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 |
|
|
|
56.
|
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 |
|
|
|
57.
|
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 |
|
|
|
58.
|
A slide icon displays when the insertion point or paragraph reaches the
__________ level.
a. | first | c. | third | b. | second | d. | fourth |
|
|
|
59.
|
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 |
|
|
|
60.
|
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 |
|
|
|
61.
|
When a new workbook is opened, Excel assigns the __________ style to all
cells.
a. | Comma | c. | Percent | b. | Currency | d. | Normal |
|
|
|
62.
|
The best size mode to use for photographs is _________ size mode.
a. | Zoom | c. | Clip | b. | Crop | d. | Stretch |
|
|
|
63.
|
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 |
|
|
|
64.
|
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 |
|
|
|
65.
|
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 |
|
|
|
66.
|
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 |
|
|
|
67.
|
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 |
|
|
|
68.
|
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) |
|
|
|
69.
|
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 |
|
|
|
70.
|
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 |
|
|
|
71.
|
If a width is not assigned to a text field, Access assumes the width is
__________.
|
|
|
72.
|
__________ 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 |
|
|
|
73.
|
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 |
|
|
|
74.
|
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 |
|
|
|
75.
|
With Word’s AutoCorrect entries, to display an indifferent face (K) type __________.
|
|
|
76.
|
Less than (<), greater than (>), and NOT (not equal to) are examples of
__________.
a. | comparison operators | c. | compound values | b. | compound conditions | d. | conditions |
|
|
|
77.
|
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 |
|
|
|
78.
|
To complete an entry into a cell, click the __________.
a. | Enter box | c. | Cancel box | b. | Function box | d. | Name box |
|
|
|
79.
|
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 |
|
|
|
80.
|
Displaying records that pass a test is called __________ the database.
a. | sorting | c. | creating | b. | querying | d. | redefining |
|
|
|
81.
|
__________ 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 |
|
|
|
|
|
|
82.
|
To find all customers whose names begin with Ba, enter __________ in the
Criteria row of the Name column in the accompanying figure.
|
|
|
83.
|
Imported outlines can contain up to __________ outline levels.
a. | six | c. | eleven | b. | nine | d. | twelve |
|
|
|
84.
|
To run a macro, click the Macros object in the Database window, right-click the
macro, and then click __________ on the shortcut menu.
|
|
|
85.
|
A shape that Word has predefined is called a(n) __________.
a. | rectangle | c. | AutoShape | b. | banner | d. | drawing canvas |
|
|
|
86.
|
The phrase that appears after the word IF is called a(n) __________.
a. | operator | c. | field | b. | expression | d. | condition |
|
|
|
87.
|
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 ‘
‘ |
|
|
|
88.
|
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 |
|
|
|
89.
|
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 |
|
|
|
90.
|
To create a macro, click Macros on the Objects bar and then click the _________
button.
a. | New | c. | Start | b. | Begin | d. | Create |
|
Completion
Complete each sentence or statement.
|
|
|
91.
|
A(n) _________________________ is a box that allows a user to select entries
from a list.
|
|
|
92.
|
Column and row titles can be used within formulas when the related data is
referred to by _________________________.
|
|
|
93.
|
Names are created from column and row titles through the use of the
_________________________ on the Insert menu.
|
|
|
94.
|
_________________________ are collections of actions designed to carry out some
specific task.
|
|
|
95.
|
The term OLE means ______________________________.
|
|
|
96.
|
A(n) _________________________ is a form that includes buttons to perform a
variety of actions.
|
|
|
|
|
|
97.
|
In a database such as that shown in the accompanying figure, the data items that
make up a record are called _________________________.
|
|
|
98.
|
In a database of distributors, such as that shown in the accompanying figure,
the data related to a distributor is called a(n) _________________________.
|
|
|
99.
|
A(n) _________________________ field can contain text that is variable in length
and the amount of text stored in the field is virtually unlimited.
|
|
|
100.
|
_________________________ means creating separate collections of records that
share some common characteristic.
|