Linking Sheets with Slides in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

This sheet lists products and their prices. We want to link this data to a Google Slides presentation so that the prices update automatically when changed here.

Cell	Value
A1	Product
B1	Price
A2	Notebook
B2	5
A3	Pen
B3	2
A4	Eraser
B4	1

Formula Trace

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123xyz456/edit", "Sheet1!A1:B4")

Step 1: IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123xyz456/edit", "Sheet1!A1:B4")

Cell Reference Map

  A        B
1 Product  Price
2 Notebook  5
3 Pen       2
4 Eraser    1

[IMPORTRANGE pulls all these cells from the source sheet]

The formula references the range A1:B4 in the source spreadsheet, importing all these cells into the current sheet.

Result

  A        B
1 Product  Price
2 Notebook  5
3 Pen       2
4 Eraser    1

[This is how the imported data appears in the current sheet]

The imported data from the source sheet appears exactly as in the original, showing product names and prices.

Sheet Trace Quiz - 3 Questions

What does the IMPORTRANGE formula do in this example?

A It links a Google Slide to this sheet.

B It calculates the sum of prices.

C It copies data from another Google Sheet into this one.

D It creates a chart from the data.

Key Result

IMPORTRANGE("spreadsheet_url", "sheet_name!range") imports data from another Google Sheet range.

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