FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Excel : Charts

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Short Answer

Review LaterAdd Note

Review Later

Column charts are the most effective when they have ________ or fewer categories.

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

When you point to a chart element Excel displays a(n)________ with the name of the element.

Correct Answer

verified

ScreenTip,...

View Answer

Show Answer

Question 33

Short Answer

Review LaterAdd Note

A bar chart uses ________ bars.

To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.

A stacked column chart displays multiple columns for each category.

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

The Chart Styles gallery displays style options for the selected chart only.

Which tab displays the tools for creating charts?

Match the following terms with their description: I. X-axis II. Y-axis III. Chart area IV. Plot area V. Legend A. Holds the entire chart B. Vertical border C. Uses color or patterns to identify each data series D. Horizontal border E. Both axes form a border for this

Where does the primary axis display on a Combo chart?

Which chart type cannot be displayed as a sparkline?

How many sizing handle are found on embedded charts?

What group is not found on the Sparkline Tools Design tab?

When you want to chart two related types of data, the Combo chart is perfect.

Which chart type is a visual "dashboard" of your data?

Including what, distorts the effectiveness of charting data points?

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

What chart type can display two different chart types at the same time?

A data ________ is a group of related data points.

In a(n)________ column chart data appears as side by side columns.