Click here to tell your browser to print these cards.
These are designed to be printed in landscape mode on 4x6 index cards.
To save paper, we recommend using your computer's print preview until you get your printer settings correct.
If a cell has a two-digit year of 32, Excel automatically changes it to a four-digit year of ____. |
1932 |
To save a previously saved workbook with a new name or on a different drive, ____. |
click the Save button on the Quick Access Toolbar |
All of the following are valid Excel arithmetic operators except ____. |
> |
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____. |
26 |
Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas. |
recalculates all |
In Excel, functions can be entered using any of the following methods except the ____. |
Function command on the Tools menu |
Click ____ in the Conditional Formatting gallery to display the New Formatting Rule dialog box. |
New Rule |
When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of ____. |
8.43 characters, or 64 pixels |
To instruct Excel to display a hidden column, position the mouse pointer to the ____. |
right of the column heading boundary where the hidden column is located and then drag to the right |
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. |
Column Width |
If a single cell is selected so that the formula bar is not active and then the spell checker is started, Excel checks ____. |
the remainder of the worksheet, including notes and embedded charts |
In the Print dialog box shown in the accompanying figure, the ____ instructs Excel to print the selected range. |
Selection option button |
In the Print dialog shown in the accompanying figure, the ____ instructs Excel to print the worksheet currently on the screen or the selected worksheets. |
Active sheet(s) option button |
In the Print dialog box shown in the accompanying figure, the ____ instructs Excel to print all the worksheets with content in the workbook. |
Entire workbook option button |
Excel does not display the Print dialog box shown in the accompanying figure when the ____ is used. |
Print button on the Quick Access Toolbar |
In the accompanying figure, the Page Setup button displays the ____ dialog box. |
Page Setup |
To toggle between the values version and the formulas version of a worksheet, hold down the ____ key. |
CTRL key while pressing the ACCENT MARK (`) |
The ____ of the worksheet shows the actual formulas you have entered, rather than the resulting values. |
formulas version |
To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then ____. |
press the ENTER key |
In the accompanying figure, what is the first step in renaming the worksheet? |
Double-click the worksheet tab. |