Creating and opening spreadsheets in Google Sheets - Practice Exercises

Challenge - 5 Problems

📊 Formula Result

intermediate

Opening a spreadsheet by URL

You want to open a Google Sheets spreadsheet using its URL in Apps Script. Which line of code correctly opens the spreadsheet?

A SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123')

B SpreadsheetApp.open('https://docs.google.com/spreadsheets/d/abc123')

C SpreadsheetApp.getByUrl('https://docs.google.com/spreadsheets/d/abc123')

D SpreadsheetApp.openById('https://docs.google.com/spreadsheets/d/abc123')

💡 Hint

Remember the method name includes 'ByUrl' when opening by URL.

The correct method to open a spreadsheet by its URL is SpreadsheetApp.openByUrl(url). Other methods either don't exist or require different parameters.

❓ Function Choice

intermediate

Creating a new spreadsheet with a name

Which function creates a new Google Sheets spreadsheet with the name 'Budget 2024'?

A SpreadsheetApp.open('Budget 2024')

B SpreadsheetApp.new('Budget 2024')

C SpreadsheetApp.make('Budget 2024')

D SpreadsheetApp.create('Budget 2024')

💡 Hint

The method to create a new spreadsheet is named 'create'.

SpreadsheetApp.create(name) creates a new spreadsheet with the given name. Other options are invalid methods.

🎯 Scenario

advanced

Accessing a spreadsheet by ID and getting its name

You have the spreadsheet ID '1a2b3c4d5e'. Which code snippet correctly opens the spreadsheet and gets its name?

A var ss = SpreadsheetApp.open('1a2b3c4d5e'); var name = ss.getTitle();

B var ss = SpreadsheetApp.openById('1a2b3c4d5e'); var name = ss.getName();

C var ss = SpreadsheetApp.getById('1a2b3c4d5e'); var name = ss.getName();

D var ss = SpreadsheetApp.openByUrl('1a2b3c4d5e'); var name = ss.getName();

💡 Hint

Use the method that opens by ID and the method that returns the spreadsheet's name.

SpreadsheetApp.openById(id) opens the spreadsheet by its ID. The method getName() returns the spreadsheet's name. Other methods are invalid or incorrect.

📊 Formula Result

advanced

Result of creating and accessing a new spreadsheet

What is the output of this Apps Script code snippet? var ss = SpreadsheetApp.create('Test Sheet'); var name = ss.getName(); Logger.log(name);

Google Sheets

var ss = SpreadsheetApp.create('Test Sheet');
var name = ss.getName();
Logger.log(name);

A SpreadsheetApp

B undefined

C Test Sheet

D Error: Method getName() not found

💡 Hint

The getName() method returns the name of the spreadsheet.

The code creates a new spreadsheet named 'Test Sheet' and then gets its name, which is 'Test Sheet'.

❓ data_analysis

expert

Identifying error when opening spreadsheet by URL with wrong method

What error will this Apps Script code produce? var ss = SpreadsheetApp.open('https://docs.google.com/spreadsheets/d/abc123');

Google Sheets

var ss = SpreadsheetApp.open('https://docs.google.com/spreadsheets/d/abc123');

A TypeError: SpreadsheetApp.open is not a function

B ReferenceError: open is not defined

C SyntaxError: Unexpected string

D No error, spreadsheet opens successfully

💡 Hint

Check if the method 'open' exists in SpreadsheetApp.

SpreadsheetApp does not have an 'open' method. The correct method to open by URL is 'openByUrl'. Using 'open' causes a TypeError.