Name:     ID: 
 
Email: 

Final Testx

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

 1. 

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

 2. 

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

 3. 

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

 4. 

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

 5. 

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

 6. 

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.
 

 7. 

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

 8. 

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

 9. 

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.
 

 10. 

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.
 

 11. 

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

 12. 

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.
 

 13. 

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

 14. 

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

 15. 

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.
 

 16. 

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

 17. 

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

 18. 

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

 19. 

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.
 

 20. 

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

 21. 

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

 22. 

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

 23. 

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.
 
 
nar002-1.jpg
 

 24. 

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

 25. 

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

 26. 

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.
c.
Format Shaper
b.
Formatter
d.
Format Painter
 

 27. 

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

 28. 

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

 29. 

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

 30. 

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.
 

 31. 

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

 32. 

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

 33. 

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

 34. 

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.
 

 35. 

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

 36. 

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

 37. 

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

 38. 

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.
 

 39. 

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

 40. 

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

 41. 

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.
c.
CTRL
b.
F1
d.
ALT
 

 42. 

The small squares and circles around a selected graphic are called ____ handles.
a.
sizing
c.
base
b.
shape
d.
 
 
nar005-1.jpgnar005-2.jpgnar005-3.jpg
 

 43. 

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.
 

 44. 

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.
d.
horizontal ruler
 

 45. 

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

 46. 

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

 47. 

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

 48. 

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

 49. 

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.
c.
signature block
b.
message
d.
salutation
 

 50. 

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

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

 51. 

A thin red border indicates the active cell.
 

 52. 

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.
 

 53. 

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.
 

 54. 

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

 55. 

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

 56. 

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).
 

 57. 

You should press the SPACEBAR to clear a cell.
 

 58. 

The equal sign (=) precedes a formula.
 

 59. 

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

 60. 

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

 61. 

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

 62. 

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

 63. 

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.
 

 64. 

The range automatically selected by Excel is always correct.
 

 65. 

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

 66. 

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

 67. 

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

 68. 

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

 69. 

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

 70. 

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

 71. 

You can select nonadjacent ranges using the SHIFT key.
 

 72. 

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

 73. 

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.
 

 74. 

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

 75. 

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

 76. 

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

 77. 

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

 78. 

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

 79. 

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

 80. 

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

 81. 

Some slide layouts do not have a content placeholder.
 

 82. 

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

 83. 

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

 84. 

It is not possible to add a shadow to text.
 

 85. 

A background is considered fill.
 

 86. 

Low saturation produces vivid colors.
 

 87. 

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

 88. 

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

 89. 

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.
 

 90. 

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

 91. 

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

 92. 

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.
 

 93. 

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

 94. 

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

 95. 

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

 96. 

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.
 

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

 97. 

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

 98. 

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

 99. 

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

 100. 

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



 
         Start Over