Name:
Class:
Date:
1. Cell references in a formula are called ____.
a.
assumptions
b.
comments
c.
numbers
d.
content
1
2. When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.
a.
logical
b.
constant
c.
consistent
d.
calculated
b
1
3. You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.
a.
Alignment
b.
Left and Right
c.
Center
d.
Position
a
1
4. If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and
read from bottom to top in the cell.
a.
Position
b.
Orientation
c.
Slope
d.
Incline
b
1
5. ____ text often provides a strong visual appeal.
a.
Launched
b.
Tiny
c.
Logical
d.
Rotated
d
1
6. To open the Format Cells dialog box with the Alignment sheet active, tap or click the Alignment Settings ____.
a.
button
b.
check box
c.
option button
d.
Dialog Box Launcher
d
1
7. When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.
Name:
Class:
Date:
a.
45
b.
90
c.
0
d.
125
c
1
8. The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.
a.
Copy Cells
b.
Fill Formatting Only
c.
Fill Without Formatting
d.
none of the above
b
1
9. Which of the following Auto Fill Options menu options is the same as the Fill Series option?
a.
Fill Months
b.
Fill Without Formatting
c.
Fill Formatting Only
d.
Copy Cells
a
1
10. Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?
a.
Quarter 1
b.
Qtr1
c.
Qtr2
d.
Quarter4
c
1
11. Which of the following patterns extends the fill series to 575, 550, 525?
a.
650, 600
b.
625, 600
c.
560, 580
d.
500, 475
b
1
12. Which of the following is an extension of the fill pattern Sunday, Tuesday?
a.
Wednesday, Thursday, Saturday
b.
Thursday, Saturday, Monday
c.
Saturday, Sunday, Monday
d.
Monday, Wednesday, Friday
b
1
Name:
Class:
Date:
13. In the accompanying figure, the split double arrow mouse pointer ____.
a.
indicates a hidden column
b.
allows text to be entered at that location
c.
is the result of moving the mouse pointer to the boundary between column heading A and column heading B
d.
indicates the proposed width of column A
c
1
14. Which of the following is the path to the Increase or Decrease Indent button?
a.
(HOME tab | Clipboard group)
b.
(HOME tab | Editing group)
c.
(HOME tab | Alignment group)
d.
(HOME tab | Number group)
c
1
15. The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.
a.
two
b.
three
c.
four
d.
five
a
1
16. The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the
computer’s memory.
Name:
Class:
Date:
a.
Ribbon
b.
Clipboard
c.
Folder
d.
File
b
1
17. After shrinking entries to fit in cells, consider using the ____ slider on the status bar to make the entries more
readable.
a.
View
b.
Preview
c.
Display
d.
Zoom
d
1
18. In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to
press the ____ key.
a.
ENTER
b.
ALT
c.
CTRL
d.
SHIFT
a
1
19. Using the mouse to move or copy cells is called ____.
a.
drop and drag
b.
drag and drop
c.
drag and copy
d.
drag and paste
b
1
20. Which of the following is the path to the Insert Cells arrow?
a.
(HOME tab | Editing group)
b.
(HOME tab | Number group)
c.
(HOME tab | Cells group)
d.
(HOME tab | Inserting group)
c
1
21. If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references
but instead displays the ____ error message.
a.
#NULL!
b.
#DIV/0!
c.
#N/A
d.
#REF!
d
1
Name:
Class:
Date:
22. Which of the following is not a valid format symbol?
a.
semi-colon (;)
b.
percent sign (%)
c.
dollar sign ($)
d.
comma (,)
1
23. 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
b.
NOW
c.
DATETIME
d.
CURRENT
b
1
24. Which of the following formulas contains an absolute cell reference?
a.
=$B4
b.
=B$4
c.
=$B$4
d.
=B4
c
1
25. The ____ function is useful when you want to assign a value to a cell based on a logical test.
a.
IF
b.
NOW
c.
AND
d.
OR
a
1
26. Which comparison operator means “not equal to”?
a.
<=
b.
>
c.
<
d.
<>
d
1
27. ____ refers to cells not wide enough to display the entire entry.
a.
#####
b.
&&&&&
c.
$$$$$
d.
+++++
a
1
28. Error messages begin with the ____ symbol.
Name:
Class:
Date:
a.
?
b.
=
c.
!
d.
#
d
1
29. 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
b.
other
c.
nested
d.
duplicate
c
1
30. A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.
a.
section
b.
sparkline
c.
special
d.
sparkle
b
1
31. You can press the ____ keys to open the Format Cells dialog box.
a.
CTRL+1
b.
CTRL+2
c.
CTRL+3
d.
CTRL+4
a
1
32. The path to the Format Painter button is ____.
a.
(HOME tab | Number group)
b.
(HOME tab | Clipboard group)
c.
(HOME tab | Painting group)
d.
(HOME tab | Font group)
b
1
33. ____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.
a.
Click or tap
b.
Press or long-press
c.
Double-click or double-tap
d.
Triple-click or tap
c
1
34. You should use a ____ chart to compare values side by side, broken down by category.
a.
Column
b.
Bar
c.
Line
d.
Clustered Column
Name:
Class:
Date:
d
1
35. Charts can either be embedded in a worksheet or placed in a separate ____.
a.
worksheet
b.
dialog box
c.
chart sheet
d.
range
c
1
36. In a clustered column chart, the names of each column are part of the ____ series.
a.
category
b.
data
c.
label
d.
legend
b
1
37. Which of the following is the path to the Zoom button?
a.
(VIEW tab | Zoom group)
b.
(HOME tab | Zoom group)
c.
(INSERT tab | Zoom group)
d.
(ZOOM tab | View group)
a
1
38. When working with a large worksheet, you can split the window into ____ panes.
a.
three or four
b.
four or five
c.
two or six
d.
two or four
d
1
39. Which of the following is the path to the Goal Seek button?
a.
(INSERT tab | Goal Seek group)
b.
(HOME tab | Data Tools group)
c.
(DATA tab | Data Tools group)
d.
(ANALYSES tab | Goal Seeking group)
c
1
40. ____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific
goal for another cell.
a.
Goal
b.
Formula
c.
Option
d.
Function
a
Name:
Class:
Date:
Modified Multiple Choice
41. Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog
box. Which of the following are valid values for that number?
a.
15
b.
90
c.
145
d.
180
a, b
1
42. If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the
extended series?
a.
Wednesday
b.
Thursday
c.
Saturday
d.
Monday
b, c, d
1
43. Following the insertion of a row, the Insert Options button lets you select from which of the following options?
a.
Format Same As Above
b.
Undo Formatting
c.
Format Same As Below
d.
Clear Formatting
a, c, d
1
44. Which of the following are formatting symbols?
a.
Dollar sign ($)
b.
Comma (,)
c.
Pound sign (#)
d.
Percent sign (%)
a, b, d
1
45. The arguments in an IF function are ____.
a.
logical_test
b.
value_if_true
c.
value_if_true_false
d.
value_if_false
a, b, d
1
46. Rotated text allows you to fit more text into a smaller column width.
a.
True
b.
False
1
Name:
Class:
Date:
True
1
47. Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and –90 degrees.
a.
True
b.
False
False
1
48. If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series.
a.
True
b.
False
False
1
49. The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.
a.
True
b.
False
True
1
50. The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a
change to the cells in the source area updates the picture in the destination area.
a.
True
b.
False
True
1
51. The incorrect use of copying, deleting, inserting, and moving ranges of cells has the potential to render a worksheet
useless.
a.
True
b.
False
True
1
52. A date stamp shows the date a workbook, report, or other document was created or the time period it represents.
a.
True
b.
False
Name:
Class:
Date:
True
1
53. A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.
a.
True
b.
False
True
1
54. A cell reference with only one dollar sign before either the column or the row is called an absolute reference.
a.
True
b.
False
False
1
55. The syntax of the IF function is IF(logical_test), value_if_false, value_if_true).
a.
True
b.
False
False
1
56. The <= comparison operator means less than or equal to.
a.
True
b.
False
True
1
57. The path to the Logical button is (FORMULAS tab | Function Library group).
a.
True
b.
False
True
1
58. When Excel cannot calculate a formula, it displays an error message in a cell.
a.
True
b.
False
True
1
Name:
Class:
Date:
59. A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.
a.
True
b.
False
True
1
60. The NETWORKDAYS function checks a formula for correctness.
a.
True
b.
False
False
1
61. You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes
difficult to follow.
a.
True
b.
False
True
1
62. Excel includes four types of sparkline charts: line, column, win/loss, and stock.
a.
True
b.
False
False
1
63. Many ribbon commands, galleries, and shortcut keys function as toggles or switches.
a.
True
b.
False
True
1
64. You can select nonadjacent ranges using the SHIFT key.
a.
True
b.
False
False
1
Name:
Class:
Date:
65. The underline format underlines the entire cell, not just the characters in the cell.
a.
True
b.
False
False
1
66. With bar charts, you can drag the bar in the chart in one direction or another to change the corresponding value in the
worksheet.
a.
True
b.
False
True
1
67. When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value.
a.
True
b.
False
True
1
68. The range of entries that identifies the major groups for a clustered column chart are called the category names.
a.
True
b.
False
True
1
69. 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.
a.
True
b.
False
True
1
70. When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and
columns.
a.
True
b.
False
False
1
Name:
Class:
Date:
REFERENCES:
EX 182
71. You can click the Logical button (FORMULAS tab | Function Library group) and tap or click IFERROR to insert the
IF function. _________________________
ANSWER:
POINTS:
REFERENCES:
EX 156
72. You can replace a formula with its function so it remains constant. _________________________
ANSWER:
POINTS:
REFERENCES:
EX 157
73. You can press the CTRL+ACCENT MARK(`) keys to display the formulas in a worksheet.
_________________________
ANSWER:
POINTS:
REFERENCES:
EX 157
74. Panes created using the vertical split bar scroll together horizontally. ________________________
ANSWER:
POINTS:
REFERENCES:
EX 184
75. Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the
window. _________________________
ANSWER:
POINTS:
REFERENCES:
EX 185
76. ____________________ are values in cells that can be changed to determine new values for formulas.
ANSWER:
POINTS:
REFERENCES:
EX 130
77. The ____________________ option on the Auto Fill Options menu fills the destination area with contents using the
format of the source area and does not create a series.
ANSWER:
POINTS:
REFERENCES:
EX 139
78. The ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the
format of the source area.
ANSWER:
POINTS:
Name:
Class:
Date:
79. The ____________________ option on the Auto Fill Options menu fills the destination area using the format of the
80. The ____________________ option on the Auto Fill Options menu fills the destination area with the contents but
without the formatting of the source area.
81. The ____________________ option on the Auto Fill Options menu fills the destination area with a series of months
using the format of the source area.
82. ____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.
83. You can create your own ____________________ fill sequences for use with the fill handle.
84. When the Paste Options button is visible, you can use ____________________ to access the paste commands
available in the Paste Options gallery.
85. You know Excel is in Copy mode when a small plus sign appears next to the block arrow mouse pointer during a(n)
____________________ operation.
86. Excel displays the error message ____________________ in cells to indicate a cell reference error in a formula.
Name:
Class:
Date:
87. A(n) ____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a
formula from one cell to another.
88. AND, OR, and NOT are called ____________________ operators.
89. The ____________________ function is useful when you want to assign a value to a cell based on a logical test.
90. You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the
____________________.
91. The ____________________ at the bottom of the Fill Color and Font Color buttons changes to the most recently
selected color.
Name:
Class:
Date:
92. The type of chart shown in the accompanying figure is a(n) ____________________ chart.
93. When you change a value on which a chart is dependent, Excel immediately ____________________ the chart.
94. Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down
or to the right you scroll.
95. A sensitivity analysis is another name for a(n) ____________________ analysis.
96. Briefly discuss how Excel modifies cell references when copying and pasting formulas, including an explanation of
absolute, relative, and mixed cell references.
Name:
Class:
Date:
97. Discuss how you should format the various elements of a worksheet.
98. Explain in detail the utility of freezing worksheet columns and rows.
Critical Thinking
Critical Thinking Questions
Case 3-1
George runs a mid-size accounting practice and recently upgraded to Excel 2013. He expects sales to grow in the next few
months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the
employees in his office. He will start with the Reception area, which has the most visibility.
99. If sales reach a certain amount by the end of April, George will purchase a desk, chair, computer, and software
upgrade for the receptionist. Otherwise, George will just purchase the desk and chair. How can George determine the best
action to take using a Sales Data worksheet?
Critical Thinking
Name:
Class:
Date:
a.
Copy and paste all his Sales
data formulas with relative
references
c.
Add the NOW function formula to his Sales data
worksheet
b.
Add an IF function formula to
his Sales data worksheet
d.
Copy and paste all his Sales
data formulas with absolute
references
B
1
Critical Thinking
100. In George’s Sales Data worksheet, the result for a formula in cell H14 is ######. What should George do?
a.
increase the width of column H
c.
run the calculation again to find the
available value
b.
provide a correct argument or operand
d.
replace the incorrect formula in cell H14
with one that does not divide by zero
A
1
Critical Thinking
Critical Thinking Questions
Case 3-2
Bea is the best pie baker around. She has decided to go into business and takes a survey in her town to find out what types
of pies are favorites. She decides to record her data in a worksheet she can present to the bank when she seeks a loan for
her business startup costs. Bea is new to using Excel, however, and she would like to become conversant in the keyboard
shortcuts for the options available in the Paste Options gallery to expedite her work.
101. Bea finished adding the results of her survey to a worksheet in her new workbook, including the number of people
who voted for each type of pie. If in manipulating the worksheet she wants to copy the contents and formatting of a source
area but not the formula, which keyboard shortcut will she use?
a.
CTRL+R
c.
CTRL+E
b.
CTRL+A
d.
CTRL+W
C
1
Critical Thinking
102. Bea wants to copy the contents and format of a source area but transpose, or swap, the rows and columns. What
keyboard shortcut can she use to do this?
a.
CTRL+S
c.
CTRL+K
b.
CTRL+T
d.
CTRL+D
B
1
Name:
Class:
Date:
TOPICS:
Critical Thinking
Identify the letter of the choice that best matches the phrase or definition.
a.
NOW function
b.
Fill Formatting Only
c.
goal seeking
d.
what-if analysis
e.
NUM!
f.
#NAME?
g.
Keep Source Formatting
h.
Fill Series
i.
IF function
j.
absolute cell referencing
REFERENCES:
EX 139
EX 143
EX 138
EX 148
EX 151
EX 155
EX 157
EX 157
EX 187
EX 188
103. Fills a destination area using the format of the source area; no content is copied.
ANSWER:
b
POINTS:
1
104. Pastes the contents, format, and styles of the source area.
ANSWER:
g
POINTS:
1
105. The default option to fill an area.
ANSWER:
h
POINTS:
1
106. Returns a number that corresponds to the system date and time beginning with December 31, 1899.
ANSWER:
a
POINTS:
1
107. Keeps a cell reference constant when copying a formula or function.
ANSWER:
j
POINTS:
1
108. Assigns a value to a cell based on a logical test.
ANSWER:
i
Name:
Class:
Date:
109. Indicates a cell is using a name Excel does not recognize.
110. Indicates a cell that uses a number incorrectly.
111. Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.
112. Determines the value of a cell on which the formula depends.