Exam 18: Excel 2007 Unit D: Working With Charts

As shown in the figure above, item 5 represents ____.

A(n) ____ identifies each data series in a chart.

To show how individual volume changes over time in relation to total volume, use a(n) ____.

Which two charts compare trends over time intervals?

As shown in the figure above, item 8 represents the ____________________.

You can add a text box using the Chart Tools ____ tab.

Describe some of the changes that the Chart Tools Layout tab allows you to make to a chart.

The x-axis and y-axis are, respectively, the ____.

A bar chart compares trends over even time intervals.

When the landscape orientation is selected, the data and chart will be positioned vertically on a page.

You can add data labels by selecting your chart, and clicking the Data Labels button in the Labels group in the Chart Tools ____ tab on the Ribbon.

When the mouse pointer hovers over any chart object, the name of the selected object appears on screen as a(n) ____________________.

A pie chart ____.

You can apply a chart type to an existing data series in a chart to create a(n) ____ chart.

A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.

As shown in the figure above, item 4 points to a ____.

As shown in the figure above, item 1 points to a ____.

You are having trouble keeping track of your personal spending and you decide to create a worksheet and a chart to help you better understand and plan for your personal expenses. The worksheet and chart are shown below. You want to explode the slide for Clothing . Write the procedure for doing this.

As shown in the figure above, item 5 points to the ____________________.

A chart that is inserted directly in the current worksheet is called a(n) ____ chart.