Multiple Choice Identify the
choice that best completes the statement or answers the question.
|
|
1.
|
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 |
|
|
2.
|
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals
_____.
|
|
3.
|
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 |
|
|
4.
|
Which of the following is the path to the Copy and Paste buttons?
a. | (Home tab | Copy group) | c. | (Home tab | Clipboard
group) | b. | (Home tab | Paste group) | d. | (Home tab | Formulas group) |
|
|
5.
|
A _____ cell in Excel has a numerical value of zero.
a. | blank | c. | copied | b. | formatted | d. | filled |
|
|
6.
|
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.
|
|
7.
|
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) |
|
|
8.
|
The _____ function displays the highest value in a range.
|
|
9.
|
The _____ function determines the lowest number in a range.
|
|
10.
|
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 |
|
|
11.
|
To paste copied cell contents, you can press the _____ keys.
a. | CTRL+C | c. | CTRL+V | b. | CTRL+P | d. | CTRL+X |
|
|
12.
|
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 |
|
|
13.
|
A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill
effects.
a. | scheme | c. | theme | b. | gallery | d. | style |
|
|
14.
|
You can open the Format Cells dialog box by pressing the _____ keys.
a. | SHIFT+TAB | c. | ALT+1 | b. | CTRL+1 | d. | SHIFT+F1 |
|
|
15.
|
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) |
|
|
16.
|
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) |
|
|
17.
|
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 |
|
|
18.
|
When you decrease the row height to _____, the row is hidden.
|
|
19.
|
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) |
|
|
20.
|
_____ 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 |
|