Excel Chapter 4 review

data series

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

only one chart

A chart sheet can contain ____.

Surface

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

only one value

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

either a or b

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

non-data

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

junk

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.

a true/false sparkline for help making decisions

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

watermarks

Generally, _____ are given a "washed-out" appearance and are placed behind text or charts on the sheet so that they do not obscure any of the other content on the sheet.

Chardonnay

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

Quick Analysis

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

Overlay the legend on a part of the chart that's empty.

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?

select the chart

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

exploded pie chart

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 needs to call attention to one category above all others. For this purpose, she should use a(n) ____.

filter

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. Sometimes Mya might want to see information on only specific slices. Rather than creating a new chart that includes only those selections, she can _____ an existing chart.

pie

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. Since it's important for Mya to keep percentages of her whole reviewer base in mind, she wants to represent data as parts of a whole. What chart type wo Since it's important for Mya to keep percentages of her whole reviewer base in mind, she wants to represent data as parts of a whole. What chart type would you suggest to Mya?uld you suggest to Mya?

optional arguments

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

total number of payment periods

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

present value of the loan

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

0 or 1

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

chart sheet

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

B28:C34

Referring to the figure above, if you were to create a Wine Production Chart pie chart using the information in B28:C34, the data source for that chart would be ____. (PIC3)

axis labels

Referring to the figure above, in the column chart, the values along the left side ($200,000, $400,000, $600,000, etc.) are ____. (pic 15)

Estimated Production

Referring to the figure above, the chart title for the pie chart is ____. (PIC17)

data label

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

legend

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

Radar chart

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.

major tick marks

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. It's difficult to read the exact scale on some of Simon's data. Adding ____ would make it easier to read.

Overlay the legend in areas without data

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 has finished his chart but needs to save some space. What's the most effective way for Andy to reduce space without losing important data?

FORMAT

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 wants to change the chart's border. To do this, he should select the CHART TOOLS ____ tab.

do nothing since charts in Excel remain linked to data sources

Since it's important for Mya to keep percentages of her whole reviewer base in mind, she wants to represent data as parts of a whole. What chart type would you suggest to Mya? Since Mya is still reviewing her data, she wants to make sure that her chart reflects any changes she makes in her data source. She should ____.

future value

The FV function stands for ____.

DESIGN and FORMAT

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

Move Chart

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

legend

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

pie

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

clustered column chart

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.

principal

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

data markers

The columns and pie slices in the charts above are ____. (PIC13)

scale

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

CHART TOOLS DESIGN

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

DESIGN

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.

exploded pie chart

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

Chart Elements

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.

select the chart and drag the corner sizing handle of the selection box

To resize an embedded chart, ____.

dual axis

When combination charts have data series with vastly different values, you can create ____ charts.

3

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

Select the chart, Click the Select Data button, Click the Add button, Select the range

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

Change Chart Type

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.

Format Data Labels

You can choose Center, Inside End, Outside End, or Best Fit for the data label positions in the in the ____ pane.

Interest

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

Data labels

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