Linking Sheets with Slides in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to import data from another sheet named 'Data' in the same spreadsheet.

Google Sheets

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

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

A"https://docs.google.com/spreadsheets/d/abc123"

B""

CData

DSheet1

Attempts:

3 left

💡 Hint

Common Mistakes

Using the sheet name instead of an empty string for the first argument.

Putting the sheet name in the first argument instead of the range string.

When importing data from another sheet in the same spreadsheet, the spreadsheet URL is empty (""), and you specify the sheet name and range.

2fill in blank

medium

Complete the formula to link a cell from Google Sheets to Google Slides using the Sheets API placeholder format.

Google Sheets

[1]

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

A{{Sheet1!A1}}

B{{Sheet1.A1}}

C{{Sheet1_A1}}

D{{Sheet1-A1}}

Attempts:

3 left

💡 Hint

Common Mistakes

Using dot or underscore instead of exclamation mark.

Omitting the curly braces.

The correct placeholder format for linking Sheets data in Slides is {{SheetName!Cell}}, for example {{Sheet1!A1}}.

3fill in blank

hard

Fix the error in this formula that tries to link a range from Sheets to Slides but uses incorrect syntax.

Google Sheets

=[1]

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

AIMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123", "Sheet1!A1:A5")

BIMPORTRANGE("Sheet1!A1:A5")

CIMPORTRANGE(Sheet1!A1:A5)

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting the spreadsheet URL.

Not quoting the range string.

The IMPORTRANGE function requires two arguments: the spreadsheet URL and the range string in quotes.

4fill in blank

hard

Fill both blanks to create a formula that links a named range 'SalesData' from another spreadsheet.

Google Sheets

=IMPORTRANGE([1], [2])

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

A"https://docs.google.com/spreadsheets/d/xyz789"

B"SalesData"

C"SalesData!A1:D10"

D"Data!A1:D10"

Attempts:

3 left

💡 Hint

Common Mistakes

Using only the named range without cell range.

Not quoting the URL or range string.

The first argument is the URL of the other spreadsheet, and the second is the range string including the named range and its cell range.

5fill in blank

hard

Fill all three blanks to create a dynamic link in Slides that updates with the value in cell B2 of sheet 'Summary'.

Google Sheets

=[1]&"[2]"&[3]

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

AINDIRECT

B"Summary!B2"

CTEXT

DSummary!B2

Attempts:

3 left

💡 Hint

Common Mistakes

Not using INDIRECT to reference the cell dynamically.

Forgetting to format the value with TEXT.

Use INDIRECT to get the cell reference dynamically, the cell address as a string, and TEXT to format the value for Slides.