Google Sheets Test Google Sheets Data Visualization with Charts 5

Question 1

What must you usually check so a chart reads series from rows instead of columns?

Accepted Answer

The 'Switch rows / columns' option in the Setup tab

Answer

Switch rows / columns reorients how data maps to series and axes.

Question 2

In the Chart editor, what does the 'Use row 1 as headers' option do?

Accepted Answer

Treats the first row as labels rather than data

Answer

It designates the first row as category or series names, not plotted values.

Question 3

Which chart type is best for emphasizing the magnitude of change with a filled region under a line?

Accepted Answer

Area chart

Answer

An area chart fills the space under the line to stress volume over time.

Question 4

How do you move the legend to the bottom of a chart?

Accepted Answer

Set position to Bottom under the Legend section in Customize

Answer

The Legend section in Customize includes a position dropdown with Bottom.

Question 5

What happens to a chart if you delete the rows containing its source data?

Accepted Answer

The chart loses that data and may show empty or reduced results

Answer

Removing source rows removes the underlying values the chart plots.

Google Sheets Test Practice Test