Name: 
 

Final Test



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

 1. 

An Excel ____ allows data to be summarized and charted easily.
a.
worksheet
c.
document
b.
workflow
d.
presentation
 

 2. 

The first step in creating an effective worksheet is to make sure you ____.
a.
apply font formatting
c.
insert a chart
b.
understand what is required
d.
enter the data
 

 3. 

To enter data in a cell, you must first select the ____.
a.
row
c.
column
b.
worksheet
d.
cell
 

 4. 

The ____ is a blinking vertical line that indicates where the next typed character will appear.
a.
scroll box
c.
insertion point
b.
sheet tab
d.
split bar
 

 5. 

By default, text is ____ in a cell.
a.
left-aligned
c.
justified
b.
centered
d.
right-aligned
 

 6. 

In Excel, a number can contain the characters ____.
a.
0 1 2 3 4 5 6 7 8 9
c.
. $ % E e
b.
+ - ( ) , /
d.
all of the above
 
 
nar001-1.jpg
 

 7. 

A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.
a.
range
c.
nearby cell
b.
bunch
d.
neighbor
 

 8. 

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.
a.
quotation mark (“)
c.
plus (+)
b.
colon (:)
d.
equal sign (=)
 

 9. 

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
a.
save
c.
format
b.
print
d.
clear
 

 10. 

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

 11. 

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
a.
exploded
c.
offset
b.
outer
d.
rasterized
 

 12. 

The date you change a file is an example of a(n) ____ property.
a.
automatically updated
c.
standard
b.
baseline
d.
indexed
 

 13. 

The ____ button allows you to erase recent cell entries.
a.
Undo
c.
Bold
b.
Cell Style
d.
Increase Decimal
 

 14. 

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

 15. 

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.
a.
contiguous
c.
direct
b.
indexed
d.
indirect
 

 16. 

All of the following are valid Excel arithmetic operators EXCEPT ____.
a.
^
c.
%
b.
*
d.
>
 

 17. 

Which of the following calculations multiplies 23 by 0.01?
a.
=23%
c.
=23+.01
b.
=23
d.
=24-.01
 

 18. 

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
a.
placement
c.
positioning
b.
operations
d.
selections
 

 19. 

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
a.
40
c.
48
b.
26
d.
13
 
 
nar002-1.jpg
 

 20. 

Point mode allows you to ____, as shown in the accompanying figure.
a.
select cells for use in a formula using the keyboard
b.
select a function from the Sum button list
c.
select cells for use in a formula using the mouse pointer
d.
edit cell contents directly in the cell
 

 21. 

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

 22. 

The ____ function displays the highest value in a range.
a.
MIN
c.
MAX
b.
SUM
d.
AVERAGE
 

 23. 

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
a.
DIVSUM
c.
AVERAGE
b.
RANGEAVG
d.
MAX
 

 24. 

To copy cell contents, you can select the cell and then press the ____ keys.
a.
CTRL+V
c.
CTRL+B
b.
CTRL+X
d.
CTRL+C
 

 25. 

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.
a.
Comma style format
c.
Percent style format
b.
Accounting number format
d.
Currency style format
 

 26. 

A ____ is text and graphics that print at the top of each page.
a.
header
c.
margin
b.
topper
d.
crown
 

 27. 

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
a.
Normal
c.
Page Break Preview
b.
Page Layout
d.
Full Screen
 

 28. 

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.
a.
Print Active Sheets
c.
Print Entire Workbook
b.
Print Selection
d.
none of the above
 

 29. 

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
 

 30. 

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.
a.
Alignment
c.
Center
b.
Left and Right
d.
Position
 

 31. 

____ text often provides a strong visual appeal.
a.
Launched
c.
Logical
b.
Tiny
d.
Rotated
 

 32. 

When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.
a.
45
c.
0
b.
90
d.
125
 

 33. 

Which of the following patterns extends the fill series to 575, 550, 525?
a.
650, 600
c.
560, 580
b.
625, 600
d.
500, 475
 

 34. 

Which of the following is an extension of the fill pattern Sunday, Tuesday?
a.
Wednesday, Thursday, Saturday
c.
Saturday, Sunday, Monday
b.
Thursday, Saturday, Monday
d.
Monday, Wednesday, Friday
 

 35. 

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

 36. 

