Exam 4: Analyzing and Charting Financial Data

In the figure above,fv and type are ____.

Every chart contains elements that can be formatted,added to the chart,or removed from the chart.__________ 

In a line chart,the data markers are the points connected by the line._________________________

The ____ is the only one of the following charts to compare relative values from different categories to the whole.

To add and remove chart elements,you can use the Add Chart Element button in the Charts Layout group on the ____ tab.

Case 4-1 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.

A(n)____________________ chart shows patterns or relationships between two or more sets of values,much like an XY chart,except the size of the data marker is determined by a third value.

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. -Sometimes Mya might want to see information on only specific slices.Rather than creating a new chart that includes only those selections,she can _____ an existing chart.

To format an individual sparkline,select the sparkline you want to format,and then click the Ungroup button in the Group group on the SPARKLINE TOOLS ____ tab.

A pie slice is a data marker that represents ____ from a data series.

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

A color bar is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value._________________________

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

Interest is the amount added to the principal by the lender._________________________

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.