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
| 6. In Excel, functions can be entered using any of the following methods except the _____. |
|
Definition
| a. Function command on the Tools menu |
|
|
Term
| 8. If Range Finder is used to change cells referenced in a formula, press the _____ key to complete the edit. |
|
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
| 23. When Excel first is installed, all of the following Web queries are available except _____. |
|
Definition
| d. MSN MoneyCentral Investor Commodity Prices |
|
|
Term
| 1. One of the reasons Excel is such a valuable tool is that a(n) _________________________ can be assigned to a cell and Excel will calculate the result. |
|
Definition
|
|
Term
| 2. The _________________________ preceding a formula is important because it alerts Excel that a formula or function is being entered and not text. |
|
Definition
|
|
Term
| 3. When more than one arithmetic operator is involved in a formula, Excel follows the same basic _________________________ that is used in algebra. |
|
Definition
|
|
Term
| 4. _________________________ allows cells to be selected for use in a formula by using the mouse. |
|
Definition
|
|
Term
| 9. The values used with a function are called _________________________. |
|
Definition
|
|
Term
| 15. A(n) _________________________ is a dollar sign that appears to the far left in a cell, often with spaces between it and the first digit |
|
Definition
|
|
