Term
| 1. To start a new line in a cell, press _____ after each line, except for the last line, which is completed by clicking the Enter box, pressing the ENTER key, or pressing one of the arrow keys. |
|
Definition
|
|
Term
| 2. All of the following are valid Excel arithmetic operators except _____. |
|
Definition
|
|
Term
| 3. When Excel follows the order of operations, the formula, 8 * 3 + 2, equals _____. |
|
Definition
|
|
Term
| 4. When an error occurs in a formula in a cell, Excel displays the _____ button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell. |
|
Definition
|
|
Term
| 5. The _____ button lists formatting options following an insert of cells, row, or columns. |
|
Definition
|
|
Term
| 6. In Excel, functions can be entered using any of the following methods except the _____. |
|
Definition
| a. Function command on the Tools menu |
|
|
Term
| 7. To save a saved workbook using a new name or on a different drive, _____. |
|
Definition
| b. click Save As on the File menu |
|
|
Term
| 8. If Range Finder is used to change cells referenced in a formula, press the _____ key to complete the edit. |
|
Definition
|
|
Term
| 9. A(n) _____ dollar sign always appears immediately to the left of the first digit. |
|
Definition
|
|
Term
| 10. The _____ in the Conditional Formatting dialog box can be used to remove one or more active conditions. |
|
Definition
|
|
Term
| 11. When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of _____. |
|
Definition
| a. 8.43 characters, or 64 pixels |
|
|
Term
| 12. To set a column width to best fit, _____ boundary of the column heading above row 1. |
|
Definition
| d. double-click the right |
|
|
Term
| 13. To instruct Excel to display a hidden column, position the mouse pointer to the _____. |
|
Definition
| d. right of the column heading boundary where the hidden column is located and then drag to the right |
|
|
