Exam 9: Analyzing and Charting Financial Data

You already created a line chart, but now decide that you want to change this chart to a pie chart. To do this, you click ____ from the Type group in the Chart Tools Design tab.

Excel charts are either placed in their own chart sheets or embedded in a worksheet.

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

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares relative values of different categories to the whole. A value is indicated by the area of a(n) ____

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) ____.

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

In the figure above, fv and type are ____.

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

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

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares values from different categories. A value is indicated by the length of the ____

A chart that combines two or more chart types into a single graph is called a(n) ____________________ 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's boss wants him to compare the values in this chart with several different data sets. Simon should prepare a(n) ____ for his boss.

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 asked for your advice. A colleague told her to remove the legend from her pie chart because it takes up too much space. What would be a better piece of advice to give Mya?

A ________ contains the actual values that are plotted on the chart

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Often used to show trends and changes over time

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

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. -It's difficult to read the exact scale on some of Simon's data. Adding ____ would make it easier to read.

-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 color bar is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value. _________________________

The cell with the largest value contains a data marker that extends across the entire width of the cell, and the lengths of the other bars in the selected range are determined relative to that bar. _________________________