Exam 30: Working With Charts

You switch between a chart sheet and a worksheet by clicking the appropriate ____.

A selected chart element is surrounded by a ____.

Embedded charts are useful when you want to print a chart next to the data the chart illustrates.

A pie chart is similar to the column chart, but columns are replaced by points connected by a line.

You can show a variety of data markers on sparklines, including the high and low points, negative point, first and last points, and all data points. These options are available in the ____________________ group.

A(n) ____________________ is a group of related information in a column or row of a worksheet that is plotted on the chart.

You can delete a selected chart by pressing the F2 key.

Case EX 8-1 Candace wants to create a chart sheet similar to the one shown above. Candace now has the Move Chart dialog box open and wants to name her new chart sheet. Where does she fill in the new name?

You open the Insert Chart dialog box by clicking the Dialog Box Launcher in the ____ group on the Insert tab.

What is the difference between a data marker and a data label? Please describe a situation where you would use both at the same time.

A chart sheet does not have worksheet cells and cannot contain data or formulas.

A bar chart, sometimes called an XY chart, shows the relationship between two categories of data.

To make changes to an element's fill, border color, border style, shadow, 3-D format, alignment, and so forth, you need to open the Chart Elements dialog box.

You can rename a chart sheet like any other worksheet. Right-click its sheet tab, and then click ____ on the shortcut menu.

FIGURE EX 8-1 In Figure EX 8-1 above, under Education Pays, the red and blue boxes labeled Men and Women is the ____.

You can pull one or more slices away from the pie to distinguish them, creating what is called a(n) ____________________ pie chart.

You can quickly choose a layout and styles for a selected chart from the Ribbon. Click the ____ tab under Chart Tools on the Ribbon. In the Chart Layouts group, click the chart layout you want to use.

The quickest way to select a chart element is to ____.

Case EX 8-2 Paco wants to change some of the elements in his chart, including the fill and border color. What type of dialog box does Paco need to access to make these changes?

The chart element called ____ is the graphical representation of all of the data series.