Scatter plots in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to select data for the X-axis in a scatter plot.

Google Sheets

=Sheet1!A[1]:A10

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

A1

B2

C0

D11

Attempts:

3 left

💡 Hint

Common Mistakes

Starting the range at row 2 skips the first data point.

Using 0 or 11 as row numbers causes invalid references.

The X-axis data range starts from row 1 in column A, so the correct reference is A1:A10.

2fill in blank

medium

Complete the formula to select data for the Y-axis in a scatter plot.

Google Sheets

=Sheet1!B[1]:B10

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

A0

B2

C1

D11

Attempts:

3 left

💡 Hint

Common Mistakes

Starting at row 0 is invalid in Google Sheets.

Starting at row 2 skips the first data point.

The Y-axis data range starts from row 1 in column B, so the correct reference is B1:B10.

3fill in blank

hard

Fix the error in the chart data range formula for a scatter plot.

Google Sheets

=SHEET1!A[1]:B10

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

A1

B0

C11

D2

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 as a row number causes invalid reference.

Starting at row 11 excludes data points.

Sheet names are case-insensitive but usually written as 'Sheet1'. The range should start at row 1 to include all data.

4fill in blank

hard

Fill both blanks to create a scatter plot data range from columns A and B, rows 1 to 10.

Google Sheets

=Sheet1![1]1:[2]10

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

AA

BB

CC

DD

Attempts:

3 left

💡 Hint

Common Mistakes

Using columns C or D which do not contain the data.

Swapping the columns incorrectly.

The scatter plot uses columns A and B for X and Y data, so the range is A1:B10.

5fill in blank

hard

Fill all three blanks to create a formula that filters data points where X values in column A are greater than 5 for a scatter plot.

Google Sheets

=FILTER(Sheet1!A[1]:B10, Sheet1!A[2]:A10 [3] 5)

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

A1

B6

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' changes the filter condition.

Starting ranges at wrong rows excludes data.

The FILTER function selects rows from A1:B10 where values in A6:A10 are greater than 5. The blanks fill the start rows and the comparison operator.