Name: 
 

IBCA Final Exam Study Guide



Multiple Choice - Excel, PowerPoint, Word
Questions 1-10:  Excel
Questions: 11-20:  PowerPoint
Questions:21-30:  Word

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

 1. 

The range is identified by its range reference, which is the cell in its upper-left corner and the cell in its lower-right corner, separated by a ____.
a.
colon
c.
comma
b.
semicolon
d.
period
 

 2. 

The name of each worksheet appears in the ____ at the bottom of the worksheet window.
a.
sheet box
c.
sheet dialog box
b.
sheet task bar
d.
sheet tab
 

 3. 

____ appear horizontally and are identified by numbers on the left side of the worksheet window.
a.
Columns
c.
Headings
b.
Rows
d.
Cells
 

 4. 

To replace cell contents, select the cell, type the new data, and then enter the data by clicking the Enter button on the Formula Bar or by pressing the ____.
a.
Enter key
c.
either a. or b.
b.
Tab key
d.
neither a. nor b.
 

 5. 

You can close a workbook by clicking the Office Button to display the Office menu and clicking ____.
a.
Open
c.
Exit
b.
Close
d.
End
 

 6. 

____ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.
a.
Columns
c.
Cells
b.
Rows
d.
Headings
 

 7. 

The ____ dialog box enables you to select a printer, the number of copies to print, the parts of the worksheet to print, and the way the printed worksheet will look.
a.
Selection
c.
Print
b.
Print Now
d.
Output
 

 8. 

If you want to see more cells in the work area, click the Zoom Out button or drag the Zoom slider to the ____ to decrease the zoom percentage.
a.
left
c.
either a. or b.
b.
right
d.
neither a. nor b.
 

 9. 

Each cell is identified by a unique cell reference, which is formed by combining the cell’s column letter and ____.
a.
row number
c.
cell contents
b.
row heading
d.
column heading
 

 10. 

To switch to Print Preview, click ____ in the Print dialog box.
a.
Review
c.
View
b.
Print
d.
Preview
 

 11. 

To save a presentation as an HTML file that can be viewed in a browser, choose the ____ type of file in the Save As dialog box.
a.
normal
c.
Web Page
b.
HTML
d.
Browser
 

 12. 

Using the Handouts option, you can print handouts with ____ slides per page.
a.
two or three
c.
nine
b.
four or six
d.
all of the above
 

 13. 

You can view a presentation four different ways that does NOT include ____.
a.
Handout
c.
Notes Page
b.
Slide Sorter
d.
Slide Show
 

 14. 

You can reorder slides by dragging the thumbnail in the ____ tab.
a.
Slides
c.
both a. and b.
b.
Outline
d.
neither a. nor b.
 

 15. 

In Slide Show view, each slide ____.
a.
takes up 1/4 the screen
b.
takes up 1/2 the screen
c.
fills the entire screen
d.
fills the center of the screen with room for editing
 

 16. 

____ refers to the way each new slide appears on the screen.
a.
Indentation
c.
Separation
b.
Transition
d.
Spacing
 

 17. 

A ____ shows you thumbnails of a theme or effect that will be applied.
a.
gallery
c.
design
b.
theme
d.
palette
 

 18. 

The ____ is how objects are placed on a slide.
a.
slide layout
c.
slide gallery
b.
slide sorter
d.
slide tab
 

 19. 

The ____, at the top of the window, identifies the window as a PowerPoint window and lists the name of the open presentation.
a.
status bar
c.
Ribbon
b.
toolbar
d.
title bar
 

 20. 

Objects are ____.
a.
text
c.
tables and charts
b.
graphics and illustrations
d.
all of the above
 

 21. 

A zoom percentage of ____ shows the document at its normal size.
a.
100%
c.
1
b.
100 points
d.
100 pixels
 

 22. 

Once you have placed text on the Clipboard, you can then ____ into the document whatever is stored on the Clipboard.
a.
paste
c.
toggle
b.
copy
d.
attach
 

 23. 

The ____ command enables you to look at a document as it will appear when printed.
a.
Print Preview
c.
Layout
b.
Printer
d.
Page
 

 24. 

____allows you to jump to a specific part of a document.
a.
Go To
c.
Move To
b.
Jump To
d.
New Page
 

 25. 

If Sam wants to move to the previous line, he should press the ____ key(s).
a.
Up arrow
c.
Ctrl+Up arrow
b.
Down arrow
d.
Page Up
 

 26. 

To move to the beginning of the document, Sam should select the ____ keyboard shortcut.
a.
Ctrl+Home
c.
Ctrl+right arrow
b.
Home
d.
Ctrl+left arrow
 

 27. 

You can rename a folder by ____ the folder, and then clicking Rename on the shortcut menu.
a.
double-clicking
c.
right-clicking
b.
dragging
d.
left-clicking
 

 28. 

The ____ shows where text will appear when you begin typing.
a.
Insertion point
c.
Type here point
b.
Blinking point
d.
Status bar
 

 29. 

The ____ command repeats the most recent action.
a.
Redo
c.
Repeat
b.
Undo
d.
Again
 

 30. 

The Show/Hide ¶ command allows you to see ____.
a.
hidden formatting marks
c.
how the document will print
b.
the text in a header
d.
word count
 



 
Check Your Work     Start Over