Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
Click ____ in the Conditional Formatting gallery to display the New Formatting
Rule dialog box.
a. | Rule Format | c. | New Format | b. | New Rule | d. | Format Rule |
|
|
|
2.
|
As with column widths, when you decrease the row height to 0, the row is
____.
a. | hidden | b. | visible temporarily at the top of the
worksheet | c. | deleted | d. | visible temporarily on the left side of the
worksheet |
|
|
|
Figure 2-3
|
|
|
3.
|
In the Print dialog box shown in the accompanying figure, the ____ instructs
Excel to print the selected range.
a. | Selection option button | c. | Active sheet(s) option
button | b. | Print to file check box | d. | Collate check box |
|
|
|
Figure 2-2
|
|
|
4.
|
The ____ button, in the accompanying figure, allows you to view the page in
larger or smaller sizes in the Preview window.
a. | Next page | c. | Page Setup | b. | Zoom | d. | Preview |
|
|
|
5.
|
The process of finding and correcting errors in a worksheet is called
____.
a. | searching and replacing | c. | verifying | b. | debugging | d. | validating |
|
|
|
6.
|
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 |
|
|
|
7.
|
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 |
|
|
|
8.
|
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 |
|
|
|
9.
|
The ____ function is useful when you want to assign a value to a cell based on a
logical test.
|
|
|
10.
|
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 |
|
True/False
Indicate whether the
statement is true or false.
|
|
|
Figure 1-3
|
|
|
11.
|
In the accompanying figure, a requirements document includes a needs statement,
source of data, summary of calculations, and any other special requirements for a worksheet.
|
|
|
12.
|
All commands on the Mini toolbar also exist on the Ribbon.
|
|
|
13.
|
If each cell in a selected range is next to a row of numbers, Excel assigns the
SUM function to each cell in the selected range when the Sum button is clicked.
|
|
|
14.
|
To use the AutoCalculate area, select the range of cells containing the numbers
you want to check and then double-click the AutoCalculate area to display the Status Bar
Configuration shortcut menu.
|
|
|
15.
|
If a major error is made when typing data into a cell, click the Cancel box in
the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the
beginning.
|
|
|
16.
|
In Overtype mode, Excel inserts the typed character and moves all characters to
the right of the typed character one position to the right.
|
|
|
Figure 2-1
|
|
|
17.
|
In the accompanying figure, the two middle scroll buttons to the left of the
sheet tabs move to the first or last worksheet in the workbook.
|
|
|
Figure 3-3
|
|
|
18.
|
In the accompanying figure, the worksheet in the Window is split at the orange
double lines.
|
|
|
Figure 3-1
|
|
|
19.
|
In the accompanying figure, drag the Text hand in the Orientation area to the 45
point and to display 45 in the Degrees box.
|
|
|
20.
|
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.
|
Matching
|
|
|
a. | Mini toolbar | f. | gallery | b. | menu | g. | Key Tip badge | c. | shortcut
menu | h. | Quick Access
Toolbar | d. | Microsoft Office Button | i. | Ribbon | e. | gridline | j. | status bar |
|
|
|
21.
|
Provides easy, central access to the tasks you perform while creating a
worksheet.
|
|
|
22.
|
A set of choices, often graphical, arranged in a grid or in a list.
|
|
|
Identify the letter of the choice that best matches the phrase or
definition. a. | Web query | f. | smart tag | b. | order of
operations | g. | function | c. | arguments | h. | pixel | d. | theme | i. | debugging | e. | condition | j. | spell checker |
|
|
|
23.
|
Values that are used with a function.
|
|
|
Identify the letter of the choice that best matches the phrase or
definition. a. | NOW function | f. | #NAME? | b. | Fill Formatting
Only | g. | Keep Source
Formatting | c. | goal seeking | h. | Formatting Only | d. | what-if analysis | i. | IF function | e. | Pie
chart | j. | absolute cell
referencing |
|
|
|
24.
|
Indicates a cell is using a name Excel does not recognize.
|
|
|
25.
|
Scrutinizes the impact of changing values in cells that are referenced by a
formula in another cell.
|