Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
Text in a cell can be rotated counterclockwise by entering a number between
_____ on the Alignment sheet in the Format Cells dialog box.
a. | 1º and 90º | c. | 90º and 180º | b. | -1º and
-90º | d. | -90º and
-180º |
|
|
|
2.
|
When cells containing 430 and 410 are copied using the fill handle, the next
three values of the extended series will be _____.
a. | 430, 410, 430 | c. | 330, 310, 230 | b. | 390, 370, 350 | d. | 425, 420, 415 |
|
|
|
3.
|
To copy formats to a range of cells, _____.
a. | drag through the range to which you want to paste the formats, click the Format
Painter button, and then select a cell with the desired format | b. | drag through the
range to which you want to paste the formats, select a cell with the desired format, and then click
the Format Painter button | c. | click the Format Painter button, drag through
the range to which you want to paste the formats, and then select a cell with the desired
format | d. | select a cell with the desired format, click the Format Painter button, and then drag
through the range to which you want to paste the formats |
|
|
|
4.
|
To collect multiple items, the Clipboard task pane first must be displayed by
clicking _____.
a. | Task Pane on the Edit menu | c. | Office Clipboard on the Edit
menu | b. | Task Pane on the Window menu | d. | Office Clipboard on the Window
menu |
|
|
|
5.
|
You know that you are pointing to the border of the cell or range when the mouse
pointer changes to a _____.
a. | cross hair | c. | pointing hand | b. | block arrow | d. | pencil |
|
|
|
6.
|
To copy a selection, hold down the _____ key while dragging the selection to its
new location.
a. | SHIFT | c. | CTRL | b. | ALT | d. | INSERT |
|
|
|
7.
|
The primary difference between the Insert command on the shortcut menu and the
Rows command on the Insert menu is that the Insert command _____.
a. | copies the format from the row above the inserted row | b. | requires that an
entire row be selected in order to insert a row | c. | copies the format from the row below the
inserted row | d. | requires that a single cell be selected in a row to insert one
row |
|
|
|
8.
|
Following the insertion of a column, Excel displays the _____ button, which
allows the insertion to be modified by selecting one of several format options.
a. | Style Options | c. | Paste Options | b. | Fill Options | d. | Insert Options |
|
|
|
9.
|
Valid format symbols that can be entered with a number include all of the
following except the _____.
a. | asterisk (*) | c. | dollar sign ($) | b. | comma (,) | d. | percent sign
(%) |
|
|
|
10.
|
Use the Freeze Panes command on the _____ menu to freeze a worksheet title and
column titles.
a. | Format | c. | Data | b. | Tools | d. | Window |
|
|
|
11.
|
When a date is displayed in the General format (e.g., 38607.75), the whole
number portion of the number 38607) represents the number of days since _____.
a. | December 31, 1899 | c. | December 31, 1999 | b. | January 1, 1990 | d. | January 1 of the current
year |
|
|
|
12.
|
To specify an absolute reference in a formula, enter a(n) _____ before any
column letters or row numbers that should be kept constant in formulas to be copied.
a. | number sign (#) | c. | dollar sign ($) | b. | ampersand (@) | d. | asterisk (*) |
|
|
|
13.
|
A formula using _____ instructs Excel to keep the cell reference B20 constant
(absolute) as it copies the formula to a new location.
|
|
|
14.
|
The general form of the IF function is _____.
a. | =IF(logical_test, value_if_true, value_if_false) | b. | =IF(logical_test,
value_if_false, value_if_true) | c. | =IF(value_if_true, logical_test,
value_if_false) | d. | =IF(value_if_false, logical_test, value_if_true) |
|
|
|
15.
|
In an IF function, valid comparison operators (and their meaning) include all of
the following except _____.
a. | = (equal to) and <> (not equal to) | b. | < (less than) and
> (greater than) | c. | >= (greater than or equal to) and <=
(less than or equal to) | d. | >< (less than or greater than) and
^ (outside of) |
|
|
|
16.
|
If the IF function =IF(b4>=$b$24, $b$19, 0) is assigned to cell B9, and the
value in cell B4 is greater than the value in cell B24, Excel displays _____ in cell B9.
a. | the value in cell B24 | c. | the value in cell B4 | b. | the value in cell B19 | d. | 0 |
|
|
|
17.
|
A floating toolbar can be moved by pointing to _____ within the toolbar window
and then dragging the toolbar to its new location.
a. | the title bar or to a blank area | c. | a button or to a blank
area | b. | the title bar or to a button | d. | all of the
above |
|
|
|
18.
|
In any of the four Chart Wizard dialog boxes, a _____ button can be clicked to
return to the previous Chart Wizard dialog box.
a. | Cancel | c. | Next | b. | Back | d. | Finish |
|
|
|
19.
|
When Excel initially draws a Pie chart, it always positions the chart so that
one of the dividing lines between two slices is a straight line pointing to _____.
a. | 12 o’clock (or 0º) | c. | 6 o’clock (or
180º) | b. | 3 o’clock (or 90º) | d. | 9 o’clock (or
270º) |
|
|
|
20.
|
The thickness of a 3-D Pie chart can be controlled by entering a percent smaller
or larger than the default 100% in the _____ in the 3-D View dialog box.
a. | Elevation box | c. | Height box | b. | Rotation box | d. | Apply box |
|
|
|
|
|
|
21.
|
When Split is clicked on the Window menu, Excel divides the window into four
_____, as shown in the accompanying figure.
a. | zoom boxes | c. | panes | b. | sheets | d. | toolbar docks |
|
|
|
22.
|
The panes split by the vertical bar going up and down the middle of the window
shown in the accompanying figure scroll together _____.
a. | horizontally | c. | diagonally | b. | vertically | d. | all of the
above |
|
|
|
23.
|
One of the split bars can be removed from the window shown in the accompanying
figure by _____.
a. | dragging the split box to the center of the window or double-clicking the split
bar | b. | dragging the split box to the edge of the window or clicking the split
bar | c. | dragging the split box to the edge of the window or double-clicking the split
bar | d. | dragging the split box to the center of the window or clicking the split
bar. |
|
|
|
24.
|
If the result a formula should produce is known, the _____ on the Tools menu can
be used to determine the value of a cell on which the formula depends.
a. | Track Changes command | c. | Share Workbook command | b. | Data Analysis
command | d. | Goal Seek
command |
|
|
|
25.
|
Goal seeking assumes that the value of _____ referenced directly or indirectly
can be changed to reach a specified goal for a value in another cell.
a. | no cells | c. | two or more cells | b. | only one cell | d. | any number of
cells |
|
True/False
Indicate whether the
statement is true or false.
|
|
|
26.
|
Worksheets normally are small, seldom extending beyond the size of the
window.
|
|
|
27.
|
With large worksheets that extend beyond the size of a window, it is best to
enter titles in the upper-left corner.
|
|
|
28.
|
If the fill handle is used to create a series of numbers or non-sequential
months, the first item in the series must be entered in one cell and the second item in the series in
an adjacent cell.
|
|
|
29.
|
The Increase Indent button indents the contents of a cell to the left by three
spaces each time it is clicked.
|
|
|
30.
|
To copy a source area to a nonadjacent destination area, the fill handle can be
used.
|
|
|
31.
|
The Copy command on the Edit or shortcut menu copies an item from the Office
Clipboard to the destination area.
|
|
|
32.
|
It is not necessary to select the entire destination area before clicking the
Paste button; Excel only needs to know the upper-left cell of the destination area.
|
|
|
33.
|
When a copy is completed, the values and formats in the source area are replaced
with the values and formats of the destination area.
|
|
|
34.
|
The Paste Options button appears on the screen when the ENTER key is used to
complete the paste operation.
|
|
|
35.
|
The Rows command on the Insert menu or the Insert command on the shortcut menu
allows rows to be inserted between rows that already contain data.
|
|
|
36.
|
When a row is inserted, if the rows that are shifted down include cell
references in formulas located in the worksheet, Excel adjusts the cell references to the new
locations.
|
|
|
37.
|
The Columns command on the Insert menu requires that an entire column (or
columns) be selected to insert a column (or columns).
|
|
|
38.
|
Deleting cells is the same as clearing cells.
|
|
|
39.
|
The way that you insert rows into a worksheet is very different from the way you
insert columns into a worksheet.
|
|
|
40.
|
If cell A7 contains the formula =A4+A5 and row 5 is deleted, then Excel assigns
the formula =A4+#REF! to cell A6 (originally cell A7) and displays the error message #REF! in cell
A6.
|
|
|
41.
|
If a number is entered with one or more decimal places and a format symbol,
Excel displays the number without any decimal places.
|
|
|
42.
|
You can unfreeze titles by clicking the Unfreeze Panes command on the Window
menu.
|
|
|
43.
|
In business, a report often is meaningless without a date stamp.
|
|
|
44.
|
If a computer’s system date is set to the current date, which normally it
is, then a date stamp is equivalent to the current date.
|
|
|
45.
|
Excel automatically formats a date stamp using the date and time format,
mm/dd/yy hh:mm, where the first mm is the month, dd is the day of the month, yy is the last two
digits of the year, hh is the hour of the day, and mm is the minutes past the hour.
|
|
|
46.
|
When the system date is entered, the date displays left-aligned in the cell
because Excel treats the date as text.
|
|
|
47.
|
When Excel displays the date in the General format (e.g., 38607.75), the decimal
portion (.75) represents the month of the year (September).
|
|
|
48.
|
To specify an absolute cell reference in a formula, enter a dollar sign ($)
before any column letters or row numbers you want to keep constant when the formula is copied.
|
|
|
49.
|
$B$20 is a relative reference while B20 is an absolute reference.
|
|
|
50.
|
In an IF function’s logical_test, each expression can be a cell reference,
a number, text, a function, or a formula.
|
|
|
51.
|
In the formulas version of a worksheet, Excel converts all the formulas entered
to lowercase.
|
|
|
52.
|
Beyond a nest of three IF functions, the logic can become difficult to follow
and alternative solutions should be considered.
|
|
|
53.
|
Excel has only 60 toolbar buttons, all of which display on three built-in
toolbars.
|
|
|
54.
|
The Drawing toolbar can be displayed or hidden by clicking the Drawing button on
the Standard toolbar.
|
|
|
55.
|
As with any window, a toolbar can be resized by dragging the toolbar window
borders.
|
|
|
56.
|
Excel has four toolbar docks, one on each of the four sides of the
window.
|
|
|
57.
|
Each time a toolbar is docked, the Excel window slightly increases in size to
compensate for the room occupied by the toolbar.
|
|
|
58.
|
When a drop shadow is added to a range of cells, Excel selects the drop shadow
and surrounds it with handles.
|
|
|
59.
|
A 3-D Pie chart can make it easy to evaluate the contribution of one month to a
six-month projected operating income in comparison to other months.
|
|
|
60.
|
When the Chart Wizard is used, Excel determines the direction of the data series
(down a column or across a row) on the basis of the selected range.
|
|
|
61.
|
Clicking the Cancel button in any of the Chart Wizard dialog boxes creates the
chart with the options selected up to that point.
|
|
|
62.
|
Once a chart item is selected, it can be formatted using the Formatting toolbar,
shortcut menu, or the Format menu.
|
|
|
63.
|
Offsetting multiple slices of a 3-D Pie chart increases the impact on the reader
and increases the overall size of the Pie chart.
|
|
|
64.
|
When the Rotation button is clicked in the 3-D View dialog box, a new rotation
setting shows in the Rotation box.
|
|
|
65.
|
You can select and format individual data labels of a chart by clicking a
specific data label after all the data labels have been selected.
|
|
|
66.
|
When a worksheet is magnified, Excel reduces the view of characters on the
screen, but displays more columns and rows.
|
|
|
67.
|
Magnifying or shrinking a worksheet affects only the window size or printout of
the worksheet or chart; it does not change the view.
|
|
|
68.
|
At 800 x 600 resolution, Excel normally displays a chart at 100% magnification
so that the entire chart appears on the screen.
|
|
|
69.
|
Excel allows a percent magnification between 10 and 400 to be entered in the
Zoom box for worksheets and chart sheets.
|
|
|
70.
|
To split the window into panes, click the cell at the intersection of the four
proposed panes and then click Split on the Window menu.
|
|
|
71.
|
When Split is clicked on the Window menu, Excel divides the window into five
panes and displays the center of the worksheet.
|
|
|
72.
|
When a window is split into panes, any change made in one pane has no effect in
the other panes.
|
|
|
73.
|
What-if analysis also is referred to as sensory analysis.
|
|
|
74.
|
When new data is entered, Excel not only recalculates all formulas in a
worksheet, but also redraws any associated charts.
|
|
|
75.
|
When a new assumption is entered, the process of recalculating the worksheet and
redrawing a chart usually takes Excel several minutes, regardless of how many calculations must be
performed or the speed of the computer.
|
Completion
Complete each
statement.
|
|
|
76.
|
_______________________ are values in cells that can be changed to determine new
values for formulas.
|
|
|
77.
|
The _________________________ is a special place in the computer’s memory
that allows you to collect text and graphic items from an Office document and then paste them into
any Office document.
|
|
|
78.
|
Using the mouse to move or copy cells is called
_________________________.
|
|
|
79.
|
Excel displays the error message _________________________ to indicate a cell
reference error.
|
|
|
80.
|
When numbers are entered with a(n) _________________________, Excel immediately
displays the number with an assigned format.
|
|
|
81.
|
To make sure that column titles and row titles display, Excel allows you to
_________________________, so that Excel displays the titles on the screen, no matter how far down or
to the right you scroll.
|
|
|
82.
|
A(n) _________________________ shows the date a workbook, report, or other
document was created or the period it represents.
|
|
|
83.
|
The _________________________ is a function that returns a number that
corresponds to the system date and time, beginning with December 31, 1899.
|
|
|
84.
|
A formula using a(n) _________________________ instructs Excel to keep the cell
reference constant in the formula as it copies it to a destination area.
|
|
|
85.
|
A formula using a(n) _________________________ instructs Excel to adjust the
cell reference in the formula as it copies it to a destination area.
|
|
|
86.
|
A cell reference with only one dollar sign before either the column or the row
is called a(n) _________________________.
|
|
|
87.
|
The _________________________ is a useful function when you want to assign a
value to a cell based on a logical test.
|
|
|
88.
|
A(n) _________________________ is a function in which the action to be taken for
the true or false case includes a second IF function.
|
|
|
89.
|
The _________________________ provides tools that can simplify adding lines,
boxes, and other geometric figures to a worksheet.
|
|
|
90.
|
A(n) _________________________ is a toolbar that is displayed in its own window
and can be moved anywhere in the Excel window.
|
|
|
91.
|
If you drag a toolbar close to the edge of the window, Excel positions the
toolbar in a(n) _________________________.
|
|
|
|
|
|
92.
|
To add a background color of light yellow to the selected cell in the
accompanying figure, click the _________________________ button arrow on the Formatting toolbar, and
then click Light Yellow.
|
|
|
93.
|
To add a drop shadow to a cell, select the desired shadow style on the
_________________________ shown in the accompanying figure.
|
|
|
94.
|
When the _________________________ font style is assigned to a cell, Excel
slants the characters slightly to the right.
|
|
|
95.
|
The _________________________ format draws a line beneath only the characters in
the cell, rather than the entire cell.
|
|
|
96.
|
A(n) _________________________ is a type of chart used to show the relationship
or proportion of parts to a whole, with each slice representing what percent that slice contributes
to the whole.
|
|
|
97.
|
A chart can reside on a separate sheet, called a(n) _________________________,
which contains only the chart.
|
|
|
98.
|
The names that identify the slices of a Pie chart are called
_________________________.
|
|
|
99.
|
The entries that determine the size of the slices in a Pie chart are called the
_________________________.
|
|
|
100.
|
A Pie chart with one or more slices offset from the main portion is called a(n)
_________________________.
|
|
|
101.
|
A 3-D Pie chart can be drawn on a separate chart sheet using the
_________________________ button on the Standard toolbar.
|
|
|
102.
|
The Chart Wizard – Step 4 of 4 – _________________________ dialog
box allows you to draw the chart on a new sheet in the workbook or to draw it as an object in an
existing worksheet.
|
|
|
103.
|
A particular slice in a Pie chart can be emphasized by
_________________________, or exploding, it from the rest of the slices so that it stands out.
|
|
|
104.
|
You can magnify or shrink the appearance of a worksheet or chart by using the
_________________________ box on the Standard toolbar.
|
|
|
105.
|
When working with a large worksheet, the Excel window can be
_________________________ into two or four window panes to view different parts of the worksheet at
the same time.
|
|
|
106.
|
When the Excel window is split, the bar going up and down the middle of the
window is called the _________________________.
|
|
|
107.
|
When the Excel window is split, the bar going across the middle of the window is
called the _________________________.
|
|
|
108.
|
When the Excel window is split, to resize the panes drag either
_________________________ to the desired location in the window.
|
|
|
109.
|
Using Excel to scrutinize the impact of changing values in cells that are
referenced by a formula in another cell is called _________________________.
|
|
|
110.
|
When the desired result of a formula is known, _________________________ can be
used to determine the value of a cell on which the formula depends.
|