Name:     ID: 
 
Email: 

Office Final Exam


True/False

Indicate whether the statement is true or false.
 

 1. 

One way to review a presentation and assess whether slides have an attractive design and adequate content is to switch back and forth between Slide Sorter view and Normal view.
 

 2. 

The shortcut keys, CTRL+ENTER, instruct Word to insert an automatic page break immediately above the insertion point and position the insertion point immediately below the automatic page break.
 

 3. 

The arithmetic operator, ^, directs Excel to perform the division operation.
 

 4. 

The MLA style uses the term bibliographical references for works cited.
 

 5. 

CTRL+F1 allows you to minimize or maximize the Ribbon.
 

 6. 

The AVERAGE function requires that the argument (the range) be included within parentheses before the function name.
 

 7. 

You cannot save PowerPoint 2007 files in previous version formats.
 

 8. 

In Word, the default typing mode is overtype mode.
 

 9. 

If an action button is copied to another location, the settings of the action button are retained.
 

 10. 

Excel can display characters in only three font colors: black, red, and blue.
 

 11. 

Graphics and animations, as well as text, can be entered on the Outline tab in the Normal view.
 

 12. 

When using in-cell editing, to delete a character or adjacent characters you can use the mouse to drag through the character or characters and then press the DELETE key or click the Cut button on the Standard toolbar.
 

 13. 

You can set the speed of slide transitions.
 

 14. 

Text entered in a cell cannot be realigned.
 

 15. 

In a business letter, within the message, paragraphs are double-spaced with single-spacing between paragraphs.
 

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

 16. 

PowerPoint can produce slides based on an outline created in all of the following EXCEPT:
a.
Word
c.
a Web page
b.
Excel
d.
a word-processing program
 

 17. 

Groups are located on a particular _____.
a.
menu
c.
tab
b.
Ribbon
d.
icon
 

 18. 

The ____ of the worksheet shows the actual formulas you have entered, rather than the resulting values.
a.
Actual symbol
c.
current version
b.
formulas version
d.
Formulas Print symbol
 

 19. 

If the top of a set of characters is chopped off, then line spacing may be set to ____.
a.
Exactly
c.
Near
b.
Cut
d.
About
 

 20. 

If the Picture Tools and Format tabs are active and a graphic is selected, how do you deselect it?
a.
click Clear on the Picture Tools and Format tabs
b.
click outside the graphic
c.
click the Undo button
d.
click the Clear Graphic button on the Picture Tools and Format tabs
 

 21. 

The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the __________.
a.
receiving range
c.
destination area (or paste area)
b.
final cell
d.
receiver cell
 

 22. 

The color bar at the bottom of the Fill Color and Font Color buttons on the Home tab on the Ribbon changes to the ____ color.
a.
initially selected
c.
adjacent cell
b.
adjacent row or column
d.
most recently selected
 

 23. 

To enter a blank line into a document, press the ____ key without typing any text on the line.
a.
ESC
c.
CTRL
b.
ENTER
d.
ALT
 

 24. 

The shortcut keys for the _____ character formatting are CTRL+SHIFT+PLUS SIGN.
a.
all capital letters
c.
case of letters
b.
superscript
d.
underline words, not spaces
 

 25. 

__________ are a collection of worksheets.
a.
Workbooks
c.
Papers
b.
Work hours
d.
Booklets
 

 26. 

The ____ is ideal for returning the worksheet to its original state after you have changed the values in a worksheet to answer a what-if question.
a.
Cut button
c.
Copy button
b.
Redo button
d.
Undo button
 

 27. 

The ____ button is used to view the PowerPoint presentation in full screen view.
a.
View Show
c.
Slide Sorter
b.
Slide View
d.
Slide Show
 

 28. 

A _____ consists of a group of frequently used styles formatted so they look pleasing when used together.
a.
style set
c.
color scheme
b.
font set
d.
format index
 

 29. 

With ____ editing, the selected item is moved to the new location and then inserted there.
a.
inline
c.
drag-and-drop
b.
cut-and-paste
d.
copy-and-carry
 

 30. 

Groups are located on a particular _____.
a.
tab
c.
Ribbon
b.
menu
d.
icon
 



 
         Start Over