True/False
Indicate whether the
statement is true or false.
|
|
|
Figure 3-3
|
|
|
1.
|
In the accompanying figure, the only cells that you should change when
performing what-if analysis are those in the what-if portion of the worksheet.
|
|
|
2.
|
In the accompanying figure, the months were rotated by selecting the text and
dragging the mouse pointer up and to the right.
|
|
|
3.
|
In the accompanying figure, the values that have dollar signs in column H are
Currency style with fixed dollar signs.
|
|
|
4.
|
In the accompanying figure, to achieve the format for the dollar values, the
Currency category was selected in the Format Cells dialog box.
|
|
|
5.
|
In the accompanying figure, the worksheet in the Window is split at the orange
double lines.
|
|
|
Figure 3-4
|
|
|
6.
|
In the accompanying figure, you know that the Pie chart was rotated because
Excel initially positions the chart so that one of the dividing lines between two slices is a
straight line pointing to 6:00 o’clock.
|
|
|
7.
|
In the accompanying figure, the month of June is emphasized by a technique
called imploding.
|
|
|
8.
|
Studies have shown that more than 25 percent of all business worksheets have
errors.
|
|
|
9.
|
The what-if assumptions should not clutter the worksheet, but they should be
placed in an easily located portion of the worksheet.
|
|
|
Figure 3-1
|
|
|
10.
|
In the accompanying figure, drag the Text hand in the Orientation area to the 45
point and to display 45 in the Degrees box.
|
|
|
11.
|
In the accompanying figure, if you prefer, you can type the number of degrees in
the Orientation box instead of dragging the Text hand.
|
|
|
12.
|
With some fill operations, you may not want to copy the formats of the source
cell or range to the destination cell or range. If this is the case, click the Auto Fill Options
button after the range fills and then select the option you desire on the Auto Fill Options
menu.
|
|
|
13.
|
If the contents of cells copied using the fill handle are 430 and 410, then the
next three values of an extended series are: 400, 390, 370.
|
|
|
Figure 3-2
|
|
|
14.
|
A split double arrow mouse pointer, as shown in the accompanying figure, can be
used to widen a column.
|
|
|
15.
|
In the accompanying figure, the width of column A changes if you double-click
the split double arrow mouse pointer
|
|
|
16.
|
The Decrease Indent button decreases the indent by five spaces each time you
click it.
|
|
|
17.
|
An alternative to increasing the column widths or row heights is to enlarge the
characters in the cell to fit the current width of the column.
|
|
|
18.
|
When you complete a copy, the values and formats in the destination area are
replaced with the values and formats of the source area.
|
|
|
19.
|
If you accidentally delete valuable data, immediately click the Undo button on
the Quick Access Toolbar.
|
|
|
20.
|
Methods for moving cells are drag and drop and cut and paste.
|
|
|
21.
|
Excel displays #REF! in a cell to indicate the cell is a cross reference.
|
|
|
22.
|
When a number is entered with a format symbol, Excel immediately displays it
with the assigned format.
|
|
|
23.
|
Freezing worksheet titles is a useful technique for viewing large worksheets
that extend beyond the window.
|
|
|
24.
|
The NOW function is a date and time function.
|
|
|
25.
|
The paste operation is one of many operations affected by an absolute cell
reference.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
26.
|
Hiding the ____ will allow a larger portion of the worksheet to be
visible.
a. | Ribbon | c. | worksheet’s tab | b. | Quick Access
Toolbar | d. | additional
worksheets |
|
|
|
27.
|
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 |
|
|
|
28.
|
You can ensure correctness in your formulas by carefully checking them using
____.
a. | Range Finder | c. | the requirements document | b. | the
Ribbon | d. | the Edit
menu |
|
|
|
29.
|
Which of the following is a suggested decision to make when you plan a
workbook?
a. | determine how to manipulate the worksheets | b. | determine the
necessary functions and formulas needed | c. | determine what to add to the requirements
document | d. | determine whether to use the Format Painter button |
|
|
|
30.
|
With a good understanding of the requirements document, an understanding of the
necessary decisions, and a sketch of the worksheet, the next step is to ____.
a. | use Excel to create the worksheet | c. | perform
calculations | b. | design the 3-D Pie chart | d. | create the 3-D Pie chart |
|
|
|
31.
|
Any application on the ____ submenu starts automatically when you turn your
computer on.
a. | Open | c. | Insert | b. | Format | d. | Startup |
|
|
|
32.
|
With large worksheets that extend beyond the size of a window, it is best to
enter titles in the ____.
a. | upper-right corner | c. | upper-center | b. | left-center row | d. | upper-left
corner |
|
|
|
Figure 3-1
|
|
|
33.
|
In the accompanying figure, if you enter 90 in the Degrees box in the
Orientation area, the text will appear ____.
a. | horizontal and read from left to right in the row | b. | horizontal and read
from top to bottom in the column | c. | vertically and read from top to bottom in the
cell | d. | vertically and read from bottom to top in the cell |
|
|
|
34.
|
In the accompanying figure, the Alignment tab allows you to position data by
____.
a. | indenting, rotating | c. | centering, left-aligning, or right-aligning | b. | aligning at the top,
bottom, or center | d. | all of
the above |
|
|
|
35.
|
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 |
|
|
|
36.
|
If you drag the fill handle to the left or up, Excel will ____ the series rather
than ____ the series.
a. | increment, decrement | c. | copy, cut | b. | decrement, increment | d. | cut, copy |
|
|
|
37.
|
Which of the following is not an Auto Fill option?
a. | Copy Cells | c. | Fill Series | b. | Fill Cells | d. | Fill Formatting
Only |
|
|
|
Figure 3-2
|
|
|
38.
|
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 |
|
|
|
39.
|
In the accompanying figure, if you drag the pointer to the right, a ScreenTip
indicates the ____.
a. | name of the column | c. | width of the column | b. | heading of the column | d. | height of the
row |
|
|
|
40.
|
The Increase Indent button indents the contents of a cell to the right by ____
spaces each time you click it.
|
|
|
41.
|
An alternative to increasing the column widths or row heights is to ____ to fit
the current width of the column.
a. | remove the adjacent column | c. | shrink the characters in the cell
| b. | enlarge the characters in the cell | d. | add an adjacent
column |
|
|
|
42.
|
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 |
|
|
|
43.
|
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 |
|
|
|
44.
|
The ____ button on the Ribbon or the ____ command on the shortcut menu removes
cells (including the data and format) from the worksheet.
a. | Remove | c. | Erase | b. | Delete | d. | Cut |
|
|
|
45.
|
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 |
|
|
|
46.
|
Which of the following is not a valid format symbol?
a. | semi-colon (;) | c. | dollar sign ($) | b. | percent sign (%) | d. | comma (,) |
|
|
|
47.
|
Excel allows you to ____, so that Excel displays the titles on the screen, no
matter how far down or to the right as you scroll.
a. | center the titles | c. | stabilize the titles | b. | fix the titles | d. | freeze the
titles |
|
|
|
48.
|
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 |
|
|
|
49.
|
A formula using the ____ cell reference B20 instructs Excel to adjust the cell
reference as it copies it to the destination area.
a. | variable | c. | relative | b. | absolute | d. | constant |
|
|
|
50.
|
The ____ function is useful when you want to assign a value to a cell based on a
logical test.
|
|
|
51.
|
Which comparison operator means “not equal to”?
|
|
|
52.
|
Excel converts all the formulas from ____.
a. | lowercase to uppercase | c. | absolute to constant | b. | uppercase to lowercase | d. | constant to
absolute |
|
|
|
53.
|
Error messages always begin with what symbol?
|
|
|
54.
|
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 |
|
|
|
55.
|
The color bar at the bottom of the Fill Color and Font Color buttons on the Home
tab on the Ribbon changes to the ____ color.
a. | initially selected | c. | adjacent cell | b. | most recently selected | d. | adjacent row or
column |
|
|
|
56.
|
A Pie chart with one or more slices offset is called a(n) ____.
a. | exploded Pie chart | c. | Bar chart | b. | segmented Pie chart | d. | 2-D chart |
|
|
|
57.
|
When you change a value on which a chart is dependent, Excel ____.
a. | does not do anything until you save the change | b. | immediately redraws
the chart based on the new value | c. | gives an error message | d. | prompts you to save
the change |
|
|
|
58.
|
To format the legend on the chart, use the ____.
a. | Formulas tab | c. | Legend gallery | b. | Review tab | d. | Legend style |
|
|
|
59.
|
Excel rotates the chart 10 degrees in a ____ direction each time you click the
Increase X Rotation button.
a. | forward tilt | c. | counterclockwise | b. | backward tilt | d. | clockwise |
|
|
|
60.
|
Unless you first select a range of cells or an object before starting the spell
checker, Excel checks the selected ____.
a. | text | c. | worksheet | b. | formula | d. | range |
|
|
|
61.
|
You can magnify or shrink the appearance of a worksheet or chart by using the
____ button on the View tab on the Ribbon.
a. | Maximize | c. | Focus | b. | Zoom | d. | View Up/Down |
|
|
|
62.
|
When you ____ a worksheet, Excel is able to display more columns and
rows.
a. | shrink | c. | expand | b. | minimize | d. | maximize |
|
|
|
63.
|
Using Excel to scrutinize the impact of changing values in cells that are
referenced by a formula in another cell is called ____.
a. | verification seeking | c. | goal seeking | b. | the IF function | d. | what-if
analysis |
|
|
|
64.
|
If you know the result you want a formula to produce, you can use ____ to
determine the value of a cell on which the formula depends.
a. | verification seeking | c. | goal seeking | b. | the IF function | d. | what-if
analysis |
|
|
|
65.
|
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 |
|