Term
To instruct Excel to display a hidden column, position the mouse pointer to the ____.
|
|
Definition
| right of the column heading boundary where the hidden column is located and then drag to the right |
|
|
Term
| Which buttons in the Spelling dialog box will not change the spelling of the word? |
|
Definition
|
|
Term
| To save a previously saved workbook with a new name or on a different drive, ____. |
|
Definition
| click the Save button on the Quick Access Toolbar |
|
|
Term
| 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
| The ____________________ of a worksheet is the version that shows the actual formulas entered, rather than the resulting values. |
|
Definition
|
|
Term
| Excel places a small purple triangle, called a(n) ____________________, in a cell to indicate that a smart tag is available. |
|
Definition
|
|
Term
| When a workbook is sent as an attachment to an e-mail, the recipient can double-click the attachment to open it in Excel, or save it on disk and then open it at a later time. |
|
Definition
|
|
Term
| Excel does not allow the contents of a cell to be aligned vertically |
|
Definition
|
|
Term
| To import data stored on a Web site use a ____. |
|
Definition
|
|
Term
| Most Excel specialists who build Web queries use the worksheet returned from the Web query as an engine to supply data to another ____ in the workbook. |
|
Definition
|
|
Term
| A smart tag indicator is a block plus sign located in the center of the cell. |
|
Definition
|
|
Term
| ____________________ is the process of finding and correcting errors in a worksheet. |
|
Definition
|
|
Term
| If you want to increase or decrease column width significantly, you can right-click a column heading and then use the ____ command on the shortcut menu to change the column’s width. |
|
Definition
|
|
Term
| 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
| To toggle between the values version and the formulas version of a worksheet, hold down the ____ key. |
|
Definition
CTRL key while pressing the ACCENT MARK (`) |
|
|
Term
| 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
Modified Multiple Choice
Using arithmetic operation, the formula, =d4*e4, is the same as which formulas?
|
|
Definition
|
|
Term
| A character is a dot on the screen that contains a color. |
|
Definition
|
|
Term
| Which view allows you to create or modify a worksheet while viewing how it will look in printed format. |
|
Definition
|
|
Term
| Cell references in formulas must be entered in uppercase, and spaces cannot be added before or after arithmetic operators. |
|
Definition
|
|
