FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Excel: Creating a Worksheet and a Chart

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

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

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

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

You should press the SPACEBAR to clear a cell.

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

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

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

Press ____ to select the entire worksheet.

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

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

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

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

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.

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

The ____ button allows you to erase recent cell entries.

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

A thin red border indicates the active cell.