Name:     ID: 
 
Email: 

Office 1 Final Exam

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 
 
nar001-1.jpg

Figure 1-1
 

 1. 

As shown in Figure 1-1, a(n) ____ is a set of choices, often graphical, arranged in a grid or in a list.
a.
menu
c.
unit
b.
index
d.
gallery
 

 2. 

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
 

 3. 

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
 

 4. 

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
 

 5. 

To select multiple cells, rows, or columns in a table that are not adjacent to one another, select the first cell and then hold down the ____ key while selecting the next cell, row, or column.
a.
ALT
c.
ENTER
b.
SHIFT
d.
CTRL
 

 6. 

The ____ is a blinking vertical bar that indicates where text, graphics, and other items will be inserted.
a.
end mark
c.
scroll point
b.
status bar
d.
insertion point
 
 
nar002-1.jpg

Figure 1-5
 

 7. 

The small squares and circles around a selected graphic, as shown in Figure 1-5, are called ____ handles.
a.
sizing
c.
base
b.
shape
d.
dimension
 

 8. 

_____ are types of changes that occur when text has been omitted from a document and must be inserted later.
a.
Additions
c.
Modifications
b.
Deletions
d.
All of the above
 

 9. 

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
 

 10. 

Headers print in the top margin ____ inch from the top of every page.
a.
one-quarter
c.
three-quarters of a(n)
b.
one-half
d.
one
 

 11. 

A tag name is an identifier that links a(n) ____ to a source.
a.
citation
c.
attribute
b.
index
d.
field
 

 12. 

To search for a special character, first click the More button in the Find dialog box and then use the ____ button.
a.
Characters
c.
Options
b.
Special
d.
Advanced
 

 13. 

If you click the Grow Font button too many times and make the font size too big, you can click the ____ button until the desired font size is displayed.
a.
Shrink Font
c.
Reduce Font
b.
Small Font
d.
Reduce Selected Text
 

 14. 

To change the color of entered text if the Mini toolbar is not displayed, use the Font Color button arrow on the ____ tab.
a.
Format
c.
References
b.
Page Layout
d.
Home
 

 15. 

To select a block of text, click at the beginning of the selection, scroll to the end of the selection, position the mouse pointer at the end of the selection, hold down the _____ key, and then click (or drag through the text).
a.
CTRL
c.
SHIFT
b.
ALT
d.
TAB
 

 16. 

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

 17. 

The formulas version verifies that you entered formulas, rather than ____, in formula-based cells.
a.
text
c.
functions
b.
numbers
d.
dollar signs
 

 18. 

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
 

 19. 

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
 

 20. 

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
a.
SYSDATE
c.
DATETIME
b.
NOW
d.
CURRENT
 

 21. 

The person or persons requesting the worksheet should supply their requirements in a __________ document.
a.
blank
c.
requirements
b.
test issues
d.
certified
 

 22. 

The number of worksheets that a workbook can contain is __________.
a.
unlimited
c.
9,999,999
b.
limited by computer memory
d.
limited by the number you add to it
 

 23. 

A __________ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.
a.
range
c.
nearby cell
b.
bunch
d.
neighbor
 

 24. 

Which key on the keyboard toggles between Insert mode and Overtype mode?
a.
Insert
c.
Tab
b.
Enter
d.
Num Lock
 

 25. 

Most Excel specialists who build Web queries use the worksheet returned from the Web query as an engine to supply data to another ____ in the workbook.
a.
range
b.
dialog box
c.
cell
d.
worksheet
 

 26. 

In addition to creating a series of values, dragging the fill handle instructs Excel to ____ the format of a cell to a range.
a.
copy
c.
delete
b.
move
d.
cut
 

 27. 

The Copy button copies the contents and format of the source area to the Office ____, a reserved place in the computer’s memory.
a.
Ribbon
c.
Folder
b.
Clipboard
d.
File
 

 28. 

When you complete a copy, the values and formats in the destination area are replaced with the values and formats of the ____ area.
a.
source
c.
range
b.
cell
d.
target
 

 29. 

