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.

Practice

1. What is the main benefit of linking a Google Sheet chart to a Google Slides presentation?

easy

A. The chart data is deleted from the Sheet after linking

B. The chart becomes editable directly in Slides

C. The chart is converted to an image and cannot be updated

D. The chart updates automatically when the Sheet data changes

Solution

1. Step 1: Understand linking purpose and update behavior

   Linking keeps the chart connected to the Sheet data so it can update. When data changes in Sheets, the linked chart in Slides can refresh to show new data.

2. Final Answer:

   The chart updates automatically when the Sheet data changes -> Option D

3. Quick Check:

   Linking means auto-update [OK]

Hint: Link means updates flow from Sheets to Slides [OK]

Common Mistakes:

• Thinking chart edits happen in Slides
• Assuming chart becomes static image
• Believing data deletes after linking

2. Which menu option in Google Slides allows you to insert a linked chart from Google Sheets?

easy

A. Insert > Chart > From Sheets

B. File > Import > Chart

C. Edit > Paste Special > Linked Chart

D. View > Linked Objects > Add Chart

Solution

1. Step 1: Locate chart insertion path

   In Slides, charts from Sheets are inserted via the Insert menu. The path is Insert > Chart > From Sheets to link a chart.

2. Final Answer:

   Insert > Chart > From Sheets -> Option A

3. Quick Check:

   Insert menu has chart options [OK]

Hint: Use Insert > Chart > From Sheets to link charts [OK]

Common Mistakes:

• Looking under File or Edit menus
• Trying to paste charts without linking
• Searching in View menu for charts

3. You linked a chart from Sheets to Slides. After updating the data in Sheets, what happens when you open the Slides file?

medium

A. The chart remains unchanged and cannot be updated

B. The chart updates automatically without any prompt

C. Slides shows a prompt to update the linked chart

D. The chart is removed from Slides

Solution

1. Step 1: Understand update behavior on open

   Slides detects changes in linked Sheets data and prompts to update. User must click the prompt to refresh the chart with new data.

2. Final Answer:

   Slides shows a prompt to update the linked chart -> Option C

3. Quick Check:

   Update prompt appears on open [OK]

Hint: Look for update prompt when opening Slides [OK]

Common Mistakes:

• Expecting automatic update without prompt
• Thinking chart updates without user action
• Assuming chart disappears after data change

4. You inserted a linked table from Sheets into Slides, but the 'Update' button is missing when data changes. What is the likely cause?

medium

A. The Sheets file is not shared with Slides

B. The table was pasted as an image, not linked

C. Slides does not support linked tables

D. The Sheets data is empty

Solution

1. Step 1: Check insertion and update button

   If pasted as an image, no link exists to update data. Only linked objects show the update button in Slides.

2. Final Answer:

   The table was pasted as an image, not linked -> Option B

3. Quick Check:

   Update button missing means no link [OK]

Hint: Ensure you insert linked, not pasted images [OK]

Common Mistakes:

• Assuming sharing affects update button
• Believing Slides can't link tables
• Thinking empty data removes update button

5. You want to create a presentation that always shows the latest sales data from your Google Sheet. Which steps correctly link and update the data in Slides?

hard

A. Insert chart from Sheets, then click 'Update' in Slides when data changes

B. Copy chart as image from Sheets and paste in Slides, then replace manually

C. Export chart as PDF and insert in Slides, update by re-importing

D. Use Slides' built-in chart tool and manually enter data

Solution

1. Step 1: Insert and update linked chart

   Use Insert > Chart > From Sheets to link the chart for live updates. When Sheet data changes, click 'Update' in Slides to refresh the chart.

2. Final Answer:

   Insert chart from Sheets, then click 'Update' in Slides when data changes -> Option A

3. Quick Check:

   Link + Update = latest data shown [OK]

Hint: Link charts and use update button for fresh data [OK]

Common Mistakes:

• Pasting static images instead of linking
• Using export/import instead of linking
• Manually entering data in Slides charts