Exam 9: Working With Charts

Clustered Column is a type of Column chart

Compare a chart layout to a chart style.

A chart layout is a predefined set of chart colors and fills. 

In the accompanying figure, in each category, there are ____ data series.

The chart background is an example of  a chart object .

To change fill colors, textures and fonts for your chart, click the Chart ____ button.

To select nonadjacent ranges, hold the ____ key.

The Move Chart button is in the ____ group on the CHART TOOLS DESIGN tab.

The vertical axis provides values, not categories.

If you want to modify the formatting or alignment of a chart element, you can do so  in the ____ pane.

Tiny charts that fit into one cell and show a trend are known as ____.

A column sparkline is a miniature line chart that includes a bar for each cell in a selected ____.

The ____ is the horizontal line at the base of the chart that shows categories.

Explain what a data table is.

Describe how to print a chart without printing the worksheet data.

The ____ identifies what each data series represents.

The Switch Row/Column button is in the ____ group on the CHART TOOLS DESIGN tab.

On the CHART TOOLS FORMAT tab, click the More button in the ______________ Styles gallery to add a shape style to your chart element.

You can add _____ to a sparkline to indicate values for each cell in the selected range.

A ____ sheet does not include any worksheet cells.