Exam 9: Excel: Creating a Worksheet and a Chart

A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

Discuss how to correct errors after entering data into a cell using in-cell editing.

The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.

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

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

You should press the SPACEBAR to clear a cell.

The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.

While typing in a cell, you can press the ____________________ key to erase all the characters back to and including the incorrect character you just typed.

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

The active cell reference appears in the ____________________ on the left side of the formula bar.

Worksheet ____________________ typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet.

A character with a point size of 10 is about 10/72 of one inch in height.

A thin red border indicates the active cell.

The ____ button allows you to erase recent cell entries.

A cell is selected, or ____________________, when a heavy border surrounds the cell, as shown in the accompanying figure.

Press ____ to select the entire worksheet.

As you type, Excel displays the entry (and the Cancel box and Enter box) in the ____________________.

Modified Multiple Choice The characters that Excel displays on the screen are a specific ____.