True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
Worksheet titles and subtitles should be as wordy as possible.
|
|
|
2.
|
Both the Cancel button and the Enter button appear on the formula bar when you
begin typing in a cell.
|
|
|
3.
|
The AutoCorrect feature can automatically capitalize the first letter in the
names of days.
|
|
|
4.
|
Excel can display characters in only three font colors: black, red, and
blue.
|
|
|
5.
|
The most common error when entering a formula is to reference the wrong cell in
the formula.
|
|
|
6.
|
The arithmetic operator, ^, directs Excel to perform the division
operation.
|
|
|
7.
|
Excel has more than 400 functions that perform just about every type of
calculation you can imagine.
|
|
|
8.
|
The path to the Logical button is (FORMULAS tab | Function Library
group).
|
|
|
9.
|
Excel includes four types of sparkline charts: line, column, win/loss, and
stock.
|
|
|
10.
|
The range of entries that identifies the major groups for a clustered column
chart are called the category names.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
11.
|
Clicking the ____ box completes an entry.
a. | Cancel | c. | Enter | b. | Formula | d. | Tab |
|
|
|
12.
|
You can enter the correct range in a function by typing the beginning and ending
cell references separated by a ____.
a. | semi-colon | c. | period | b. | colon | d. | none of these |
|
|
|
13.
|
A ____ reference is an adjusted cell reference in a copied and pasted
formula.
a. | revised | c. | recycled | b. | relative | d. | retained |
|
|
|
14.
|
Combining two or more selected cells into one cell is called ____ cells.
a. | merging | c. | combining | b. | mixing | d. | spanning |
|
|
|
15.
|
Excel remembers the last ____ actions you have completed.
|
|
|
16.
|
A ____ is a prewritten formula that is built into Excel.
a. | function | c. | task | b. | feature | d. | calculation |
|
|
|
17.
|
Which of the following calculations multiplies 23 by 0.01?
a. | =23 | c. | =23% | b. | =23+.01 | d. | =24-.01 |
|
|
|
18.
|
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. | operations | b. | positioning | d. | selectins |
|
|
|
19.
|
The adjusted cell references in a copied and pasted formula are called ____ cell
references.
a. | related | c. | pasted | b. | relative | d. | alternative |
|
|
|
20.
|
You can use the ____ to check which cells are referenced in the formula assigned
to the active cell.
a. | Formula Finder | c. | Calcualtion Finder | b. | Range Finder | d. | Function Finder |
|
|
|
21.
|
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 |
|
|
|
22.
|
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. | NOW | b. | DATETIME | d. | CURRENT |
|
|
|
23.
|
Which of the following formulas contains an absolute cell reference?
|
|
|
24.
|
You can press the ____ keys to open the Format Cells dialog box.
a. | CTRL+1 | c. | CTRL+3 | b. | CTRL+2 | d. | CTRL+4 |
|
|
|
25.
|
The path to the Format Painter button is ____.
a. | (HOME tab | Number group) | c. | (HOME tab | Painting
group) | b. | (HOME tab | Clipboard group) | d. | (HOME tab | Font
group) |
|