FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 12: Excel: Creating a Worksheet and a Chart

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

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

A) INSERT
B) ENTER
C) TAB
D) ALT

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

Clicking the ____ box completes an entry.

A) Cancel
B) Formula
C) Enter
D) Tab

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

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

By default,text is ____ in a cell.

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

In Excel,a number can contain the characters ____.

Excel remembers the last ____ actions you have completed.

You can insert a function in a cell by ____.

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

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

You should press the SPACEBAR to clear a cell.

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

A thin red border indicates the active cell.

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

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

Worksheet titles and subtitles should be as wordy as possible.

How many chart types does Excel offer?

Both the Cancel box and the Enter box appear on the formula bar when you begin typing 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 clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.