Google Sheets Test Google Sheets Data Visualization with Charts 2

Question 1

Which chart type is best for showing the proportional breakdown of a single category as parts of a whole?

Accepted Answer

Pie chart

Answer

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?

Accepted Answer

Insert > Chart

Answer

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?

Accepted Answer

The Setup tab of the Chart editor

Answer

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?

Accepted Answer

Line chart

Answer

Line charts connect data points to reveal trends across time.

Question 5

What does a scatter chart primarily help you evaluate?

Accepted Answer

The relationship between two numeric variables

Answer

Scatter charts plot two numeric variables to reveal correlation.

Google Sheets Test Practice Test