Name:     ID: 
 
Email: 

Office 2 Final Exam

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.
a.
CTRL
c.
ALT
b.
SHIFT
d.
ESC
 

 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.
 



 
         Start Over