Using the mouse to move or copy cells is called ____.
a.
drop and drag
c.
drag and copy
b.
drag and drop
d.
drag and paste
 

 37. 

Which of the following is not a valid format symbol?
a.
semi-colon (;)
c.
dollar sign ($)
b.
percent sign (%)
d.
comma (,)
 

 38. 

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
 

 39. 

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

 40. 

The ____ function is useful when you want to assign a value to a cell based on a logical test.
a.
IF
c.
AND
b.
NOW
d.
OR
 

 41. 

Which comparison operator means “not equal to”?
a.
<=
c.
<
b.
>
d.
<>
 

 42. 

____ refers to cells not wide enough to display the entire entry.
a.
#####
c.
$$$$$
b.
&&&&&
d.
+++++
 

 43. 

Error messages begin with the ____ symbol.
a.
?
c.
!
b.
=
d.
#
 

 44. 

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.
a.
included
c.
nested
b.
other
d.
duplicate
 

 45. 

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.
a.
section
c.
special
b.
sparkline
d.
sparkle
 

 46. 

Charts can either be embedded in a worksheet or placed in a separate ____.
a.
worksheet
c.
chart sheet
b.
dialog box
d.
range
 

 47. 

When working with a large worksheet, you can split the window into ____ panes.
a.
three or four
c.
two or six
b.
four or five
d.
two or four
 

 48. 

By default, slides in a new presentation are in ____ orientation.
a.
top to bottom
c.
portrait
b.
right to left
d.
landscape
 

 49. 

The Undo button is located on the ____.
a.
status bar
c.
Quick Access Toolbar
b.
vertical scroll bar
d.
HOME tab on the ribbon
 

 50. 

Pressing the ____ key when entering title text in a placeholder creates a new paragraph.
a.
DELETE
c.
SHIFT
b.
BACKSPACE
d.
ENTER
 

 51. 

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

 52. 

An accompanying ____ gives audience members reference notes and review material for your presentation.
a.
handout
c.
slide
b.
database
d.
file
 

 53. 

When you open a new presentation, a slide with the default ____ layout appears.
a.
variant
c.
Title Slide
b.
Blank Slide
d.
Home
 

 54. 

Document ____ are the details about a file.
a.
facts
c.
properties
b.
keywords
d.
themes
 

 55. 

The process of moving a slide object to a new location using the mouse pointer is called ____.
a.
drag and drip
c.
drip and drop
b.
drag and drop
d.
drop and drag
 

 56. 

A point is ____ of an inch in height.
a.
1/72
c.
1/5
b.
1/6
d.
1/65
 

 57. 

A PowerPoint ____ can help you deliver a dynamic, professional-looking message to an audience.
a.
calendar
c.
worksheet
b.
database
d.
presentation
 

 58. 

In a multilevel bulleted list slide, creating a lower-level paragraph is called ____ the text.
a.
promoting
c.
demoting
b.
increasing
d.
decreasing
 

 59. 

A slide ____ is a special animation effect used to progress from one slide to the next slide in a slide show.
a.
transition
c.
animation
b.
layout
d.
theme
 

 60. 

Text ____ defines the appearance and shape of letters, numbers, punctuation marks, and symbols.
a.
font
c.
style
b.
size
d.
format
 

 61. 

The ____ dialog box allows you to search for clip art by using descriptive keywords.
a.
Tabs pane
c.
Slide Organizer
b.
Insert Pictures
d.
Insert Media
 

 62. 

You can type comments to yourself in the ____ for a specific slide while working in Normal view.
a.
Navigation pane
c.
Notes pane
b.
Slide pane
d.
Theme pane
 
 
nar004-1.jpg
 

 63. 

The accompanying figure illustrates the screen you use to choose a ____.
a.
placeholder
c.
title
b.
presentation
d.
document theme
 

 64. 

What is the correct path to the Bold button?
a.
(HOME tab | Paragraph group)
c.
(DESIGN tab | Themes group)
b.
VIEW tab | Presentation Views group)
d.
(HOME tab | Font group)
 

 65. 

A photo's color intensity can be modified by changing the brightness and ____.
a.
graphics
c.
thumbnail
b.
color
d.
contrast
 

 66. 

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

 67. 

