Google Sheets Test Google Sheets Data Visualization with Charts 3 — Questions and Answers
Question 1: How do you move a chart from the current sheet onto its own dedicated sheet tab?
- Use the three-dot menu > Move to own sheet (Correct answer)
- Drag it to the sheet tabs
- Use Data > Move chart
- Copy and paste into a new file
Correct answer: Use the three-dot menu > Move to own sheet
The chart's three-dot overflow menu includes a Move to own sheet option.
Question 2: Which chart is designed specifically to visualize a single value against a target range using colored bands?
- Gauge chart (Correct answer)
- Column chart
- Area chart
- Combo chart
Correct answer: Gauge chart
A gauge chart shows one value on a dial with min, mid, and max ranges.
Question 3: What is the purpose of a combo chart in Google Sheets?
- To combine multiple spreadsheets
- To show different series as different chart types on one chart (Correct answer)
- To merge cells visually
- To combine two tabs
Correct answer: To show different series as different chart types on one chart
A combo chart mixes types like columns and lines within one visualization.
Question 4: In the Chart editor Customize tab, which section lets you set the chart title text?
- Chart & axis titles (Correct answer)
- Series
- Legend
- Gridlines and ticks
Correct answer: Chart & axis titles
The Chart & axis titles section controls titles and their styling.
Question 5: Which chart best displays the distribution of a single numeric dataset into frequency buckets?
- Histogram (Correct answer)
- Pie chart
- Line chart
- Geo chart
Correct answer: Histogram
A histogram groups values into bins showing how often each range occurs.
Question 6: How can you delete a chart from a Google Sheet?
- Select it and press Delete, or use the three-dot menu > Delete chart (Correct answer)
- Only through the Edit menu
- Right-click the sheet tab
- It cannot be deleted once created
Correct answer: Select it and press Delete, or use the three-dot menu > Delete chart
Selecting the chart and pressing Delete or using its menu removes it.
Question 7: What does adding a trendline to a chart help you see?
- The general direction of the data (Correct answer)
- The exact cell references
- The file's sharing settings
- The number of rows
Correct answer: The general direction of the data
A trendline summarizes the overall direction or pattern of a data series.
Google Sheets Test Google Sheets Data Visualization with Charts 3
How do you move a chart from the current sheet onto its own dedicated sheet tab?