Exam 7: Excel Lesson 1: Microsoft Excel Basics

You can use wildcard characters in the Find what box to search for data that matches a particular pattern. Use ____ for two or more characters.

A(n) ____________________ is an equation that calculates a new value from values currently in a worksheet, such as adding the numbers in cell A1 and A2.

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

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

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: ____.

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

To use the Replace command, in the ____ group on the Home tab of the Ribbon, click the Find & Select button, and then click Replace.

Text is any combination of letters and numbers and symbols, such as headings, labels, or explanatory notes.

A group of selected cells is called a(n) ____________________.

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 ____.

To clear the active cell, you can use the Ribbon, the keyboard, or the mouse.

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

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.

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

The contents of the active cell always appear in the Formula Bar.

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

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

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

The name of each worksheet appears in the ____ at the bottom of the worksheet window.

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