One method of getting the audience's attention and reinforcing the major concepts being presented is to have ____ on the title slide.
a.
accents
c.
textual elements
b.
graphical elements
d.
hyperlinks
 

 68. 

Many of the shapes included in the ____ gallery can direct the viewer to important aspects of the presentation.
a.
Graphics
c.
Boxes
b.
Shapes
d.
Background
 

 69. 

To save time and avoid formatting errors, you can use the ____ to apply custom formatting to other places in your presentation quickly and easily.
a.
Format Designer
c.
Format Shaper
b.
Formatter
d.
Format Painter
 

 70. 

WordArt ____ in the interior of a letter can consist of a solid color, texture, picture, or gradient.
a.
fill
c.
glow
b.
style
d.
depth
 

 71. 

To delete WordArt text outline, click ____ in the Text Outline gallery.
a.
Delete Outline
c.
Reverse Outline
b.
No Outline
d.
Invisible Outline
 

 72. 

____ is one color shade gradually progressing to another shade of the same color or to another color.
a.
Gradual fill
c.
Seamless fill
b.
Shaded fill
d.
Gradient fill
 

 73. 

____ allows you to see through the background, so that any text on the slide is visible.
a.
Opaqueness
c.
Transparency
b.
Ambiguity
d.
Transversely
 

 74. 

____ adds designs that repeat in rows across a slide.
a.
Solid fill
c.
Gradient fill
b.
Pattern fill
d.
Texture fill
 

 75. 

You can use ____ options to repeat a background image many times vertically and horizontally on a slide.
a.
formatting
c.
tiling
b.
duplicating
d.
arranging
 

 76. 

The ____ feature automatically locates specific text and then replaces it with desired text.
a.
Locator
c.
Replacer
b.
Find and Replace
d.
Locate and Replace
 

 77. 

If you accidentally replace the wrong text, just click the Undo button on the ____.
a.
status bar
c.
File tab
b.
Quick Access Toolbar
d.
mini toolbar
 

 78. 

A word with a meaning similar to that of another word is called a ____.
a.
synonym
c.
replacer
b.
thesaurus
d.
duplicate
 

 79. 

The Notes pane is ____ until you tap or click the Notes button on the status bar to open the pane.
a.
visible
c.
highlighted
b.
hidden
d.
outlined
 

 80. 

Color ____ changes the intensity of colors.
a.
tone
c.
saturation
b.
density
d.
brightness
 

 81. 

____ changes picture color into black, white, and shades of gray.
a.
Blackscale
c.
Whitescale
b.
Grayscale
d.
Colorscale
 

 82. 

Click ____ to move a stacked object toward the top of the stack.
a.
Move Forward
c.
Send Forward
b.
Bring Forward
d.
Slide Forward
 

 83. 

The ____ command moves the selected object underneath all objects on the slide.
a.
Send Backward
c.
Text Options
b.
Back Options
d.
Send to Back
 

 84. 

When a placeholder is selected, the ____ are displayed.
a.
placeholder handles
c.
justification handles
b.
alignment handles
d.
selection handles
 

 85. 

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

 86. 

When you ____ a clip art picture, PowerPoint breaks it into its component objects, as shown in the accompanying figure.
a.
regroup
c.
ungroup
b.
split
d.
merge
 

 87. 

Dragging or sizing affects only a ____.
a.
collection of objects
c.
ungrouped object
b.
regrouped object
d.
selected object
 

 88. 

Which of the following is the path to the Insert Video button?
a.
(INSERT tab | Video group)
c.
(DESIGN tab | Video group)
b.
(HOME tab | Media group)
d.
(INSERT tab | Media group)
 

 89. 

PowerPoint’s ____ feature allows you to set the timing for a video clip.
a.
Cut Video
c.
Slice Video
b.
Trim Video
d.
Split Video
 

 90. 

____ allow you to control how objects enter, move on, and exit slides.
a.
Audio effects
c.
Playback effects
b.
Animation effects
d.
Visual effects
 

 91. 

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

 92. 

____ effects determine how slide elements first appear on a slide.
a.
Exit
c.
Emphasis
b.
Entrance
d.
Exciting
 

 93. 

