Exam 16: Using Advanced Chart Features

Excel has three types of sparklines: Line, Win/Loss, and ____.

Once you create a chart, it cannot be changed to another type of chart.

The Format Painter button is found on the Clipboard group on the ____ tab.

The horizontal axis of a chart is called the ____.

If you select the ____ feature, all data points on the sparklines will be highlighted.

Case EX 10-2 George is managing the fundraising efforts of a non-profit organization that provides services to the homeless. George does not want any lines showing within the chart that he creates. He needs to remove the horizontal and vertical ____.

Charts are easy to make but difficult to format.

Discuss the situations in which you would choose a combination chart and the situations in which you would choose a gauge chart.

Chart templates are saved in the same default location as the preformatted chart templates.

A gauge chart is also called a ____ chart.

The Save As Template command is found on the ____ tab.

The Switch Row/Column button is found on the ____ tab.

To delete the legend from a chart, click the legend and then press Delete.

A(n) ____________________ chart shows the amount of progress accomplished toward a goal.

The ____________________ is the foundation, or base, of a 3-D chart.

Each line of data in a line chart is a(n) ____.

A ____ is a list that shows the colors and symbols used in a chart.

A chart that shows data on two y-axes for the purpose of showing different data is called a ____ 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. If Stephanie wants to display a miniature chart next to each row of her worksheet that will reflect the net profit or loss, she can create ____.