Linking Sheets with Docs in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to import data from another Google Sheet using its URL.

Google Sheets

=IMPORTRANGE([1], "Sheet1!A1:B10")

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

A"Sheet1!A1:B10"

B"https://docs.google.com/spreadsheets/d/abc123xyz/edit"

CSheet1!A1:B10

DA1:B10

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put the URL in quotes

Using the range without quotes

Using only the sheet name without range

The first argument of IMPORTRANGE must be the URL of the source sheet as a text string.

2fill in blank

medium

Complete the formula to link a specific cell from another sheet using IMPORTRANGE.

Google Sheets

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123xyz/edit", [1])

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

A"C5"

BSheet2!C5

C"Sheet2!C5"

DC5

Attempts:

3 left

💡 Hint

Common Mistakes

Not including quotes around the range

Using only the cell without sheet name

Using incorrect range format

The range argument must be a text string with sheet name and cell, inside quotes.

3fill in blank

hard

Fix the error in the formula to correctly link data from another sheet.

Google Sheets

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123xyz/edit", [1])

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

A"A1:B5"

BSheet1!A1:B5

CA1:B5

D"Sheet1!A1:B5"

Attempts:

3 left

💡 Hint

Common Mistakes

Leaving the range unquoted

Omitting the sheet name

Using only cell range without sheet name

The range must be a string with sheet name and range inside quotes.

4fill in blank

hard

Fill both blanks to create a formula that imports data and sums the first column.

Google Sheets

=SUM(IMPORTRANGE([1], [2]))

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

A"https://docs.google.com/spreadsheets/d/abc123xyz/edit"

B"Sheet1!A1:A10"

CSheet1!A1:A10

DA1:A10

Attempts:

3 left

💡 Hint

Common Mistakes

Not quoting the URL or range

Using range without sheet name

Using incorrect range format

The first blank is the URL in quotes, the second blank is the range with sheet name and range in quotes.

5fill in blank

hard

Fill all three blanks to create a formula that imports data, filters rows where column B is greater than 50, and sums column A.

Google Sheets

=SUM(FILTER(IMPORTRANGE([1], [2]), IMPORTRANGE([1], [3]) > 50))

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

A"https://docs.google.com/spreadsheets/d/abc123xyz/edit"

B"Sheet1!A1:A100"

C"Sheet1!B1:B100"

D"Sheet1!C1:C100"

Attempts:

3 left

💡 Hint

Common Mistakes

Using different URLs in the same formula

Not quoting ranges

Mixing up column ranges

The first blank is the URL in quotes used twice. The second blank is the range for column A to sum. The third blank is the range for column B to filter values greater than 50.