Name: 

The intersection of each column and row is called a __________.

The __________ toolbar, which appears automatically based on tasks you perform (such as
selecting text), contains commands related to changing the appearance of text in a worksheet.

In Excel, any set of characters containing a letter, hyphen (as in a telephone number), or
space is considered __________.

In the accompanying figure, the __________ identifies the colors assigned to each bar in the chart on a worksheet.

When you open an Excel file, the application name (Microsoft Excel) is displayed on a selected button on the taskbar. If you point to this button, the file name also appears in a(n) __________.

Which keyboard key moves the insertion point to the beginning of data in a cell?

The __________ button on the Home tab is the only command that clears both the cell entry and the cell formatting.

Excel opens a new workbook with three __________ , as shown in the accompanying figure.

When you click the __________, located in the upper-left corner of the window as shown in the accompanying figure, Excel displays the Office Button menu.

The commands to insert a chart are located on the __________ tab, as shown in the accompanying figure.

A new workbook opens with three worksheets, but additional worksheets can be added as long as your computer has enough memory to accommodate them.

To identify a cell, specify the row number first, followed by the column letter.

To the right of the sheet tabs at the bottom of the screen, as shown in the accompanying figure, is the tab split box, which can be dragged to increase or decrease the view of the sheet tabs.

In the accompanying figure, when a color is chosen on the Font Color palette, Excel changes the Font Color button on the Formatting toolbar to the chosen color.

Excel derives the chart scale based on the values in the worksheet along the vertical axis, also called the y-axis or value axis of the chart.

If a major error is made when typing data into a cell, click the Cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning.

When using in-cell editing, to delete a character or adjacent characters you can use the mouse to drag through the character or characters and then press the DELETE key or click the Cut button on the Standard toolbar.

In Insert mode, Excel replaces the character to the right of the insertion point with the character typed.

The Redo button allows previous actions to be repeated.

Press the SPACEBAR to clear a cell.

__________ is a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from Web sites.

A new blank __________ called Book1 is like a notebook and is created when Excel starts.

A workbook contains __________, each of which has a name that displays on a sheet tab at the bottom of the workbook, as shown in the accompanying figure.

In the figure, the intersection of row 1 and column A is referred to as a(n) __________, which is the basic unit into which data is entered.

The __________ presents information about the worksheet, the function of the button the mouse pointer is pointing to, or the mode of Excel.

Excel’s __________ feature is used to correct common mistakes made during text entry.

When cell references are copied, each cell reference that Excel automatically adjusts for the new position is called a(n) __________.

The opposite of cell merging is cell __________, which is done by selecting a merged cell and clicking the Merge and Center button.

Excel remembers the last 100 actions you have completed. Thus, you can undo up to 100 previous actions by clicking the __________ button arrow to display the Undo list and then clicking the action to be undone.

As you are clearing cell entries, always remember that you should never press the __________ to clear a cell.

A letter above the worksheet grid, also called the row heading, identifies each column.

Excel positions text right-aligned in a cell, meaning the entry displays to the far left in the cell.

Excel treats any combination of numbers, spaces, and nonnumeric characters as numbers.

To move the worksheet window around to view different parts of the active worksheet, use: __________.

Which correction(s) does the AutoCorrect feature make?

Identify the letter of the choice that best matches the phrase or definition.

Discuss document properties. Include definitions of these terms: metadata, keywords, standard properties, and automatically updated properties. Be sure to give at least two reasons why document properties are valuable.

Critical Thinking Questions

Case 2
Anita is new to Microsoft Office Excel 2007. As she uses the application, she is beginning to see that it offers many features designed to make her use of Excel very easy.

Which of the following features would be helpful to Anita if she wants to see the impact of a particular gallery choice on her worksheet, but she is nervous about actually applying the feature from the outset?

a.	Insert tab	c.	Home tab
b.	live preview	d.	keyboard indicators