Why charts make data visual in Google Sheets - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a chart from data in cells A1 to B5.

Google Sheets

InsertChart(range=[1])

Drag options to blanks, or click blank then click option'

AA1:B5

BA1:B10

CB1:C5

DA2:B6

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a range that includes empty cells

Selecting wrong columns

The range A1:B5 correctly selects the data for the chart.

2fill in blank

medium

Complete the formula to calculate the total sales in column B.

Google Sheets

=SUM([1])

Drag options to blanks, or click blank then click option'

AB1:B5

BB2:B6

CA2:B5

DA1:A5

Attempts:

3 left

💡 Hint

Common Mistakes

Summing the wrong column

Including header row in sum

The formula sums the sales values in column B from rows 2 to 6, excluding the header.

3fill in blank

hard

Fix the error in the formula to calculate average sales in column B.

Google Sheets

=AVERAGE([1])

Drag options to blanks, or click blank then click option'

AB2:B6

BA1:A5

CB1:B5

DA2:A6

Attempts:

3 left

💡 Hint

Common Mistakes

Including header row in average

Selecting wrong column

The correct range B2:B6 excludes the header and includes the sales data.

4fill in blank

hard

Fill both blanks to create a bar chart with title 'Sales Data'.

Google Sheets

Chart.new().setChartType([1]).setOption('title', [2]).build()

Drag options to blanks, or click blank then click option'

A'BAR'

B'Sales Data'

C'LINE'

D'Revenue'

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong chart type

Incorrect title string

The chart type should be 'BAR' and the title set to 'Sales Data'.

5fill in blank

hard

Fill all three blanks to create a pie chart from range A1:B5 with legend on the right.

Google Sheets

Chart.new().setChartType([1]).addRange([2]).setOption('legend', { position: [3] }).build()

Drag options to blanks, or click blank then click option'

A'PIE'

BA1:B5

C'right'

D'top'

Attempts:

3 left

💡 Hint

Common Mistakes

Wrong chart type

Incorrect data range

Legend position not set correctly

The chart type is 'PIE', data range is 'A1:B5', and legend position is 'right'.