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
When you record a macro in Google Sheets, what language is the underlying code written in?
Answer: Google Apps Script (JavaScript-based)
Google Sheets macros are stored as Google Apps Script, which is based on JavaScript.
Which menu path is used to begin recording a new macro?
Answer: Extensions > Macros > Record macro
Macro recording lives under Extensions > Macros > Record macro.
What is the maximum number of macros you can assign a keyboard shortcut to in a single Google Sheets file?
Answer: 10
Google Sheets limits keyboard-shortcut-assigned macros to 10 per file.
The keyboard shortcut assigned to a recorded macro typically follows which pattern?
Answer: Ctrl+Alt+Shift+
Recorded macro shortcuts use Ctrl+Alt+Shift plus a number key.
When recording, choosing 'Relative references' means the macro will:
Answer: Act on cells relative to your current selection
Relative references make the macro operate based on the position of the active cell.
After editing a macro's Apps Script code, what must you do before the changes take effect?
Answer: Save the script project
Saving the Apps Script project applies your code edits to the macro.
Where can you view and manage all macros defined in a spreadsheet?
Answer: Extensions > Macros > Manage macros
The 'Manage macros' option under Extensions > Macros lists and edits existing macros.
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