Exam 8: Excel: Creating a Worksheet and an Embedded Chart

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.

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

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

What is the title of the blank workbook that opens when you first start Excel from the Windows Start menu?

Figure 1-2 In the accompanying figure, by using the __________ area on the status bar, you easily can obtain a total, an average, or other information about the numbers in a range.

Figure 1-2 In the accompanying figure, the __________, located by default above the Ribbon, provides easy access to frequently used commands.

With the range to chart selected, click the Column button on the Ribbon tab to initiate drawing a chart.

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.

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

A(n)__________ is a series of two or more adjacent cells in a column or rectangular group or cells.

Discuss saving a project, including definitions of the terms file and file name in the discussion. Include the two reasons why it is important to save a workbook frequently, and discuss the considerations involved in the selection of a storage medium.

Critical Thinking Questions Case 1-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. Anita has decided that she would like to make better use of the keyboard. Which of the following features would alert her to any available keyboard shortcuts associated with commands on the Ribbon?

The __________ specifies the size of the characters on the screen and is gauged by a measurement system called points. A single point is about 1/72 of one inch in height.

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right.

As you type, Excel displays the entry in the __________, and also displays the active cell reference in the Name box on the left.

The Redo button allows previous actions to be repeated.

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