Exam 7: Excel : Charts

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

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

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

How many sizing handle are found on embedded charts?

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

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

A stacked column chart displays multiple columns for each category.

A data ________ is a group of related data points.

A bar chart uses ________ bars.

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

Where does the primary axis display on a Combo chart?

Which tab displays the tools for creating charts?

Including what, distorts the effectiveness of charting data points?

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

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

Which chart type cannot be displayed as a sparkline?

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

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

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

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