Exam 2: Creating a Worksheet and a Chart

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.

To clear the entire worksheet, tap or click the Clear All button on the worksheet.

Excel remembers the last ____ actions you have completed.

The first step in creating an effective worksheet is to make sure you ____.

When you tap or click the Enter box to complete an entry in a cell, the active cell moves down to the next cell in the same column.

List and briefly describe six chart types from which you can choose in Excel. Mention how you select the appropriate type of chart.

Critical Thinking Questions Case 1-1 Perry has recently expanded his business and hired two employees. As a result of this expansion, he is considering carefully how to establish policies and procedures for creating workbooks. -Perry also decides that he should approve ____ of any proposed worksheet.

To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

If you have multiple Excel workbooks open, to close all open workbooks and exit Excel, ____.

A ____ is information that exists on a physical medium such as paper.

____ is/are used to place worksheet, column, and row titles on a worksheet.

____________________ indicates how characters are emphasized.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Selects the cell one worksheet window to the right.

How many chart types does Excel offer?

Which of the following keys moves the insertion point to the end of data in a cell?

Press ____ to select the entire worksheet.

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

You can double-tap or double-click the ____________________ tab of the worksheet whose name you want to change.

Excel can display characters in only three font colors: black, red, and blue.