Creating and opening spreadsheets in Google Sheets - Formula Evaluation Walkthrough

Sample Data

A simple spreadsheet with names and ages.

Cell	Value
A1	Name
B1	Age
A2	Alice
B2	30
A3	Bob
B3	25

Formula Trace

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

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

Step 2: Data fetched: [["Name", "Age"], ["Alice", 30], ["Bob", 25]]

Cell Reference Map

  A       B
1 Name    Age
2 Alice   30
3 Bob     25

Formula references external spreadsheet range Sheet1!A1:B3

The formula imports the range A1:B3 from another spreadsheet, which contains names and ages.

Result

  A       B
1 Name    Age
2 Alice   30
3 Bob     25

The imported data appears in the current sheet exactly as it is in the source spreadsheet.

Sheet Trace Quiz - 3 Questions

What does the IMPORTRANGE formula do?

A It deletes data from the sheet.

B It imports data from another Google Sheets file.

C It creates a new spreadsheet.

D It sorts data in the current sheet.

Key Result

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