Name:     ID: 
 
Email: 

Office 1 Final

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

 1. 

To zoom a document using a touch screen, repeatedly pinch and stretch in order to change the size of the document in the document window.
 

 2. 

Word inserts text to the right of the insertion point.
 

 3. 

In the MLA style, notes are used only for optional content or bibliographic notes.
 

 4. 

An inline object is an object that can be positioned at a specific location in a document or in a layer over or behind text in a document.
 

 5. 

Worksheet titles and subtitles should be as wordy as possible.
 

 6. 

Both the Cancel button and the Enter button appear on the formula bar when you begin typing in a cell.
 

 7. 

The AutoCorrect feature can automatically capitalize the first letter in the names of days.
 

 8. 

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

 9. 

The most common error when entering a formula is to reference the wrong cell in the formula.
 

 10. 

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

 11. 

Excel has more than 400 functions that perform just about every type of calculation you can imagine.
 

 12. 

Excel includes four types of sparkline charts: line, column, win/loss, and stock.
 

 13. 

A slide show is another name for a PowerPoint presentation.
 

 14. 

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

 15. 

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

 16. 

PowerPoint provides only three picture effects.
 

 17. 

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

 18. 

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

 19. 

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

 20. 

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

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

 21. 

If a flagged word is spelled correctly, right-click it and then click ____ on the shortcut menu to instruct Word not to flag future occurrences of the same word in this document.
a.
Not a Mistake
c.
Do Not Correct
b.
Correct Spelling
d.
Ignore All
 

 22. 

Word includes a variety of document ____ to assist you with coordinating visual elements in a document.
a.
layouts
c.
themes
b.
formats
d.
graphs
 

 23. 

The shortcut keys used to center a paragraph are ____.
a.
CTRL+T
c.
CTRL+M
b.
CTRL+SHIFT+T
d.
CTRL+E
 

 24. 

Footnote text is _____.
a.
double-spaced, right-aligned, and a smaller font size than the text in the research paper
c.
double-spaced, left-aligned, and a smaller font size than the text in the research paper
b.
double-spaced, left-aligned, and the same font size as the text in the research paper
d.
single-spaced, left-aligned, and a smaller font size than the text in the research paper
 

 25. 

One way to add a correctly spelled word to the custom dictionary is to click the ____ button in the Spelling and Grammar dialog box
a.
Add to Dictionary
c.
New Entry
b.
Add to Custom
d.
Custom Entry
 

 26. 

All of the following are guidelines about the appearance of letterhead elements EXCEPT ____.
a.
use fonts that are easy to read
c.
consider formatting your name in bold
b.
make the font size of your name the same size as the rest of the text in the letterhead
d.
choose colors that convey your goals
 

 27. 

To display the Color gallery, with the graphic selected, click the Color button in the ____ group on the PICTURE TOOLS FORMAT tab.
a.
Format
c.
Tools
b.
Adjust
d.
Options
 

 28. 

Having used the Color gallery to change the color of a graphic, with the graphic selected, click ____ in the Color gallery to change a graphic back to its original color.
a.
No Recolor
c.
Revert
b.
Restore
d.
Default Color
 

 29. 

Typing text, followed by two hyphens, followed by more text and then a space changes the two hyphens to a(n) ____.
a.
ampersand
c.
em dash
b.
en dash
d.
border
 

 30. 

In a business letter, the ____, if present, begins two lines below the last line of the inside address.
a.
salutation
c.
date line
b.
message
d.
complimentary close
 

 31. 

Each time you press the ____ key, Word carries forward custom tab stops to the next paragraph.
a.
SHIFT
c.
ENTER
b.
CTRL
d.
F2
 

 32. 

In the ____ letter style, all components of the letter begin flush with the left margin.
a.
modified block
c.
block
b.
modified semi-block
d.
all of the above
 

 33. 

In the ____ letter style, the date, complimentary close, and signature block are positioned approximately one-half inch to the right of center or at the right margin.
a.
modified block
c.
block
b.
semi-modified block
d.
all of the above
 

 34. 

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
a.
semi-colon
c.
period
b.
colon
d.
none of these
 

 35. 

A ____ reference is an adjusted cell reference in a copied and pasted formula.
a.
revised
c.
recycled
b.
relative
d.
retained
 

 36. 

Combining two or more selected cells into one cell is called ____ cells.
a.
merging
c.
combining
b.
mixing
d.
spanning
 

 37. 

A ____ is a prewritten formula that is built into Excel.
a.
function
c.
task
b.
feature
d.
calculation
 

 38. 

The adjusted cell references in a copied and pasted formula are called ____ cell references.
a.
related
c.
pasted
b.
relative
d.
alternative
 

 39. 

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.
a.
logical
c.
consistent
b.
constant
d.
calculated
 

 40. 

Which of the following formulas contains an absolute cell reference?
a.
=B$4
c.
=$B$4
b.
=$B4
d.
=B$
 

 41. 

The path to the Format Painter button is ____.
a.
(HOME tab | Number group)
c.
(HOME tab | Painting group)
b.
(HOME tab | Clipboard group)
d.
(HOME tab | Font group)
 

 42. 

____ help one slide flow gracefully into the next during a slide show.
a.
Videos
c.
Variants
b.
Transitions
d.
Shapes
 

 43. 

A ____ is a specific design with coordinating colors, fonts, and special effects.
a.
placeholder
c.
chart
b.
slide show
d.
document theme
 

 44. 

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
 

 45. 

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

 46. 

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

 47. 

Adding a ____ to text adds depth and helps the letters display prominently.
a.
sizing handle
c.
shape
b.
font
d.
shadow
 

 48. 

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

 49. 

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
 

 50. 

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



 
         Start Over