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.