Exam 9: Analyzing and Charting Financial Data

In the figure above, pv stands for the ____.

A chart sheet can contain ____.

Placing a chart in a ____ displays only the chart and no worksheet cells.

A chart that compares three set of values in a three-dimensional chart is _____.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares a collection of values from several different data sets.

____ is the amount added to the prinicpal of a loan by the lender.

-In the figure above, the biggest slice is the cases of _______.

The _______ displays the data series in separate columns side-by-side so that you can compare the relative heights of the columns in the three series.

Consider the impact of a poorly designed chart. Explain why it is important to have a well-designed chart, and name at least four tips for creating a good chart.

To reposition the legend to the left-hand side of a chart, click the _________ button, point to Legend, click the right arrow icon, and click Left.

Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she needs to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. -Mya has decided she needs to move her chart so that it appears below her data source. Before she can move or resize her chart she must ______.

An _______ chart takes up less space than a chart sheet.

-Referring to the figure above, the chart title for the pie chart is ____.

-Referring to the figure above, in the column chart, the values along the left side ($200,000, $400,000, $600,000, etc.) are ____.

You can move a chart from one worksheet to another, or you can place the chart in its own chart sheet.

Interest is the amount of money being loaned.

The _______ covers the entire background of the chart, whereas the plot area includes only that portion of the chart in which the data markers, such as the columns in a column chart, have been placed or plotted.

The range of values, or ___________________, of an axis is based on the values in the data source.

Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she needs to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. -Since Mya is still reviewing her data, she wants to make sure that her chart reflects any changes she makes in her data source. She should ____.

Each data source is a collection of ____________________, which is a range of values plotted as a single unit on a chart.