Exam 4: Analyzing and Charting Financial Data

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Displays stock market data

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.

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

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

A chart sheet can contain ____.

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

Combination charts enable you to show $\underline { \text { three } }$ sets of data using the chart type that is best for each data set._________________________

You can move a chart from one worksheet to another,or you can place the chart in its own chart sheet.

When you create sparklines,clicking any cell in the $\underline { \text { data } }$ range selects all of the sparklines in the group._________________________

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares values from different categories.Areas under the lines contain a fill color

-Referring to the figure above,the rectangular area to the right of the pie chart is the ____.

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?

The ____ CHART TOOLS contextual tabs appear on the Ribbon when you select a chart.

To resize an embedded chart,____.

Since scientific data is often plotting two numeric values against one another,it is oftentimes best to represent this data type with a(n)____________________ chart.

-Referring to the figure above,the entry 31.5%,shown next to the largest pie slice,is a ____.

In the lower right corner,below C34,the _____ tool displays.

You can add ___________________ to identify smaller intervals between the major tick marks.

In the figure above,nper stands for the ____.

A column chart turned on its side is called a bar chart,with the length of the bar determined by the data value.