Multiple Choice Identify the
choice that best completes the statement or answers the question.
|
|
1.
|
A _____ is a prewritten formula that is built into Excel.
a. | function | c. | task | b. | feature | d. | calculation |
|
|
2.
|
To start a new line in a cell, press the _____ keys.
a. | CTRL+ENTER | c. | ALT+ENTER | b. | TAB+ENTER | d. | SHIFT+ENTER |
|
|
3.
|
All of the following are valid Excel arithmetic operators except
_____.
|
|
4.
|
Which of the following calculations multiplies 23 by 0.01?
a. | =23% | c. | =23+.01 | b. | =23 | d. | =24-.01 |
|
|
5.
|
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. | positioning | b. | operations | d. | selections |
|
|
6.
|
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals
_____.
|
|
7.
|
Which of the following happens when you enter the formula =G15 into a
cell?
a. | Excel recalculates all formulas in the worksheet | c. | Excel assigns the value in cell G15
to the active cell | b. | Excel assigns the sum of the values in the
previous 15 cells to the active cell | d. | Nothing; =G15 is an invalid formula |
|
|
8.
|
The adjusted cell references in a copied and pasted formula are called _____
references.
a. | related | c. | pasted | b. | relative | d. | alternative |
|
|
9.
|
You can click the _____ button to undo an automatic correction.
a. | Auto Fill Options | c. | Paste Options | b. | AutoCorrect Options | d. | Trace Error |
|
|
10.
|
Which of the following Option buttons gives options for filling cells following
a fill operation?
a. | Auto Fill Options | c. | Insert Options | b. | AutoCorrect Options | d. | Paste Options |
|
|
11.
|
The _____ Option button lists formatting options following an insertion of
cells, rows, or columns.
a. | AutoCorrect | c. | Auto Fill | b. | Insert | d. | Paste |
|
|
12.
|
A _____ cell in Excel has a numerical value of zero.
a. | blank | c. | copied | b. | formatted | d. | filled |
|
|
13.
|
The _____ function sums the numbers in the specified range and then divides the
sum by the number of cells with numeric values in the range.
|
|
14.
|
Excel automatically appends the _____ to complete the AVERAGE function when you
click the Enter box or press the ENTER key.
a. | left parenthesis | c. | right parenthesis | b. | right bracket | d. | left bracket |
|
|
15.
|
Which of the following is the path to the Sum button?
a. | (Editing tab | Home group) | c. | (Home tab | Clipboard
group) | b. | (Home tab | Editing group) | d. | (Calculation tab | Editing group) |
|
|
16.
|
You should _____ a function name in the Formula AutoComplete list to select the
function.
a. | double-click | c. | right-click | b. | click | d. | none of the
above |
|
|
17.
|
The _____ function displays the highest value in a range.
|
|
18.
|
The _____ function determines the lowest number in a range.
|
|
19.
|
To copy cell contents, you can select the cell and then press the _____
keys.
a. | CTRL+V | c. | CTRL+B | b. | CTRL+X | d. | CTRL+C |
|
|
20.
|
To paste copied cell contents, you can press the _____ keys.
a. | CTRL+C | c. | CTRL+V | b. | CTRL+P | d. | CTRL+X |
|
|
21.
|
You can use the _____ to check which cells are referenced in the formula
assigned to the active cell.
a. | Formula Finder | c. | Calculation Finder | b. | Range Finder | d. | Function Finder |
|
|
22.
|
A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill
effects.
a. | scheme | c. | theme | b. | gallery | d. | style |
|
|
23.
|
The most popular background color is _____.
a. | blue | c. | red | b. | white | d. | yellow |
|
|
24.
|
The _____ displays numbers with a fixed dollar sign to the left of the number, a
comma every three positions to the left of the decimal point, and displays numbers to the nearest
cent.
a. | Comma style format | c. | Percent style format | b. | Accounting number format | d. | Currency style
format |
|
|
25.
|
Which of the following is the path to the Comma Style button?
a. | (Home tab | Alignment group) | c. | (Home tab | Cells
group) | b. | (Home tab | Font group) | d. | (Home tab | Number group) |
|
|
26.
|
Which of the following is the path to the Conditional Formatting button?
a. | (Home tab | Editing group) | c. | (Formatting tab | Styles
group) | b. | (Styles tab | Formatting group) | d. | (Home tab | Styles
group) |
|
|
27.
|
If you do not assign a format to a cell or cells in a column, the column width
will remain _____ characters.
a. | 8.43 | c. | 11.65 | b. | 7.52 | d. | 9.43 |
|
|
28.
|
When you decrease the row height to _____, the row is hidden.
|
|
29.
|
Which of the following is the path to the Spelling button?
a. | (Home tab | Proofing group) | c. | (Review tab | Proofing
group) | b. | (Proofing tab | Spelling group) | d. | (Review tab | Checking
group) |
|
|
30.
|
_____ view allows you to create or modify a worksheet while viewing how it will
look in printed format.
a. | Normal | c. | Page Break Preview | b. | Page Layout | d. | Full Screen |
|
True/False Indicate whether the
statement is true or false.
|
|
31.
|
The equal sign (=) precedes a formula.
|
|
32.
|
An asterisk (*) following a cell reference in a formula is the arithmetic
operator that directs Excel to perform the division operation.
|
|
33.
|
The arithmetic operator, ^, directs Excel to perform the division
operation.
|
|
34.
|
As in algebra, you can use brackets to override the order of operations Excel
follows to perform formula calculations.
|
|
35.
|
Using Point mode to enter formulas often is faster and more accurate than using
the keyboard to type the entire formula.
|
Completion Complete each
statement.
|
|
36.
|
Worksheet _________________________ typically contain items analogous to items
in a list.
|
|
37.
|
One of the reasons Excel is such a valuable tool is that you can assign a(n)
_________________________ to a cell, and Excel will calculate the result.
|
|
38.
|
The / arithmetic operator indicates _________________________.
|
|
39.
|
In the order of operations, the last operation Excel performs is
_________________________.
|
|
40.
|
_________________________ means that the width of a column will be increased or
decreased so the widest entry will fit in the column.
|