Exam 3: Charts

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

Where does the primary axis display on a Combo chart?

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

Which tab displays the tools for creating charts?

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

Where does Excel display the Quick Analysis tool?

A stacked column chart displays multiple columns for each category.

In the task pane,what does a diagonal black triangle next to a chart category indicate?

Pie charts can only display one data series.

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

Which axis in a chart displays incremental numbers for the data points?

The range used for a sparkline cannot include more than one row.

A data ________ is a group of related data points.

Excel uses ________ to determine what categories are visible in a chart.

Including what,distorts the effectiveness of charting data points?

Effective charts never overwhelm an audience.

How many sizing handle are found on embedded charts?

When you want to create a chart you first need to select a data ________.

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

Picking a chart ________ will allow you to change several formatting elements at the same time.