Name:     ID: 
 
Email: 

Office 2 Final

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 1. 

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.
Action
c.
Links
b.
Change
d.
Hyperlink
 

 2. 

The default style for text hyperlinks is ____ text.
a.
italicized
c.
bolded
b.
30-point
d.
underlined
 

 3. 

A ____ is a named group of formatting characteristics.
a.
group
c.
set
b.
style
d.
plan
 

 4. 

When you add a new slide following the title slide, PowerPoint uses the ____ slide layout for the new slide.
a.
Title Only
c.
Comparison
b.
Title and Content
d.
Blank
 

 5. 

____ 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.
Cell
c.
Quick
b.
Styles
d.
Conditional
 

 6. 

A(n) ____ is a particular type of hyperlink that has a built-in function.
a.
action link
c.
action button
b.
icon
d.
picture
 

 7. 

When you ____, you work together on a document with others.
a.
cooperate
c.
collaborate
b.
acerbate
d.
negotiate
 

 8. 

____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.
a.
Row separating
c.
Row shielding
b.
Row coloring
d.
Row banding
 

 9. 

Why is the VLOOKUP function used more often than other lookup functions?
a.
Because it is easier to implement
c.
Because it is the default lookup function
b.
Because most tables are vertical
d.
Because it has more powerful calculations
 

 10. 

You can select slide objects in order to delete them simultaneously by pressing the ____ key as you click each object.
a.
TAB
c.
ESC
b.
ALT
d.
SHIFT
 

 11. 

Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?
a.
TAB+SHIFT+ASTERISK (*)
c.
SHIFT+HOME+ASTERISK (*)
b.
CTRL+SHIFT+ASTERISK (*)
d.
ALT+SHIFT+ASTERISK (*)
 

 12. 

You can insert a new slide by pressing the ____ keyboard shortcut keys.
a.
CTRL+M
c.
CTRL+I
b.
CTRL+N
d.
CTRL+HOME
 

 13. 

A(n) ____ created in Microsoft Word or another word-processing program works well as a shell for a PowerPoint presentation.
a.
outline
c.
sketch
b.
document
d.
table
 

 14. 

Which of the following SmartArt layout types is used to show non-sequential information?
a.
Process
c.
Matrix
b.
List
d.
Cycle
 

 15. 

Which of the following is the path to the Financial button and the PMT function?
a.
(DATA tab | Function Library group)
c.
(FORMULAS tab | Defined Names group)
b.
(FORMULAS tab | Function Library group)
d.
(HOME tab | Formulas group)
 

 16. 

Which of the following SmartArt layout types is used to create an organizational chart?
a.
Matrix
c.
Hierarchy
b.
Relationship
d.
List
 

 17. 

____ includes special visual and sound effects applied to text or other content.
a.
Playback control
c.
Visual effects
b.
Animations
d.
Audio control
 

 18. 

A(n) ____ reference is a formula that depends on its own value.
a.
implicit
c.
explicit
b.
circular
d.
singular
 

 19. 

If the original word-processing document contains no heading styles, PowerPoint creates an outline based on ____.
a.
characters
c.
fonts
b.
paragraphs
d.
colors
 

 20. 

Which of the following SmartArt layout types is used to show proportional relationships with the largest component at the top or bottom?
a.
Process
c.
Cycle
b.
Pyramid
d.
Heirarchy
 

 21. 

____ effects modify text and objects displayed on the screen.
a.
Shape
c.
Display
b.
Emphasis
d.
Entrance
 

 22. 

Which of the following format codes insures that Excel will display a decimal point in the number?
a.
.(period)
c.
%(percent)
b.
S*
d.
()
 

 23. 

Graphical elements increase ____.
a.
apprehension
c.
mood
b.
visual literacy
d.
feelings
 

 24. 

____ allows you to see through the background, so that any text on the slide is visible.
a.
Ambiguity
c.
Transversely
b.
Transparency
d.
Opaqueness
 

 25. 

____ from a variety of people gives a wide range of viewpoints.
a.
Networking
c.
Relationships
b.
Criticism
d.
Arguments
 

 26. 

The arguments in ____ in the ScreenTip for a function are optional.
a.
parentheses
c.
quotation marks
b.
brackets
d.
braces
 

 27. 

A(n) ____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.
a.
amoritization schedule
c.
dialog box
b.
formula checker
d.
data table
 

 28. 

To close the Text Pane, you can press the ____ key(s).
a.
CTRL+TAB
c.
ESC
b.
ALT+SHIFT+RIGHT ARROW
d.
ALT+F4
 

 29. 

____ view allows you to look at several slides at one time.
a.
Slide Show
c.
Slide Sorter
b.
Reading
d.
Review Sorter
 

 30. 

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

True/False
Indicate whether the statement is true or false.
 

 31. 

The layout gallery displays 10 slide layouts with a variety of placeholders to define text and content positioning and formatting.
 

 32. 

If you change the Normal style, Excel applies the new format specifications to all cells, including those assigned other styles.
 

 33. 

By default, PowerPoint ends a slide show with a black slide.
 

 34. 

When a table is active, the FORMAT tab on the Ribbon provides powerful commands that allow you to alter the appearance and contents of a table quickly.
 

 35. 

When a cell is formatted for a percent, if you enter the number .5 Excel translates the value as 50%.
 

 36. 

Gradient fill is one color shade gradually progressing to another shade of the same color or one color progressing to another color.
 

 37. 

By default, hyperlinked text is displayed with an underline and in a color that is part of the color scheme.
 

 38. 

Audience members find balance and harmony seeing four objects on a slide.
 

 39. 

To reference cells in other sheets in a workbook when creating a formula, include the worksheet name rather than the cell reference.
 

 40. 

Some slide layouts do not have a content placeholder.
 

 41. 

You can apply artistic effects to a picture used as a slide’s background.
 

 42. 

Audiences generally focus last on the visual elements displayed on a slide.
 

 43. 

PowerPoint provides only three picture effects.
 

 44. 

The pointer changes to a plus shape to indicate that an item has been added to the Clipboard.
 

 45. 

You can apply merge and center formatting with the Center button (HOME tab | Alignment group).
 

 46. 

A slide show is another name for a PowerPoint presentation.
 

 47. 

Excel automatically selects the Left column check box in the Create Names from Selection dialog box in order to determine which option to select automatically.
 

 48. 

Some themes center text paragraphs between the left and right placeholder borders.
 

 49. 

An illustration often can help convey relationships between key points in your presentation.
 

 50. 

You cannot adjust the volume of sound that has been recorded on a file.
 



 
         Start Over