Term 1

If a cell has a two-digit year of 32, Excel automatically changes it to a four-digit year of ____.

Definition 1

1932

Term 2

To save a previously saved workbook with a new name or on a different drive, ____.

Definition 2

click the Save button on the Quick Access Toolbar

Term 3


All of the following are valid Excel arithmetic operators except ____.

Definition 3

>
-

Term 4

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

Definition 4

26

Term 5

Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas.

Definition 5

recalculates all

Term 6


In Excel, functions can be entered using any of the following methods except the ____.

Definition 6

Function command on the Tools menu
-

Term 7

Click ____ in the Conditional Formatting gallery to display the New Formatting Rule dialog box.

Definition 7

New Rule

Term 8

When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of ____.

Definition 8

8.43 characters, or 64 pixels

Term 9


To instruct Excel to display a hidden column, position the mouse pointer to the ____.

Definition 9

right of the column heading boundary where the hidden column is located and then drag to the right
-

Term 10

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 10

Column Width

Term 11


If a single cell is selected so that the formula bar is not active and then the spell checker is started, Excel checks ____.

Definition 11

the remainder of the worksheet, including notes and embedded charts

Term 12

In the Print dialog box shown in the accompanying figure, the ____ instructs Excel to print the selected range.

Definition 12

Selection option button
-

Term 13

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 13

Active sheet(s) option button

Term 14

In the Print dialog box shown in the accompanying figure, the ____ instructs Excel to print all the worksheets with content in the workbook.

Definition 14

Entire workbook option button

Term 15

Excel does not display the Print dialog box shown in the accompanying figure when the ____ is used.

Definition 15

Print button on the Quick Access Toolbar
-

Term 16

In the accompanying figure, the Page Setup button displays the ____ dialog box.

Definition 16

Page Setup

Term 17

To toggle between the values version and the formulas version of a worksheet, hold down the ____ key.

Definition 17

CTRL key while pressing the ACCENT MARK (`)

Term 18


The ____ of the worksheet shows the actual formulas you have entered, rather than the resulting values.

Definition 18

formulas version
-

Term 19

To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then ____.

Definition 19

press the ENTER key

Term 20

In the accompanying figure, what is the first step in renaming the worksheet?

Definition 20

Double-click the worksheet tab.