Excel Chapter 4 Test-BCIS Fall 2015

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements—chosen because they look "nice"—confuse and distract the reader.

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

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

You already created a line chart, but now decide that you want to change this chart to a pie chart. To do this, you click ____ from the Type group in the Chart Tools Design tab.

The _______ displays the data series in separate columns side-by-side so that you can compare the relative heights of the columns in the three series.

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

Edward Tufte said that ____ ink is any part of the chart that does not convey information about the data.

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

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