____ effects modify text and objects displayed on the screen.
a.
Shape
c.
Display
b.
Emphasis
d.
Entrance
 

 94. 

Instead of printing and distributing a hard copy of a document, you can distribute the document ____.
a.
as an empty file
c.
electronically
b.
in audio form only
d.
by hand
 

 95. 

The default view in Word is ____.
a.
Print Layout view
c.
Web Layout view
b.
Headline view
d.
Outline view
 

 96. 

Press the ENTER key in all of the following circumstances EXCEPT ____.
a.
to insert a blank line into a document
b.
when the insertion point reaches the right margin
c.
to begin a new paragraph
d.
in response to prompts in Word dialog boxes
 

 97. 

When Word flags a possible spelling or grammar error, it also changes the Spelling and Grammar Check icon to a(n) ____.
a.
black circle
c.
X
b.
green check mark
d.
red check mark
 

 98. 

When you use the keyboard to scroll to a different position in the document, the ____ automatically moves when you press the desired keys.
a.
roster
c.
alt tag
b.
insertion point
d.
smart tag
 

 99. 

____ formatting is the process of changing the way letters, numbers, punctuation marks, and symbols appear on the screen and in print.
a.
Document
c.
Paragraph
b.
Character
d.
Object
 

 100. 

The ____, or typeface, defines the appearance and shape of letters, numbers, and special characters.
a.
font
c.
point
b.
font size
d.
paragraph formatting
 

 101. 

A(n) ____ paragraph is a paragraph that begins with a dot or other symbol.
a.
headline
c.
bulleted
b.
centered
d.
indexed
 

 102. 

The file type ____ identifies a Word 2013 document.
a.
.doc
c.
.dot
b.
.docx
d.
.doct
 

 103. 

To select nonadjacent items, select the first item as usual, press and hold down the ____ key, and then while holding down the key, select the additional items.
a.
HOME
c.
CTRL
b.
F1
d.
ALT
 

 104. 

The small squares and circles around a selected graphic are called ____ handles.
a.
sizing
c.
base
b.
shape
d.
dimension
 

 105. 

When you tap or click the ____ button for a selected graphic, Word provides options for changing how a graphic is positioned with text in a document.
a.
Layout Options
c.
Positioning
b.
Image Options
d.
Graphic Placement
 

 106. 

When you drag a graphic's ____ handle, the graphic moves in either a clockwise or counterclockwise direction.
a.
turn
c.
selection
b.
rotate
d.
revolution
 

 107. 

Press the ____ key(s) to erase one character to the right of the insertion point.
a.
CTRL+HOME
c.
BACKSPACE
b.
DELETE
d.
END
 

 108. 

In Word, you can create electronic image files through the ____ tab in the Backstage view.
a.
PDF
c.
Print
b.
XPS
d.
Convert
 
 
nar008-1.jpgnar008-2.jpgnar008-3.jpg
 

 109. 

On the works cited page, list works by each author’s last name, as shown in the accompanying figure, or, if the author's name is not available, by the _____.
a.
title of the source
c.
date of the source
b.
publisher
d.
MLA citation number
 

 110. 

A note reference mark signals that an explanatory note exists at the bottom of the page as a(n) ____, as shown in the accompanying figure.
a.
keynote
c.
endnote
b.
citation
d.
footnote
 

 111. 

Each time the _____ key is pressed, the paragraph formatting in the previous paragraph is carried forward to the next paragraph.
a.
ENTER
c.
CTRL
b.
SHIFT
d.
ALT
 

 112. 

Although you can use a dialog box to indent paragraphs, Word provides a quicker way through the ____.
a.
Quick Access Toolbar
c.
vertical ruler
b.
Office Button menu
d.
horizontal ruler
 

 113. 

The _____ feature automatically corrects typing, spelling, capitalization, or grammar errors as you type them.
a.
AutoEntry
c.
AutoAdd
b.
AutoCorrect
d.
AutoSpell
 

 114. 

The rule when using MLA style is to press the SPACEBAR ____ time(s) after periods, colons, and other punctuation marks.
a.
one
c.
three
b.
two
d.
either A or B
 

 115. 

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

 116. 

The Word Count dialog box displays the number of words as well as the number of _____ in the current document.
a.
lines
c.
paragraphs
b.
characters
d.
all of the above
 

 117. 

