Excel Chapter 3 Test review

The image shows a selection that is ideal for a pie chart.

• True

• False

What does this icon do?

• Makes the chart 3D

• Charges the chart type

• Recommends charts that work best with your data

• Moves the chart

Which chart type or types would work well for the selected data in the chart below?

• Bar chart

• Pie chart

• line chart

• column chart

What chart type does this ribbon button represent?

• Pie chart

• Bar/Column chart

• Line chart

What chart type does this ribbon button represent?

• line chart

• Pie chart

• Column chart

• Bar chart

What chart type does this ribbon button represent?

• Line chart

• Column/Bar chart

• Pie chart

To select a data series on a chart, double-click any of the data points or blocks. To select only one data point from a series, single-click the data point or block you wish to select.

• True

• False

Kendall has created a line chart using a group of data. Once he sees how the line chart looks, he changes his mind and decides to use a column chart instead. To do this, he must first delete his line chart and insert a new column chart.

• True

• False

Janice has built a great-looking chart and would like to add a background to make it really strong. Which of the following is NOT an option for her chart background?

• video

• image

• gradient

• color

• texture

Mark has created a clustered column chart for his data group. However, the chart data looks very similar from column to column, since each amount shown is close to the number 15,000. What is most likely to be causing Marcus’ problem, and what is the best way he can fix it without adjusting his data?

• There is no way to fix it; he’ll have to adjust his data.

• His chart is too small; he can resize it to be bigger.

• His data points are all close to 15,000; he can adjust the minimum and maximum value displayed on the axis.

• His data points are all close to 15,000; he can increase the zoom on his spreadsheet to show more detail.