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
Which trigger type lets a macro run on a time-based schedule, such as every hour?
Answer: An installable time-driven trigger
Time-driven installable triggers run scripts on a schedule you define.
In Apps Script, getRange('A1:B2') on a sheet returns:
Answer: A Range object spanning those cells
getRange returns a Range object representing the specified cells.
Which method writes a value into a single cell Range?
Answer: setValue()
setValue() sets the content of a single-cell range.
A simple onEdit(e) trigger is best used to:
Answer: React automatically when a user changes a cell
onEdit runs automatically each time a user edits a cell in the spreadsheet.
Why might a recorded macro fail after you delete a sheet it referenced?
Answer: The macro's code still points to a sheet that no longer exists
Recorded macros reference sheets by name, so removing a referenced sheet breaks the code.
Which is a valid reason to edit macro code directly instead of re-recording?
Answer: To add logic like loops or conditions the recorder can't capture
Direct editing lets you add loops, conditionals, and other logic beyond recorded steps.
Which method would you use to loop through many rows efficiently in Apps Script?
Answer: Read all data at once with getValues() into an array
getValues() reads a whole range into an array, which is far faster than per-cell calls.
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