Exam 15: Microsoft Excel Basics

If you want to see more cells in the work area, click the Zoom Out button or drag the Zoom slider to the ____ to decrease the zoom percentage.

You can close a workbook by clicking the ____ tab on the Ribbon, and then clicking Close in the navigation bar.

You can create a new folder in which to save a file by clicking the New folder button in the Save As ____________________. Type a name for the new folder, and then press the Enter key.

The ____ tab enables you to select the number of copies to print, a printer, the parts of the worksheet to print, and the way the printed worksheet will look.

The column letter and row number of the active cell are shaded in red for easy identification.

____ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.

When you use the Find command , new data is substituted for the data found.

The Formula Bar appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value.

To replace cell contents, you can select the cell, type the new data, and then enter the data by ____.

You can also close the workbook and leave Excel open by clicking the Close Window button located below the sizing buttons in the status bar.

The default magnification for a workbook is ____, which you can see on the Zoom level button.

The range is identified by its range reference, which is the cell in its upper-left corner and the cell in its lower-right corner, separated by a ____.

The ____, or cell reference area located below the Ribbon, displays the cell reference of the active cell.

FIGURE EX 1-1 Referring to Figure EX 1-1 above, if you wanted to find an entry for an employee s name which may be misspelled, and you cannot remember if you capitalized the first and last name, you would choose the following search option: ____.

If a cell is not wide enough to display all the cell's contents, extra text extends into the next cells if there is room.

Case EX 1-2 Donovan is starting to use the keyboard to navigate around an Excel spreadsheet. To move to cell A1, Donovan presses the ____ .

If you try to close a workbook that contains changes you haven't saved, ____.

The Save As command saves an existing workbook on a disk, using its current name and save location.

When you press and hold down a(n) ____________________ key, the active cell shifts in that direction repeatedly and quickly.