Linking Sheets with Slides in Google Sheets - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

What is the output of this formula linking Sheets to Slides?

You have a Google Sheets cell with the formula =IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123", "Sheet1!A1"). What value will appear in the cell if the linked cell A1 in the source sheet contains the text "Sales Q1"?

Google Sheets

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

A "Sales Q1"

B The formula text itself: =IMPORTRANGE(...)

C An error saying #REF! because permission is not granted

D "Sheet1!A1"

💡 Hint

IMPORTRANGE pulls data from another sheet if permission is granted.

IMPORTRANGE fetches the exact value from the specified cell in the linked spreadsheet. If permission is granted, the cell shows the value, here "Sales Q1".

❓ Function Choice

intermediate

Which function correctly updates a Google Slides text box with data from Sheets?

You want to automatically update a text box in Google Slides with the value from cell B2 in your Google Sheet. Which Apps Script function is best to get the cell value for this purpose?

A SpreadsheetApp.getActiveSpreadsheet().getRange('B2').getValue()

B SlidesApp.getActivePresentation().getRange('B2').getValue()

C DocumentApp.getActiveDocument().getRange('B2').getValue()

D SpreadsheetApp.openById('sheetId').getSheetByName('Sheet1').getRange('B2').getValue()

💡 Hint

You need to open the sheet by ID and get the value from the correct sheet and cell.

Option D correctly opens the sheet by ID, selects the sheet by name, and gets the value from cell B2. Option D may fail if the script is not bound to the sheet. Options B and C are for Slides and Docs, which don't have getRange.

❓ data_analysis

advanced

How many slides will be updated if you link a Sheets range to Slides?

You link a range of 3 rows and 2 columns from Google Sheets to Google Slides as a linked table. If you update the sheet, how many slides will reflect the changes?

A 6 slides, one for each cell in the range

B 1 slide, because the linked table is inserted as a single object

C 3 slides, one per row in the range

D 2 slides, one per column in the range

💡 Hint

Linked tables appear as one object in Slides.

When you link a range from Sheets to Slides as a table, it appears as a single object on one slide. Updating the sheet updates that one linked table on that slide.

🎯 Scenario

advanced

You want to automate updating multiple Slides text boxes from Sheets data. What is the best approach?

You have a Google Sheet with sales data and a Google Slides presentation with multiple text boxes to update. Which approach best automates updating all text boxes with the latest data?

A Manually copy and paste values from Sheets to Slides each time

B Use IMPORTRANGE in Slides to pull data directly from Sheets

C Use Apps Script to read values from Sheets and replace text in Slides placeholders

D Export Sheets as PDF and insert PDF pages into Slides

💡 Hint

Automation requires scripting to update multiple text boxes dynamically.

Apps Script can read data from Sheets and programmatically replace text in Slides placeholders, automating updates. IMPORTRANGE works only in Sheets, not Slides. Manual copy-paste is not automated. PDF insertion is static.

📊 Formula Result

expert

What error appears if you try to link a protected Sheets range to Slides without access?

You try to link a protected range from a Google Sheet to a Google Slides presentation, but you do not have permission to view that range. What error will you see in the Slides linked object?

A #REF! error indicating permission denied

B The linked object shows the last cached data without error

C Slides shows a blank table with no data

D Slides crashes and closes unexpectedly

💡 Hint

Protected ranges restrict access and cause errors when linked without permission.

If you lack permission to view a protected range, the linked object in Slides shows a #REF! error indicating permission denied. It does not silently show cached data or blank tables.