Linking Sheets with Docs in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to import data from another Google Sheet using its URL.

Google Sheets

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

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

A"Sheet1!A1:B10"

B"https://docs.google.com/spreadsheets/d/abc123xyz/edit"

CSheet1!A1:B10

DA1:B10

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put the URL in quotes

Using the range without quotes

Using only the sheet name without range

The first argument of IMPORTRANGE must be the URL of the source sheet as a text string.

2fill in blank

medium

Complete the formula to link a specific cell from another sheet using IMPORTRANGE.

Google Sheets

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123xyz/edit", [1])

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

A"C5"

BSheet2!C5

C"Sheet2!C5"

DC5

Attempts:

3 left

💡 Hint

Common Mistakes

Not including quotes around the range

Using only the cell without sheet name

Using incorrect range format

The range argument must be a text string with sheet name and cell, inside quotes.

3fill in blank

hard

Fix the error in the formula to correctly link data from another sheet.

Google Sheets

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123xyz/edit", [1])

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

A"A1:B5"

BSheet1!A1:B5

CA1:B5

D"Sheet1!A1:B5"

Attempts:

3 left

💡 Hint

Common Mistakes

Leaving the range unquoted

Omitting the sheet name

Using only cell range without sheet name

The range must be a string with sheet name and range inside quotes.

4fill in blank

hard

Fill both blanks to create a formula that imports data and sums the first column.

Google Sheets

=SUM(IMPORTRANGE([1], [2]))

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

A"https://docs.google.com/spreadsheets/d/abc123xyz/edit"

B"Sheet1!A1:A10"

CSheet1!A1:A10

DA1:A10

Attempts:

3 left

💡 Hint

Common Mistakes

Not quoting the URL or range

Using range without sheet name

Using incorrect range format

The first blank is the URL in quotes, the second blank is the range with sheet name and range in quotes.

5fill in blank

hard

Fill all three blanks to create a formula that imports data, filters rows where column B is greater than 50, and sums column A.

Google Sheets

=SUM(FILTER(IMPORTRANGE([1], [2]), IMPORTRANGE([1], [3]) > 50))

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

A"https://docs.google.com/spreadsheets/d/abc123xyz/edit"

B"Sheet1!A1:A100"

C"Sheet1!B1:B100"

D"Sheet1!C1:C100"

Attempts:

3 left

💡 Hint

Common Mistakes

Using different URLs in the same formula

Not quoting ranges

Mixing up column ranges

The first blank is the URL in quotes used twice. The second blank is the range for column A to sum. The third blank is the range for column B to filter values greater than 50.

Practice

1. What happens when you link a Google Sheets table to a Google Docs document?

easy

A. The table in Docs deletes the original data in Sheets.

B. The table in Docs stays the same even if Sheets data changes.

C. The table in Docs updates automatically when the Sheets data changes.

D. The table in Docs becomes editable only in Sheets.

Solution

1. Step 1: Understand linking behavior

   Linking means the Docs table is connected to Sheets data.

2. Step 2: Effect of data change in Sheets

   When Sheets data changes, the linked table in Docs can update to reflect those changes.

3. Final Answer:

   The table in Docs updates automatically when the Sheets data changes. -> Option C

4. Quick Check:

   Linking Sheets to Docs means automatic updates [OK]

Hint: Link means Docs table updates with Sheets data changes [OK]

Common Mistakes:

• Thinking Docs table never updates after linking
• Believing linking deletes Sheets data
• Confusing editing permissions between Docs and Sheets

2. Which is the correct way to insert a linked chart from Google Sheets into Google Docs?

easy

A. Type the chart data manually in Docs.

B. Copy the chart in Sheets, then paste it in Docs without linking option.

C. Download the chart as image and insert it in Docs.

D. Copy the chart in Sheets, then paste it in Docs and choose 'Link to spreadsheet'.

Solution

1. Step 1: Copy chart from Sheets

   Use the copy command on the chart in Google Sheets.

2. Step 2: Paste in Docs with linking

   Paste in Google Docs and select 'Link to spreadsheet' to keep it connected.

3. Final Answer:

   Copy the chart in Sheets, then paste it in Docs and choose 'Link to spreadsheet'. -> Option D

4. Quick Check:

   Paste with 'Link to spreadsheet' keeps chart updated [OK]

Hint: Always choose 'Link to spreadsheet' when pasting charts [OK]

Common Mistakes:

• Pasting without linking loses update ability
• Downloading image breaks live connection
• Typing data manually is inefficient and error-prone

3. You linked a table from Sheets to Docs. After updating data in Sheets, what must you do in Docs to see the changes?

medium

A. Close and reopen the Docs file.

B. Click the 'Update' button above the linked table in Docs.

C. Re-copy and paste the table from Sheets again.

D. Nothing, Docs updates automatically without action.

Solution

1. Step 1: Recognize update process

   Linked tables in Docs do not auto-refresh instantly.

2. Step 2: Use the 'Update' button

   Clicking 'Update' refreshes the linked table to show new data from Sheets.

3. Final Answer:

   Click the 'Update' button above the linked table in Docs. -> Option B

4. Quick Check:

   Manual update needed to refresh linked content [OK]

Hint: Click 'Update' in Docs to refresh linked Sheets data [OK]

Common Mistakes:

• Assuming Docs auto-refreshes instantly
• Thinking reopening Docs updates links
• Re-copying wastes time and breaks link

4. You pasted a table from Sheets into Docs but forgot to select 'Link to spreadsheet'. What is the problem?

medium

A. The table will not update when Sheets data changes.

B. The table will cause an error in Docs.

C. The table will delete data in Sheets.

D. The table will automatically link anyway.

Solution

1. Step 1: Understand linking importance

   Linking connects Docs table to Sheets data for updates.

2. Step 2: Effect of missing link

   Without linking, Docs table is static and won't reflect changes in Sheets.

3. Final Answer:

   The table will not update when Sheets data changes. -> Option A

4. Quick Check:

   Missing link means no automatic updates [OK]

Hint: Always choose 'Link to spreadsheet' to keep data synced [OK]

Common Mistakes:

• Expecting automatic updates without linking
• Thinking Docs table causes errors without link
• Believing data in Sheets is affected by Docs table

5. You want to create a report in Google Docs that always shows the latest sales data from multiple Sheets tabs. What is the best way to do this?

hard

A. Link tables or charts from each Sheets tab into Docs and update links regularly.

B. Copy all data manually from Sheets tabs and paste into Docs once.

C. Download Sheets as Excel and upload to Docs.

D. Type the sales data manually in Docs.

Solution

1. Step 1: Use linking for multiple tabs

   Linking tables or charts from each tab keeps Docs updated with latest data.

2. Step 2: Update links regularly

   After Sheets data changes, update links in Docs to refresh report content.

3. Final Answer:

   Link tables or charts from each Sheets tab into Docs and update links regularly. -> Option A

4. Quick Check:

   Linking multiple tabs keeps report current and efficient [OK]

Hint: Link all needed data and update links to keep report fresh [OK]

Common Mistakes:

• Copy-pasting once loses updates
• Downloading Excel breaks live connection
• Typing manually is slow and error-prone