Automatic page breaks are determined by ____.
a.
paper size
c.
margin settings
b.
line spacing
d.
all of the above
 

 118. 

According to the MLA style, the _____ is a list of sources that are referenced directly in a research paper.
a.
parenthetical citations page
c.
explanatory notes page
b.
works cited page
d.
superscript reference page
 

 119. 

The Office ____ is a temporary storage area.
a.
Warehouse
c.
Storehouse
b.
Clipboard
d.
Gallery
 

 120. 

A(n) ____ is a book of synonyms.
a.
dictionary
c.
index
b.
glossary
d.
thesaurus
 

 121. 

A letterhead should contain all of the following EXCEPT ____.
a.
the complete legal name of the individual or company
b.
the telephone number
c.
the mailing address
d.
the company's objective
 

 122. 

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

 123. 

The ____ tab automatically appears when a shape is selected in a document.
a.
Shape Options
c.
Shape Styles Gallery
b.
Drawing Tools Format
d.
all of the above
 

 124. 

Files containing ____ are available from a variety of sources.
a.
task panes
c.
colors
b.
search terms
d.
graphics
 

 125. 

____ is a predefined graphic.
a.
Clip art
c.
A task unit
b.
A content control
d.
A building block
 

 126. 

You can make one color in a graphic ____, that is, removing its color.
a.
opaque
c.
translucent
b.
transparent
d.
transfigured
 

 127. 

A ____ symbol is another name for a dot symbol.
a.
bullet
c.
cell
b.
logo
d.
target
 

 128. 

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

 129. 

In a business letter, type the ____ at least four blank lines below the complimentary close, allowing room for the author to sign his or her name.
a.
inside address
c.
signature block
b.
message
d.
salutation
 

 130. 

Word, by default, places a tab stop at every ____ mark on the ruler.
a.
.25"
c.
.75"
b.
.5"
d.
1"
 

 131. 

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.
modified semi-block
b.
block
d.
all of the above
 

 132. 

To advance rightward from one cell to the next in a table, press the ____ key.
a.
TAB
c.
HOME
b.
BACKSPACE
d.
ENTER
 
 
nar009-1.jpg
 

 133. 

If you want to select the first and third rows in the table in the accompanying figure, you select the first row, and then hold down the ____ key while selecting the third row.
a.
CTRL
c.
SHIFT
b.
ALT
d.
ENTER
 

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

 134. 

A thin red border indicates the active cell.
 

 135. 

When you tap or click the Enter box to complete an entry in a cell, the active cell moves down to the next cell in the same column.
 

 136. 

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.
 

 137. 

When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.
 

 138. 

A single point is about 1/32 of one inch in height.
 

 139. 

To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).
 

 140. 

You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.
 

 141. 

You should press the SPACEBAR to clear a cell.
 

 142. 

The equal sign (=) precedes a formula.
 

 143. 

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

 144. 

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.
 

 145. 

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

 146. 

Moving from left to right, the first calculation in the order of operations is negation (-).
 

 147. 

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.
 

 148. 

The Insert Options button lists formatting options.
 

 149. 

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.
 

 150. 

The range automatically selected by Excel is always correct.
 

 151. 

The AVERAGE function requires that the argument be included within parentheses following the function name.
 

 152. 

You cannot format an entire column at once.
 

 153. 

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.
 

 154. 

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.
 

 155. 

Best fit means that the width of the column will be increased or decreased by a percentage you specify.
 

 156. 

Rotated text allows you to fit more text into a smaller column width.
 

 157. 

The incorrect use of copying, deleting, inserting, and moving ranges of cells has the potential to render a worksheet useless.
 

 158. 

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.
 

 159. 

The syntax of the IF function is IF(logical_test), value_if_false, value_if_true).
 

 160. 

The <= comparison operator means less than or equal to.
 

 161. 

When Excel cannot calculate a formula, it displays an error message in a cell.
 

 162. 

The NETWORKDAYS function checks a formula for correctness.
 

 163. 

You can select nonadjacent ranges using the SHIFT key.
 

 164. 

When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value.
 

 165. 

The range of entries that identifies the major groups for a clustered column chart are called the category names.
 

 166. 

