Term
| If a cell has a two-digit year of 32, Excel automatically changes it to a four-digit year of ____. |
|
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
| All of the following are valid Excel arithmetic operators except ____. |
|
Definition
|
|
Term
| When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____. |
|
Definition
|
|
Term
| Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas. |
|
Definition
|
|
Term
| In Excel, functions can be entered using any of the following methods except the ____. |
|
Definition
| Function command on the Tools menu |
|
|
Term
| Click ____ in the Conditional Formatting gallery to display the New Formatting Rule dialog box. |
|
Definition
|
|
Term
| When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of ____. |
|
Definition
| 8.43 characters, or 64 pixels |
|
|
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
| 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
| If a single cell is selected so that the formula bar is not active and then the spell checker is started, Excel checks ____. |
|
Definition
| the remainder of the worksheet, including notes and embedded charts |
|
|
Term
| In the Print dialog box shown in the accompanying figure, the ____ instructs Excel to print the selected range. |
|
Definition
|
|
Term
| 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
| Active sheet(s) option button |
|
|
Term
| In the Print dialog box shown in the accompanying figure, the ____ instructs Excel to print all the worksheets with content in the workbook. |
|
Definition
| Entire workbook option button |
|
|
Term
| Excel does not display the Print dialog box shown in the accompanying figure when the ____ is used. |
|
Definition
| Print button on the Quick Access Toolbar |
|
|
Term
| In the accompanying figure, the Page Setup button displays the ____ dialog box. |
|
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
| The ____ of the worksheet shows the actual formulas you have entered, rather than the resulting values. |
|
Definition
|
|
Term
| 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
| In the accompanying figure, what is the first step in renaming the worksheet? |
|
Definition
| Double-click the worksheet tab. |
|
|
