Exam 16: Using Advanced Chart Features

To instantly create a chart in its own chart sheet, simply select the range of data you want in the chart and press ____.

You can create a sparkline for each row or column of data within a worksheet.

The Charts group, which allows you to create a chart, is found on the Insert tab on the Ribbon.

The y-axis on the left side of a combination chart is called the secondary axis.

____ represent where the actual data would be in the chart.

Case EX 10-1 Stephanie is the owner of a boutique store in downtown Chicago. She has been using Excel to keep track of the sales and costs for each month for her store. Stephanie has created a line chart from her data. If she wants to add the actual data values to the chart, she can insert ____.

Case EX 10-2 George is managing the fundraising efforts of a non-profit organization that provides services to the homeless. George is very proud of his performance because he has been able to make great progress in meeting the organization's fundraising goals. He can use a ____ chart to showcase the amount of progress accomplished so far.

The horizontal lines within a chart are called the horizontal ____________________.

The data table used to create a chart appears above the chart.

You can choose to have the legend appear as part of the data table rather than having the legend displayed in a separate part of the chart.

A(n) data table displays the data used to create a chart.

You can copy and paste formats from one label to another using the Format ____ feature.

On the Format tab in the Labels group, click Chart Title, and then click Above Chart to add a chart title above the chart.

Sparklines are displayed ____.

When making a chart with two y-axes, you will need to use a ____ data series.

Adding data labels allows you to see the value for each data marker in the chart.

FIGURE EX 10-1 In Figure EX 10-1 above, item 1 points to the ____.

The type of chart you choose determines how the data in the rows and columns will appear in the chart.

A(n) ____________________ lets you quickly view the worksheet data while looking at the chart data series.

You can have the high, low, first, and last points on a sparkline display with ____________________.