When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing the name of the item.
 

 167. 

When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.
 

 168. 

A paragraph is a segment of text with the same format that begins when you press the ENTER key and ends when you press the ENTER key again.
 

 169. 

A slide show is another name for a PowerPoint presentation.
 

 170. 

Unlike clip art, you cannot resize a photograph using sizing handles.
 

 171. 

You can insert pictures, such as scanned photographs, line art, and artwork, into a presentation.
 

 172. 

A star next to a slide indicates that animation effects have been applied to that slide.
 

 173. 

When making a presentation to an audience using PowerPoint, you use Notes Page view.
 

 174. 

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

 175. 

You can advance slides during a slide show by pressing the PAGE DOWN key.
 

 176. 

A clip is a single media file, such as a photo, illustration, sound, or video.
 

 177. 

Researchers have known for decades that documents with visual elements are more effective than those that consist of only text.
 

 178. 

Graphics in documents help clarify and emphasize details so they appeal to audience members with different backgrounds.
 
 
nar005-1.jpg
 

 179. 

The text in the accompanying figure shows shapes inserted and formatted.
 

 180. 

Some slide layouts do not have a content placeholder.
 

 181. 

Contrast is the difference between the darkest and lightest areas of an image.
 

 182. 

A style is a named group of formatting characteristics.
 

 183. 

It is not possible to make a line width more than 6 pt.
 

 184. 

Shapes in the Shapes gallery can be combined to show relationships among the elements.
 

 185. 

It is not possible to add a shadow to text.
 

 186. 

Format Painter cannot be used to copy only character attributes.
 

 187. 

To copy both character attributes and paragraph attributes, such as alignment and indentation, select the entire paragraph.
 

 188. 

A background is considered fill.
 

 189. 

Adjusting a fill’s gradient allows you to see through the background so that any text on a slide is visible.
 

 190. 

Well-produced video clips add value when they help explain a procedure or show movement that cannot be captured in a photograph.
 

 191. 

PowerPoint allows you to adjust colors to match or add contrast to slide elements by coloring photos.
 

 192. 

Low saturation produces vivid colors.
 

 193. 

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

 194. 

You can mix picture recoloring and artistic effects to create a unique image.
 

 195. 

The presentation theme determines the formatting characteristics of fonts and colors.
 

 196. 

A paragraph can be centered so that the text is aligned to both the left and right borders.
 

 197. 

Switching between PowerPoint views help you review your presentation’s design, content, and organization.
 

 198. 

When you ungroup an illustration, PowerPoint breaks it into its component objects.
 

 199. 

The same procedure of copying and pasting objects works for copying and pasting text from one placeholder to another.
 

 200. 

You can use the Trim Video feature to specify a video file’s Start and End time in order to control which portion of the video file plays during a slide show.
 

 201. 

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

 202. 

Tap or click Mute if you do not want your audience to hear any recorded sounds.
 

 203. 

Audio controls include playing and pausing sound, moving back or forward 0.25 seconds, audio progress, elapsed time, and muting or unmuting the sound.
 

 204. 

Once an audio clip is inserted into a slide, you cannot specify options that control playback and appearance.
 

 205. 

A raised dot (·) shows where the ENTER key was pressed.
 

 206. 

Wordwrap forces you to stop typing words and press the ENTER key at the end of each line.
 

 207. 

Paragraph formatting requires the paragraph to be selected prior to formatting.
 

 208. 

A single point is about 1/12 of an inch in height.
 

 209. 

The mouse pointer becomes different shapes depending on the pointer’s location and locations you click on the screen.
 

 210. 

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

 211. 

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.
 

 212. 

Using document properties is unlikely to save users time locating a particular file because they cannot view a document's properties without opening the document.
 

 213. 

Word inserts text to the right of the insertion point.
 

 214. 

If you want to print multiple copies of a document, display the Print dialog box by clicking the Print button on the Standard toolbar.
 

 215. 

To follow the MLA style, single-space text on all pages and apply one and a half-inch top and bottom margins, and one-inch left and right margins.
 

 216. 

According to MLA style, on each page of the research paper, precede the page number by the title of the paper.
 

 217. 

To place your name to the left of the page number as required by the MLA style, you must create a header that contains the page number.
 

 218. 

