Exam 4: Analyzing and Charting Financial Data

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

In pie charts,it's best to make the slice colors as similar as possible.___________ 

When you create sparklines,clicking any cell in the data range selects all of the sparklines in the group._________________________

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.

In the figure above,nper stands for the ____.

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

____ is the amount added to the prinicpal of a loan by the lender.

You can quickly change the appearance of the entire chart by selecting a different chart style in the Chart Design gallery._________________________

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

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

A chart sheet can contain ____.

Pie charts are most effective with ten or fewer slices._________________________

Which of the following shows the correct order of steps for adding a data series to a chart? 

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

To compare values from several categories with a sequential order,such as dates and times occurring at evenly spaced intervals,you would use a(n)____________________ chart.

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

In the figure above,pv stands for the ____.

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

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

By default,Excel inserts a chart as an embedded chart._________________________