Exam 4: Analyzing and Charting Financial Data

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

When combination charts have data series with vastly different values,you can create ____ charts.

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

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.

Simon has just started a job with the police department. His director has given him the last six months of test results from four local precincts. Simon has organized the results as four data series and needs to display the trends in a graphic format. -Simon wants to change the chart's border.To do this,he should select the CHART TOOLS ____ tab.

In the figure above,pv stands for the ____.

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

____provide descriptive text for the individual data markers,such as pie slices

Edward Tufte said that ____ ink is any part of the chart that does not convey information about the data.

In the figure above,fv and type are ____.

Category values are usually located in the ____ of the data source.

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

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 ________ contains the actual values that are plotted on the chart

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

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

-Referring to the figure above,if you were to create a Wine Production Chart pie chart using the information in B28:C34,the data source for that chart would be ____.

A $\underline { \text { color } }$ bar is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value._________________________

In cases where a label placed outside a pie might appear farther from its slice than is easily readable,a(n)____________________ might be added to connect the data to its corresponding slices.

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.