Microsoft Office Excel 2007 is the presentation program in Microsoft Office2007.

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.

Saving a workbook means loading an existing workbook file from a disk into the program window.

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

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

In Excel, a computerized spreadsheet is called a ____.

When Excel starts, the program window displays a blank workbook titled Book1, which includes ____ blank worksheets.

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

____ appear horizontally and are identified by numbers on the left side of the worksheet window.

Each cell is identified by a unique cell reference, which is formed by combining the cell’s column letter and ____.

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

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

Numbers that extend beyond a cell’s width appear as ____ in the cell.

The____ always appear in the Formula Bar.

To edit the data directly in a cell, make the cell active and then press the ____ key or double-click the cell.

To replace cell contents, select the cell, type the new data, and then enter the data by clicking the Enter button on the Formula Bar or by pressing the ____.

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.

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

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.

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

To switch to Print Preview, click ____ in the Print dialog box.

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

You can close a workbook by clicking the Office Button to display the Office menu and clicking ____.

FIGURE 1-1



Excel Case 1-1
Dori is working in a large worksheet and plans to use the Expanded Find and Replace dialog box shown in Figure 1-1 to help her find and replace some updated information.  Please refer to the figure above as you answer the questions below.

Dori also needs to find an entry she made that was labeled with the name of the president of the company, Kim Stearns.  She cannot remember if she capitalized the president’s first and last name and she may have even misspelled “Stearns” as “Stearn.”  Which search options should Dori choose?

Excel Case 1-2
Gavin wants to Print Preview his worksheet before printing to check the content and formatting.  Please answer the questions below.

Gavin wants to magnify the view of the worksheet to double-check some of the figures.  What would he do to magnify the view?