Exam 4: Analyzing and Charting Financial Data

Case 4-2 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 needs to call attention to one category above all others.For this purpose,she should use a(n)____.

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

The amount of money being loaned is known as the ____.

The goal of a ______ is to convey the maximum amount of information within a very small space.

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

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.

A ____________ displays data values as columns with the height of each column based on the data value.

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.

Combination charts enable you to show three sets of data using the chart type that is best for each data set._________________________

Line charts are best suited for representing data that follows some nonsequential order.___________ 

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

The PMT function calculates the payment required in each period to pay back the loan.___________ 

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

Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements-chosen because they look "nice"-confuse and distract the reader.

To move one slice of a pie chart away from the pie creates a(n)____.

The ____ identifies which data markers are associated with each data series.

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

You can choose Center,Inside End,Outside End,or Best Fit for the data label positions in the in the ____ pane.

You can add ___________________ to identify smaller intervals between the major tick marks.