To use Click and Type, you right-click a blank area of the document window.
 

 219. 

If you add text, delete text, or modify text on a page, Word recalculates the location of automatic page breaks and adjusts them accordingly.
 

 220. 

According to the MLA style, the first line of each entry on the works cited page begins at the left margin.
 

 221. 

The MLA style requires that the works cited be listed in alphabetical order by the author’s last name or, if the work has no author, by the work’s title.
 

 222. 

When you insert an object in a document, Word always inserts it as a floating object.
 

 223. 

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.
 

 224. 

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

 225. 

To move a custom tab stop, drag the tab marker to the desired location on the ruler.
 

 226. 

Formatting marks, such as the end-of-cell mark, do not print on a hard copy.
 

 227. 

The column boundary, the border to the right of a column, can be dragged until a row is at a desired height.
 

 228. 

When you first create a table it is left-aligned; that is, flush with the left margin.
 

 229. 

If you want to move a table to a new location, point to the upper-right corner of the table until the table move handle appears, point to the table move handle, and then drag it to move the entire table to a new location.
 

 230. 

To delete the contents of a cell, select the cell contents and then press the DELETE or BACKSPACE key.
 

 231. 

To print a mailing label, tap or click the Labels button in the Create group on the MAILINGS tab, type the delivery address in the Delivery address box, and then tap or click the Print button in the Envelopes and Labels dialog box.
 

Modified True/False
Indicate whether the statement is true or false. If false, change the identified word or phrase to make the statement true.
 

 232. 

In a worksheet, columns typically contain information that is similar to a list. _________________________

 

 233. 

The opposite of merging cells is splitting a merged cell. _________________________

 

 234. 

If you accidentally undo an action, you can use the Redo button to redo it. _________________________

 

 235. 

To change the worksheet’s tab color, double click on the tab.

 

Multiple Response
Identify one or more choices that best complete the statement or answer the question.
 
 
Modified Multiple Choice
 

 236. 

Which of the following are valid formulas?
 a.
=3 ^ 4
 c.
=11+9
 b.
=H3/H11
 d.
=22-F15
 

 237. 

Which of the following is a method of entering functions?
 a.
keyboard, touch gesture, or pointer
 c.
the Insert Function box in the formula bar
 b.
the Sum menu
 d.
the Name box area in the formula bar
 

 238. 

Using the Excel spell checker, you can ____.
 a.
check the spelling of words in a selected range
 b.
add words to the dictionary
 

 239. 

A document theme sets the ____ for a presentation.
 a.
shadows and reflections
 c.
color scheme
 b.
print parameters
 d.
font
 

 240. 

You can format slide text by changing the ____.
 a.
point size
 c.
style
 b.
color
 d.
font
 

 241. 

The Normal view is composed of ____.
 a.
Properties Pane
 c.
Slide Pane
 b.
Thumbnail Pane
 d.
Notes Pane
 

 242. 

Word provides a means of canceling your recent ____.
 a.
applications
 c.
actions
 b.
indices
 d.
commands
 

 243. 

Word provides a variety of picture effects, including ____.
 a.
shape
 c.
size
 b.
color
 d.
content
 

 244. 

You can use the rulers to ____.
 a.
set tab stops
 c.
format characters
 b.
change page margins
 d.
adjust column widths
 

 245. 

____ is/are required information for a citation for a book in MLA style.
 a.
Full name of author(s)
 c.
Page numbers
 b.
Edition (if available)
 d.
Publication city
 

Case
 
 
Critical Thinking Questions
Case 2-1


You are planning a new presentation on marketing that you will deliver to your Intro to Business class.
 

 246. 

PowerPoint displays many themes that are varied and appealing and give you an excellent start at designing a presentation. However, you have a specific topic and design concept and could use some assistance in starting to develop the presentation. You ____.

a. create your own templatec. use WordArt
b. give careful thought to slide textd. can search for one of Microsoft’s ready-made presentations or browse one of the predefined categories
 

 247. 

You also want to capture the audience's attention with the title slide. You decide to ____.

a. arrange the slides in portrait orientationc. add speaker notes to all the slides
b. use text and an illustrationd. add a closing slide
 



 
Check Your Work     Start Over