FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Charts

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

A 100% stacked column chart is similar to what other chart in that it converts values to percentages?

A) Clustered column
B) Radar
C) Line
D) Pie

E) B) and D)
F) A) and D)

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

What can you not do from the Select Data Source dialog box?

A) Change chart data range
B) Delete a data series
C) Change chart type
D) Add chart data series

E) A) and B)
F) None of the above

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

________ charts are often used to represent data in educational, scientific, and medical experiments.

Which chart type displays the data vertically?

In a Chart Filter Excel uses a(n)________ to indicate which chart categories are displayed in a chart.

You might want to avoid using 3-D charts because they can distort the appearance of the data.

What does Excel not determine about the value axis when you create a chart?

Which group on the Design tab would you select if you wanted to change the source information in the chart?

A data ________ is a group of related data points.

Match the following terms with their description:

In a pie chart which of the following is a good reason for using category data labels rather than the legend?

A group of data points used in a graph become a data ________.

You can switch the rows and columns in a chart to communicate a different perspective on your data.

A(n)________ is a cell that contains a value used in a chart.

What is not true about an effective chart?

Which chart type displays the data horizontally?

To understand a chart you need to include the chart data.

What font color does Excel use by default for many of its elements?

A bar chart uses ________ bars.

Match the following terms with their description: