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.
  • format
  • filter
  • pie
  • scale
A chart sheet can contain ____.
  • future value
  • only one value
  • optional arguments
  • only one 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.
  • chart elements
  • DESIGN and FORMAT
  • estimated production
  • cluster column chart
Edward Tufte said that ____ ink is any part of the chart that does not convey information about the data.
  • junk
  • non data
  • format data labels
  • format
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?
  • pie
  • junk
  • ...
  • filter
____ is the amount added to the prinicpal of a loan by the lender.
  • interest
  • Data series
  • only one value
  • 0 or 1
Category values are usually located in the ____ of the data source.
  • data markers
  • only one value
  • either a or b
  • chart sheet
It's difficult to read the exact scale on some of Simon's data. Adding ____ would make it easier to read.
  • major tick marks
  • DESIGN and FORMAT
  • format data labels
  • move chart
Which of the following represents the pointer when it is over the chart area?
  • legend
  • select the chart, click the select data button, click the add button, select the range
  • ...
  • interest
A chart that compares three set of values in a three-dimensional chart is _____.
  • non data
  • surface
  • scale
  • format
Referring to the figure above, the entry 31.5%, shown next to the largest pie slice, is a ____.
  • data series
  • data markers
  • legend
  • data label
The ____ identifies which data markers are associated with each data series.
  • legend
  • DESIGN and FORMAT
  • move chart
  • 0 or 1
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.
  • axis labels
  • watermarks
  • radar chart
  • move chart
In the figure above, the biggest slice is the cases of _______.
  • quick analysis
  • optional arguments
  • chardonnay
  • present value of the loan
The columns and pie slices in the charts above are ____.
  • Data series
  • data markers
  • quick analysis
  • data labels
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.
  • watermarks
  • data label
  • chart elements
  • data markers
Mya needs to call attention to one category above all others. For this purpose, she should use a(n) ____.
  • CHART TOOLS DESIGN
  • exploded pie chart
  • estimated production
  • chart elements
The range of values or _______, of an axis is based on the values in the data source.
  • legend
  • principal
  • 0 or 1
  • scale
To resize an embedded chart, ____.
  • overlay the legend on a part of the chart that's empty
  • exploded pie chart
  • select the chart and drag the corner sizing handle of the selection box
  • select the chart, click the select data button, click the add button, select the range
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.
  • cluster column chart
  • chart elements
  • change chart type
  • CHART TOOLS DESIGN
A pie slice is a data marker that represents ____ from a data series.
  • quick analysis
  • chardonnay
  • only one value
  • future value
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.
  • legend
  • data label
  • chart sheet
  • chart elements
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.
  • legend
  • filter
  • chart elements
  • design
When combination charts have data series with vastly different values, you can create ____ charts.
  • quick analysis
  • dual axis
  • legend
  • axis labels
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
  • chart elements
  • overlay the legend on a part of the chart that's empty
  • select the chart
The amount of money being loaned is known as the ____.
  • move chart
  • quick analysis
  • future value
  • principal
You can choose Center, Inside End, Outside End, or Best Fit for the data label positions in the in the ____ pane.
  • major tick marks
  • format data labels
  • DESIGN and FORMAT
  • CHART TOOLS DESIGN
The FV function stands for ____.
  • only one value
  • only one chart
  • future value
  • optional arguments
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 ____.
  • chart elements
  • pie
  • do nothing since charts in excel remain linked to data sources
  • design
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 ____.
  • B29:C34
  • B28:C34
  • B129:C34
  • B29:C170
Placing a chart in a ____ displays only the chart and no worksheet cells.
  • data series
  • radar chart
  • chart elements
  • chart sheet
The ____ dialog box provides options for moving charts between worksheets and chart sheets.
  • data labels
  • design and format
  • move chart
  • chart elements
In the figure above, nper stands for the ____.
  • present value of the loan
  • total number of payment periods
  • data markers
  • chardonnay
0:0:1



Answered

Not Answered

Not Visited
Correct : 0
Incorrect : 0