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 |
|
|
Term
| 14. To check the spelling of the text in a single cell, _____ to make the formula bar active and then click the Spelling button on the Standard toolbar. |
|
Definition
|
|
Term
| 15. If a single cell is selected so that the formula bar is not active and then the spell checker is started, Excel checks _____. |
|
Definition
| b. the remainder of the worksheet, including notes and embedded charts |
|
|
Term
| 16. Rather than click the Next and Previous buttons to move from page to page in the Preview window, the _____ keys can be pressed. |
|
Definition
|
|
Term
| 17. When the mouse pointer shape is a magnifying glass, the previewed page in the Preview window can be clicked to carry out the function of the _____ button. |
|
Definition
|
|
Term
| 18. Excel does not display the Print dialog box shown in the accompanying figure when the _____ is used. |
|
Definition
| d. Print button on the Standard toolbar |
|
|
Term
| 19. In the Print dialog box shown in the accompanying figure, the _____ instructs Excel to print the selected range. |
|
Definition
| a. Selection option button |
|
|
Term
| 20. In the Print dialog shown in the accompanying figure, the _____instructs Excel to print the worksheet currently on the screen or the selected worksheets. |
|
Definition
| c. Active sheet(s) option button |
|
|
