Quiz › Charts › Pick the right chart

Pick the right chart: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

You have sales for 12 months and want to show the trend. Which chart?
- A. Line chart
- B. Pie chart
- C. Doughnut chart
Show the answer
A — Line chart. A line chart shows how a number goes up and down over time.
You want to show how a budget is shared by 4 departments. Which chart?
- A. Pie chart
- B. Line chart
- C. Scatter chart
Show the answer
A — Pie chart. A pie chart shows how one total is shared.
You want to compare the sales of 10 cities. Which chart?
- A. Pie chart
- B. Scatter chart
- C. Column chart
Show the answer
C — Column chart. Bars are easy to compare. Ten slices of a pie are hard to read.
You want to see if height and weight are linked. Which chart?
- A. Pie chart
- B. Column chart
- C. Scatter chart
Show the answer
C — Scatter chart. A scatter chart plots one number against another.
You select A1:B6 and press Alt + F1. What happens?
- A. The file is saved
- B. A chart appears
- C. The data is sorted
- D. A new sheet opens
Show the answer
B — A chart appears. Alt + F1 makes a chart from the selected data, on the same sheet.