CGS Excel Chapter 3
What type of chart is the least appropriate for depicting yearly rainfall totals for five cities for four
years?
(a. Pie chart)
(b. Line chart)
%
(c. Column chart)
(d. Bar chart) - ✔✔a. Pie chart
Look at the stacked bar chart in figure 3.35. Which of the following is a category on the category axis?
(a Thousands)
(b. Job Titles)
0
(c. CIS Managers)
(d. 700) - ✔✔c. CIS Managers
Which of the following is not a type of sparkline?
(a. Line)
0
(b. Bar)
(c. Column)
(d. Win-Loss) - ✔✔b. Bar
1
If you want to show exact values for a data series in a bar chart, which chart element should you
display? - ✔✔Data labels
The value axis currently shows increments such as 50,000 and 100,000. What option would you
select to display the values in increments of 50 and 100? - ✔✔Show axis in Thousands
You want to create a single chart that shows each of the five divisions proportion of yearly sales for
each year for five years. Which type of chart can accommodate your needs? - ✔✔100% stacked
column chart
Currently, a column chart shows values on the value axis, years on the category axis, and state
names in the legend. What should you do if you want to organize the data with the states on the
category axis and the years shown in the legend? - ✔✔Click Switch Row/Column in the Data group
on the Design tab
What do you click to remove a data series form a chart so that you can focus on other data series? -
✔✔Chart filters
Which of the following does not display automatically when you create a clustered column chart?
What type of chart is the least appropriate for depicting yearly rainfall totals for five cities for four
years?
(a. Pie chart)
(b. Line chart)
%
(c. Column chart)
(d. Bar chart) - ✔✔a. Pie chart
Look at the stacked bar chart in figure 3.35. Which of the following is a category on the category axis?
(a Thousands)
(b. Job Titles)
0
(c. CIS Managers)
(d. 700) - ✔✔c. CIS Managers
Which of the following is not a type of sparkline?
(a. Line)
0
(b. Bar)
(c. Column)
(d. Win-Loss) - ✔✔b. Bar
1
If you want to show exact values for a data series in a bar chart, which chart element should you
display? - ✔✔Data labels
The value axis currently shows increments such as 50,000 and 100,000. What option would you
select to display the values in increments of 50 and 100? - ✔✔Show axis in Thousands
You want to create a single chart that shows each of the five divisions proportion of yearly sales for
each year for five years. Which type of chart can accommodate your needs? - ✔✔100% stacked
column chart
Currently, a column chart shows values on the value axis, years on the category axis, and state
names in the legend. What should you do if you want to organize the data with the states on the
category axis and the years shown in the legend? - ✔✔Click Switch Row/Column in the Data group
on the Design tab
What do you click to remove a data series form a chart so that you can focus on other data series? -
✔✔Chart filters
Which of the following does not display automatically when you create a clustered column chart?
