Google Sheets Test Google Sheets Data Visualization with Charts 2 — Questions and Answers
Question 1: Which chart type is best for showing the proportional breakdown of a single category as parts of a whole?
- Line chart
- Pie chart (Correct answer)
- Scatter chart
- Waterfall chart
Correct answer: Pie chart
A pie chart displays each value as a slice representing its share of the total.
Question 2: To insert a chart in Google Sheets, which menu do you use after selecting your data?
- Format > Chart
- Insert > Chart (Correct answer)
- Data > Chart
- Tools > Chart
Correct answer: Insert > Chart
Charts are added through the Insert menu's Chart option.
Question 3: Where do you change a chart's type after it has been created?
- The Setup tab of the Chart editor (Correct answer)
- The Customize tab of the Chart editor
- The Format menu
- The View menu
Correct answer: The Setup tab of the Chart editor
The Setup tab contains the Chart type dropdown for switching visualizations.
Question 4: Which chart is most appropriate for showing a trend over continuous time?
- Pie chart
- Line chart (Correct answer)
- Histogram
- Treemap
Correct answer: Line chart
Line charts connect data points to reveal trends across time.
Question 5: What does a scatter chart primarily help you evaluate?
- Parts of a whole
- The relationship between two numeric variables (Correct answer)
- Ranking of text categories
- Cumulative totals
Correct answer: The relationship between two numeric variables
Scatter charts plot two numeric variables to reveal correlation.
Question 6: After editing a chart, how do you save the changes in the Chart editor?
- Click a Save button
- Changes apply automatically as you edit (Correct answer)
- Press Ctrl+S
- Use File > Save chart
Correct answer: Changes apply automatically as you edit
Chart editor changes update the chart live without a separate save step.
Question 7: Which chart type stacks categories to compare both totals and component parts across groups?
- Stacked column chart (Correct answer)
- Simple line chart
- Pie chart
- Scatter chart
Correct answer: Stacked column chart
A stacked column chart shows segment contributions and overall totals per group.
Google Sheets Test Google Sheets Data Visualization with Charts 2
Which chart type is best for showing the proportional breakdown of a single category as parts of a whole?