Exam 4: Analyzing and Charting Financial Data

Pie charts are most effective with $\underline { \text { ten } }$ or fewer slices._________________________

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

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

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

Which of the following represents the pointer when it is over the chart area?

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

______ are horizontal and vertical lines that help you compare data and category values.

The FV function stands for ____.

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.

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

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

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

A chart that combines two or more chart types into a single graph is called a(n)____________________ chart.

Excel supports all of the following types of sparklines EXCEPT ____.

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

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

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

The ____ dialog box provides options for moving charts between worksheets and chart sheets.

When selecting a chart,it's important to choose the right type of chart to represent your data. If choosing between a pie chart and a line chart,what factors would you evaluate in choosing which chart to use? How would each chart differ in representing your data?

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