Name:     ID: 
 
Email: 

Office Final Exam

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

 1. 

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

 2. 

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

 3. 

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

 4. 

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

 5. 

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.
Undo button
c.
Copy button
b.
Redo button
d.
Cut button
 

 6. 

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

 7. 

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

 8. 

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

 9. 

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

 10. 

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

 11. 

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

 12. 

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.
most recently selected
d.
adjacent row or column
 

 13. 

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

 14. 

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

 15. 

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


True/False

Indicate whether the statement is true or false.
 

 16. 

In Word, the default typing mode is overtype mode.
 

 17. 

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.
 

 18. 

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

 19. 

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.
 

 20. 

Text entered in a cell cannot be realigned.
 

 21. 

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

 22. 

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

 23. 

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

 24. 

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

 25. 

You cannot save PowerPoint 2007 files in previous version formats.
 

 26. 

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

 27. 

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.
 

 28. 

You can set the speed of slide transitions.
 

 29. 

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

 30. 

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



 
         Start Over