Name:     ID: 
 
Email: 

Office 2 Final

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

 1. 

A slide show is another name for a PowerPoint presentation.
 

 2. 

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

 3. 

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

 4. 

Some slide layouts do not have a content placeholder.
 

 5. 

PowerPoint provides only three picture effects.
 

 6. 

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

 7. 

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

 8. 

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

 9. 

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

 10. 

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

 11. 

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

 12. 

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.
 

 13. 

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

 14. 

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

 15. 

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

 16. 

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.
 

 17. 

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

 18. 

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

 19. 

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

 20. 

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

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

 21. 

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
 

 22. 

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

 23. 

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

 24. 

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

 25. 

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

 26. 

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

 27. 

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

 28. 

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

 29. 

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.
dialog box
c.
formula checker
b.
amoritization schedule
d.
data table
 

 30. 

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

 31. 

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

 32. 

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

 33. 

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

 34. 

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

 35. 

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
 

 36. 

____ 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
 

 37. 

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
 

 38. 

____ 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
 

 39. 

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

 40. 

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

 41. 

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

 42. 

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

 43. 

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

 44. 

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

 45. 

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

 46. 

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
 

 47. 

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

 48. 

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

 49. 

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

 50. 

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
 



 
         Start Over