Exam 9: Working With Charts

An assortment of different chart layouts can be found in the ____.

A chart layout is a predefined arrangement of chart elements

Data series identify the values on each axis

The chart area is also known as the plot area.

Pointing to a sizing handle of a chart allows you to move it

The ____ is for comparing data equally across categories and series.

The horizontal axis is also known as the Y-axis.

A scatter chart is used for showing relative importance of values over a period of time.

Primary Major Horizontal is an example of a type of  _____________________.

A win/loss sparkline only shows _______ type(s) of bar(s).

You can move the legend of a chart to a new location using the Chart Elements menu

You put together a spreadsheet for your company containing the quarterly sales figures for each region. Each column of the spreadsheet represents a quarter and each row represents a department's figures. Describe which chart type you should use to show how each quarter contributed to the total sales for a single department.

In the accompanying figure, item 3 points to the ____.

After you move a chart to a chart sheet, which button can you use to apply a layout?

To change the color of a sparkline marker is to change its ____.

In the accompanying figure, the item "Month" is the ____.

A trendline is a line that connects high or low points in a data series and shows a trend.

____ are vertical and horizontal lines in a chart that help to identify the value for each data series.

In the accompanying figure, the plot area is ____.