Google Sheets Automation with Macros Flashcards
7 cards from real Google Sheets Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Google Sheets Automation with Macros flashcards as text
A recorded macro is imported into another spreadsheet by:
Answer: Copying its Apps Script function into that file's script editor
Macros travel with their Apps Script code, so you copy the function into the other file's editor.
In the Apps Script editor, which service object is most commonly used to access the active spreadsheet?
Answer: SpreadsheetApp
SpreadsheetApp is the entry-point service for interacting with Google Sheets.
Which method returns the currently active sheet within a spreadsheet?
Answer: getActiveSheet()
getActiveSheet() returns the sheet a user is currently viewing.
A macro that must run automatically whenever the sheet is opened should be implemented as:
Answer: An onOpen() trigger function
The onOpen() simple trigger runs automatically when the spreadsheet opens.
What happens if you record a macro while 'Absolute references' is selected and then run it from a different cell?
Answer: It still affects the originally recorded cell addresses
Absolute references lock the macro to the exact cells recorded, regardless of the active cell.
Which statement about macro execution permissions is correct?
Answer: The user may be prompted to authorize the script the first time it runs
Apps Script prompts for authorization when a macro first accesses your data.
To rename a macro, you should:
Answer: Use Extensions > Macros > Manage macros and edit the name
The Manage macros dialog lets you rename an existing macro.
How this page was made: written with AI tools. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy