Multiple Choice Identify the
choice that best completes the statement or answers the question.
|
|
1.
|
____ causes adjacent rows to have different formatting so that each row in the
table is distinguished from surrounding rows.
a. | Row coloring | c. | Row banding | b. | Row shielding | d. | Row separating |
|
|
2.
|
The default style for text hyperlinks is ____ text.
a. | underlined | c. | italicized | b. | bolded | d. | 30-point |
|
|
3.
|
To select nonadjacent sheets, select the first sheet by clicking its tab and
then hold down the ____ key and click the sheet tabs of the remaining sheets you want to
select.
|
|
4.
|
Why is the VLOOKUP function used more often than other lookup functions?
a. | Because it has more powerful calculations | c. | Because it is easier to
implement | b. | Because most tables are vertical | d. | Because it is the default lookup
function |
|
|
5.
|
A(n) ____ reference is a formula that depends on its own value.
a. | explicit | c. | implicit | b. | singular | d. | circular |
|
|
6.
|
Records can be merged based on the contents of a specific ____.
a. | record | c. | field | b. | header | d. | row |
|
|
7.
|
To hide field codes on the screen, press the ____ keys.
a. | CTRL+F1 | c. | ALT+F9 | b. | ESC+F3 | d. | CTRL+F8 |
|
|
8.
|
____ formatting allows you to create rules that change the formatting of a cell
or range of cells based on the value of a particular cell.
a. | Quick | c. | Conditional | b. | Styles | d. | Cell |
|
|
9.
|
Word stores a data source as a(n) ____ because it is an efficient method of
storing a data source.
a. | Outlook contact record | c. | Word Address List | b. | Excel Spreadsheet | d. | Access table |
|
|
10.
|
Which of the following is possible with WordArt?
a. | shadowed effects | c. | stretched effects | b. | wavy effects | d. | all of the
above |
|
|
11.
|
Each row of an Excel worksheet used to create a table can store a record, and
each column can store a(n) ____.
a. | record | c. | function | b. | formula | d. | cell |
|
|
12.
|
When a merge field is inserted into the main document, Word surrounds the field
name with ____.
a. | apostrophes | c. | chevrons | b. | parentheses | d. | braces |
|
|
13.
|
To open the Hyperlink to Other PowerPoint Presentation dialog box, you should
click Other PowerPoint Presentation in the Hyperlink to list in the ____ Settings dialog box.
a. | Links | c. | Change | b. | Hyperlink | d. | Action |
|
|
14.
|
The ____ SmartArt graphic type shows relationships of parts to a whole.
a. | Hierarchy | c. | List | b. | Matrix | d. | Process |
|
|
15.
|
A ____ on the first page of a newsletter may consist of the information above
the multiple columns.
a. | table of contents | c. | nameplate | b. | headline | d. | subhead |
|
|
16.
|
You specify a column break in the ____ gallery.
a. | Format Column | c. | Insert Page and Section Breaks | b. | Breaks | d. | Columns |
|
|
17.
|
____ from a variety of people gives a wide range of viewpoints.
a. | Criticism | c. | Arguments | b. | Relationships | d. | Networking |
|
|
18.
|
When you ____, you work together on a document with others.
a. | collaborate | c. | cooperate | b. | acerbate | d. | negotiate |
|
|
19.
|
A(n) ____ created in Microsoft Word or another word-processing program works
well as a shell for a PowerPoint presentation.
a. | document | c. | table | b. | sketch | d. | outline |
|
|
20.
|
The space between a graphic and the text is sometimes called the ____.
a. | orphan | c. | run-around | b. | gutter | d. | drop-cap |
|
True/False Indicate whether the
statement is true or false.
|
|
21.
|
Only whole documents can be divided into multiple columns, not just a portion of
a document.
|
|
22.
|
A code is a group of format specifications that are assigned a name.
|
|
23.
|
When a section break is created, you specify whether or not the new section
should begin on a new page.
|
|
24.
|
You can preview presentation changes made by reviewers if you first display the
Preview tab.
|
|
25.
|
To reference cells in other sheets in a workbook when creating a formula,
include the worksheet name rather than the cell reference.
|
|
26.
|
An illustration often can help convey relationships between key points in your
presentation.
|
|
27.
|
When a document is inserted, Word inserts the document at the location of the
insertion point.
|
|
28.
|
With the Text Pane, you can direct your attention to developing and editing the
message without being concerned with the actual graphic.
|
|
29.
|
Imported outlines can have a maximum of nine outline levels.
|
|
30.
|
Changes that affect only the displayed slide are indicated in the Review Changes
section of the DETAILS tab on the Revisions pane.
|