Geo charts and maps in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a Geo chart using the correct function.

Google Sheets

=GOOGLE[1]CHART(A1:B10, "Region")

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

AMAP

BGEO

CCHARTS

DGRAPH

Attempts:

3 left

💡 Hint

Common Mistakes

Using =GOOGLEMAPCHART which is not a valid function.

Using =GOOGLECHARTS which is incorrect spelling.

Using =GOOGLEGRAPH which does not exist.

The correct function to create a Geo chart in Google Sheets is =GOOGLEGEOCHART. The blank should be filled with "GEO".

2fill in blank

medium

Complete the code to specify the chart type as a Geo chart in the chart editor formula.

Google Sheets

=CHART(A1:B10, [1])

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

A"Geo"

B"Line"

C"Pie"

D"Bar"

Attempts:

3 left

💡 Hint

Common Mistakes

Using chart types like "Pie" or "Bar" which create different charts.

Forgetting the quotes around the chart type.

To create a Geo chart, the chart type must be set to "Geo" in quotes.

3fill in blank

hard

Fix the error in the formula to correctly create a Geo chart with region set to 'US'.

Google Sheets

=GOOGLEGE[1]CHART(A1:B10, "Region", "US")

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

AO

BE

CA

DI

Attempts:

3 left

💡 Hint

Common Mistakes

Misspelling the function name as GOOGLEGEECHART or GOOGLEGEACHART.

Leaving out the letter 'O' in GEO.

The correct function name is =GOOGLEGEOCHART. The missing letter is 'O'.

4fill in blank

hard

Fill both blanks to create a Geo chart for the world map.

Google Sheets

=GOOGLEGE[1]CHART(A1:B10, "Region", "[2]")

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

AO

BUS

CWorld

DE

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'E' instead of 'O' in the function name.

Setting region to 'US' when world map is needed.

The function name requires 'O' to complete 'GEO'. The region parameter should be "World" to show all countries.

5fill in blank

hard

Fill all three blanks to create a Geo chart with data filtered for countries with values greater than 50.

Google Sheets

=GOOGLE[1]CHART(FILTER(A1:B20, B1:B20 [2] [3]))

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

AGEO

B>

C50

D<

Attempts:

3 left

💡 Hint

Common Mistakes

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

Using the wrong function name without 'GEO'.

The function is GOOGLEGEOCHART. The filter condition uses '>' and the number 50 to select values greater than 50.