Excel Quiz 4

Each slice in a pie chart represents a single value from a data series. ____________

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

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

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

Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent. ___________

Line charts are best suited for representing data that follows some nonsequential order. ___________

Interest is the amount of money being loaned. ___________

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

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

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

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

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

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

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

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

Combination charts enable you to show three sets of data using the chart type that is best for each data set. _________________________

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

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

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

Placing a chart in a ____ displays only the chart and no worksheet cells.

To resize an embedded chart, ____.

To reposition the legend to the left-hand side of a chart, click the _________ button, point to Legend, click the right arrow icon, and click Left.

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

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

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

A chart that compares three set of values in a three-dimensional chart is _____.

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

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

The FV function stands for ____.

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

PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, nper stands for the ____.

PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, pv stands for the ____.

PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, fv and type are ____.

PMT(rate, nper, pv [, fv=0] [, type=0]) The possible values for the type argument in the function above are.

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.

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.

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.

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

The goal of a ______ is to convey the maximum amount of information within a very small space.