Exam 12: Excel: Creating a Worksheet and a Chart

You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.

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.

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

Excel's ____________________ function,which adds all of the numbers in a range of cells,provides a convenient means to calculate a total.

Which of the following keys toggles between Insert mode and Overtype mode?

In Excel,a number can contain the characters ____.

Identify the letter of the choice that best matches the phrase or definition. -Highlights one or more adjacent characters to the right.

The opposite of merging cells is splitting a merged cell._________________________

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.

Clicking the ____ box completes an entry.

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

A thin red border indicates the active cell.

By default,text is ____ in a cell.

Identify the letter of the choice that best matches the phrase or definition. -Moves the insertion point to the end of data in a cell.

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

How many chart types does Excel offer?

You can insert a function in a cell by ____.

Excel remembers the last ____ actions you have completed.

Worksheet titles and subtitles should be as wordy as possible.