Chart interactivity in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a chart that updates when the data changes.

Google Sheets

Insert a chart by selecting the data range and then clicking on [1].

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

AFormat > Chart

BInsert > Chart

CData > Chart

DTools > Chart

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing the wrong menu like Format or Data.

Trying to create a chart from Tools menu.

To create a chart in Google Sheets, you use the Insert menu and select Chart.

2fill in blank

medium

Complete the code to link the chart to the data range A1:B5.

Google Sheets

Select the chart, then in the Chart editor, set the Data range to [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

Selecting a range that is too big or too small.

Choosing the wrong columns or rows.

The data range must match the cells containing your data. Here, it's A1:B5.

3fill in blank

hard

Fix the error in the formula that dynamically updates the chart range when rows are added.

Google Sheets

Use the formula =[1](A1:B) to select all rows in columns A and B.

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

ASORT

BFILTER

CIMPORTRANGE

DARRAYFORMULA

Attempts:

3 left

💡 Hint

Common Mistakes

Using FILTER which requires criteria.

Using IMPORTRANGE which imports from another sheet.

ARRAYFORMULA allows the formula to cover all rows dynamically in the range A1:B.

4fill in blank

hard

Fill both blanks to create a dropdown filter that updates the chart based on the selected category.

Google Sheets

Create a dropdown in cell D1 using Data > Data validation with criteria [1], then use =FILTER(A2:B10, A2:A10 [2] D1) to filter data.

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

A"List of items"

B"Number"

C=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Number' as dropdown criteria for categories.

Using '>' instead of '=' in the filter condition.

The dropdown uses a list of items, and the FILTER formula uses '=' to match the selected category.

5fill in blank

hard

Fill all three blanks to create a dynamic chart title that shows the selected category from cell D1.

Google Sheets

Set the chart title formula to ="Sales for " & [1](D1) & " in " & [2](D2) & "."

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

AUPPER

BLOWER

CTEXT

DCONCATENATE

Attempts:

3 left

💡 Hint

Common Mistakes

Using LOWER instead of UPPER for emphasis.

Not formatting the date properly.

Not joining strings correctly.

UPPER converts the category to uppercase, TEXT formats the date in D2, and CONCATENATE joins the strings.