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
| c. the spelling of all sheets in the workbook |
|
|
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
| b. DOWN ARROW and UP ARROW |
|
|
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 |
|
|
Term
| 21. In the Print dialog box shown in the accompanying figure, the _____ instructs Excel to print all the worksheets with content in the workbook. |
|
Definition
| a. Entire workbook option button |
|
|
Term
| 22. To toggle between the values version and the formulas version of a worksheet, hold down the _____ key. |
|
Definition
| c. CTRL key while pressing the ACCENT MARK (`) |
|
|
Term
| 23. When Excel first is installed, all of the following Web queries are available except _____. |
|
Definition
| d. MSN MoneyCentral Investor Commodity Prices |
|
|
Term
| 24. To change the stock symbols Excel uses when refreshing the data in a Web query, click the _____ on the External Data toolbar. |
|
Definition
| b. Query Parameters button |
|
|
Term
| 25. To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then _____. |
|
Definition
|
|
Term
| 1. If a formula is entered into cell F4 to multiply the values in cells D4 and E4, Excel recalculates the product whenever new values are entered into those cells and displays the result in cell F4. |
|
Definition
|
|
Term
| 2. The arithmetic operator, ^, directs Excel to perform the division operation. |
|
Definition
|
|
Term
| 3. Cell references in formulas must be entered in uppercase, and spaces cannot be added before or after arithmetic operators. |
|
Definition
|
|
Term
| 4. Regardless of the length and complexity of a formula, using Point mode to enter formulas always is slower and less accurate than using the keyboard. |
|
Definition
|
|
Term
| 5. When a formula is copied, Excel adjusts the cell references so the new formulas contain references corresponding to the new location and performs calculations using the appropriate values. |
|
Definition
|
|
Term
| 6. A smart tag indicator is a block plus sign located in the center of the cell. |
|
Definition
|
|
Term
| 7. The AVERAGE function requires that the argument (the range) be included within parentheses before the function name. |
|
Definition
|
|
Term
| 8. When Point mode is used to enter a formula or function, the arrow keys can be used to complete the entry. |
|
Definition
|
|
Term
| 9. The AutoSum button menu allows one of five often-used functions to be entered easily into a cell without requiring that its name or the required arguments be memorized. |
|
Definition
|
|
Term
| 10. Excel has more than 400 functions. |
|
Definition
|
|
Term
| 11. One of the least common mistakes made with Excel is to include the wrong cell reference in a formula. |
|
Definition
|
|
