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)

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) (c. CIS Managers) (d. 700)

Which of the following is not a type of sparkline? (a. Line) (b. Bar) (c. Column) (d. Win-Loss)

If you want to show exact values for a data series in a bar chart, which chart element should you display?

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?

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?

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?

What do you click to remove a data series form a chart so that you can focus on other data series?

Which of the following does not display automatically when you create a clustered column chart? (a. Data labels) (b. Chart title placeholder) (c. Grid lines) (d. Legend)

After you create a line type sparkline, what option should you select to display dots for each data point?