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