Q.1.
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.
Q.2.
A chart sheet can contain ____.
Q.3.
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.
Q.4.
Edward Tufte said that ____ ink is any part of the chart that does not convey information about the data.
Q.5.
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?
Q.6.
____ is the amount added to the prinicpal of a loan by the lender.
Q.7.
Category values are usually located in the ____ of the data source.
Q.8.
It's difficult to read the exact scale on some of Simon's data. Adding ____ would make it easier to read.
Q.9.
Which of the following represents the pointer when it is over the chart area?
Q.10.
A chart that compares three set of values in a three-dimensional chart is _____.
Q.11.
Referring to the figure above, the entry 31.5%, shown next to the largest pie slice, is a ____.
Q.12.
The ____ identifies which data markers are associated with each data series.
Q.13.
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.
Q.14.
In the figure above, the biggest slice is the cases of _______.
Q.15.
The columns and pie slices in the charts above are ____.
Q.16.
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.
Q.17.
Mya needs to call attention to one category above all others. For this purpose, she should use a(n) ____.
Q.18.
The range of values or _______, of an axis is based on the values in the data source.
Q.19.
To resize an embedded chart, ____.
Q.20.
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.
Q.21.
A pie slice is a data marker that represents ____ from a data series.
Q.22.
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.
Q.23.
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.
Q.24.
When combination charts have data series with vastly different values, you can create ____ charts.
Q.25.
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 ______.
Q.26.
The amount of money being loaned is known as the ____.
Q.27.
You can choose Center, Inside End, Outside End, or Best Fit for the data label positions in the in the ____ pane.
Q.28.
The FV function stands for ____.
Q.29.
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 ____.
Q.30.
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 ____.
Q.31.
Placing a chart in a ____ displays only the chart and no worksheet cells.
Q.32.
The ____ dialog box provides options for moving charts between worksheets and chart sheets.
Q.33.
In the figure above, nper stands for the ____.