Google Sheets Test Google Sheets Data Visualization with Charts 4

Question 1

Which chart type is best suited to compare values across geographic regions using shaded areas?

Accepted Answer

Geo chart

Answer

A geo chart colors a map by value to compare regions.

Question 2

In a bubble chart, what does the size of each bubble typically represent?

Accepted Answer

A third numeric dimension

Answer

Bubble size encodes an additional value beyond the x and y positions.

Question 3

How do you make a Google Sheets chart update automatically when source data changes?

Accepted Answer

No action needed; charts are linked to their data range

Answer

Charts stay linked to their data range and refresh as values change.

Question 4

Which Customize option lets you display the actual value labels directly on chart bars or points?

Accepted Answer

Data labels

Answer

Enabling data labels prints each value on the chart element.

Question 5

What is the best chart for comparing multiple quantitative variables across a few items on a circular layout?

Accepted Answer

Radar chart

Answer

A radar chart plots several variables on spokes radiating from a center.

Google Sheets Test Practice Test