Copying, deleting, inserting, and moving ranges of cells have the potential to ____.
a.
improve consistency of the cells
c.
render a worksheet useless
b.
improve consistency of the worksheet
d.
improve consistency of the workbook
 

 30. 

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
 

 31. 

Microsoft PowerPoint is a complete _____ program that allows you to produce professional-looking slide shows.
a.
personal information management
c.
presentation graphics
b.
spreadsheet
d.
database
 

 32. 

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
 

 33. 

The _____ feature in PowerPoint allows you to create bulleted lists, combine words and images, find and replace text, and use multiple fonts and type sizes.
a.
drawing
c.
charting
b.
word processing
d.
collaborating
 

 34. 

When running a slide show, a ____ appears near your mouse pointer when you right-click.
a.
Microsoft Office submenu
b.
Slide Show view menu
c.
Start menu
d.
pop-up menu
 
 
nar003-1.jpg
Figure 2-1
 

 35. 

In the accompanying figure, what are the two boxes on the slide known as?
a.
title text placeholders
c.
text boxes
b.
shape boxes
d.
placeholders
 
 
nar004-1.jpg
Figure 2-2
 

 36. 

In the accompanying figure, what are the four small slides called?
a.
graphics
c.
icons
b.
thumbnails
d.
images
 

 37. 

Elements such as lines, arrows, callouts, and banners that can be added to a slide are known as ____.
a.
symbols
c.
shapes
b.
characters
d.
drawings
 
 
nar005-1.jpg
Figure 3-1
 

 38. 

In the accompanying figure, why did the Format tab appear automatically on the Ribbon?
a.
it is always available with this particular slide layout
b.
because the placeholder border is selected
c.
it is always available on the Ribbon
d.
because the text in the placeholder is selected
 
 
nar006-1.jpg
Figure 3-2
 

 39. 

In the accompanying figure, what is the set of three blue boxes with circles inside and the arrow across them known as?
a.
WordArt
c.
SmartArt
b.
SmartDesign
d.
Text panes
 
 
nar007-1.jpg
Figure 4-1
 

 40. 

In the accompanying figure, what font does the Live Preview show as the body font?
a.
Urban
c.
Trebuchet MS
b.
Georgia
d.
It cannot be determined.
 
 
nar008-1.jpg
Figure 4-2
 

 41. 

In the accompanying figure, how was the Insert Table dialog box accessed?
a.
by clicking the Home tab
b.
by clicking the Office Button
c.
by clicking the Insert Table button in the content placeholder
d.
by clicking the Insert Object button in the content placeholder
 

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

 42. 

In addition to the basic solid underline, Word has many decorative underlines that are available through the Underline gallery.
 

 43. 

In Word, the default typing mode is overtype mode.
 

 44. 

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.
 

 45. 

A selected graphic can be resized using the Shape Height and Shape Width text boxes in the Size group on the Format tab in the Picture Tools tab.
 

 46. 

To remove a border from a paragraph, position the insertion point in the paragraph, click the Border button arrow on the Home tab, and then click the No Border button in the Border gallery.
 

 47. 

To display the New Document dialog box, click the Office Button and then click New.
 

 48. 

To delete the contents of a cell, select the cell contents by pointing to the left edge of the cell and clicking when the mouse pointer changes direction, and then press the DELETE key.
 

 49. 

Word provides an Undo button that can be used to cancel the most recent command or action.
 

 50. 

Text entered in a cell cannot be realigned.
 

 51. 

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.
 

 52. 

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

 53. 

A character is a dot on the screen that contains a color.
 

 54. 

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

 55. 

To import external data from a World Wide Web site, it is necessary to have access to the Internet.
 

 56. 

The NOW function is a date and time function.
 

 57. 

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

 58. 

You cannot save PowerPoint 2007 files in previous version formats.
 

 59. 

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

 60. 

PowerPoint automatically sizes text to fit a placeholder.
 



 
         Start Over