Google Sheets Test Google Sheets Automation with Macros 3

Question 1

A recorded macro is imported into another spreadsheet by:

Accepted Answer

Copying its Apps Script function into that file's script editor

Answer

Macros travel with their Apps Script code, so you copy the function into the other file's editor.

Question 2

In the Apps Script editor, which service object is most commonly used to access the active spreadsheet?

Accepted Answer

SpreadsheetApp

Answer

SpreadsheetApp is the entry-point service for interacting with Google Sheets.

Question 3

Which method returns the currently active sheet within a spreadsheet?

Accepted Answer

getActiveSheet()

Answer

getActiveSheet() returns the sheet a user is currently viewing.

Question 4

A macro that must run automatically whenever the sheet is opened should be implemented as:

Accepted Answer

An onOpen() trigger function

Answer

The onOpen() simple trigger runs automatically when the spreadsheet opens.

Question 5

What happens if you record a macro while 'Absolute references' is selected and then run it from a different cell?

Accepted Answer

It still affects the originally recorded cell addresses

Answer

Absolute references lock the macro to the exact cells recorded, regardless of the active cell.

Google Sheets Test Practice Test