Chapter 16: Graphs and charts Introduction

According to the introduction, which type of chart is most appropriate for comparing parts of a whole?

• Line graph

• Bar chart

• Pie chart

• Scatter plot

When creating a horizontal bar chart in Excel, which chart tool should you select?

• Column chart

• Bar chart

• Line chart

• Pie chart

In the context described, a bar chart traditionally has vertical bars, but in Excel this is called a:

• Line graph

• Column chart

• Pie chart

• Stacked chart

You want to display the number of items sold by five different people in the same month. Which chart best fits this task?

• Pie chart

• Bar chart

• Line graph

• Area chart

Line graphs are best used to:

• Compare percentages at a single point in time

• Show differences among categories

• Plot trends between two variables over time

• Display parts of a whole

When creating a horizontal bar chart (with the bars going across the page) in Excel, which chart type should you select?

• Column chart

• Bar chart

• Pie chart

• Line graph

You are plotting the temperature of water while it is heated against time and need to read the temperature at any point even if it was not measured. Which chart type should you use?

• Bar chart

• Pie chart

• Line graph

• Scatter chart

To create a chart from non-contiguous data in a spreadsheet (e.g., columns B and F), what should you do while making your selections?

• Hold down the Shift key

• Hold down the Ctrl key

• Sort the data first

• Convert to a pie chart

When starting to create a chart from a spreadsheet, what is the first action you should take with the data?

• Choose the chart colors

• Highlight the data you wish to use

• Insert a new worksheet

• Sort the data alphabetically

Which statement best describes contiguous data selection for chart creation?

• Selecting data from columns that are next to each other, such as columns B and C

• Selecting any cells that match a condition anywhere in the sheet

• Selecting data from non-adjacent columns like B and F

• Selecting only the header row of the dataset