Google Sheets Test Google Sheets Automation with Macros 2 — Questions and Answers
Question 1: When you record a macro in Google Sheets, what language is the underlying code written in?
- Google Apps Script (JavaScript-based) (Correct answer)
- Visual Basic for Applications (VBA)
- Python
- Microsoft Office Script
Correct answer: Google Apps Script (JavaScript-based)
Google Sheets macros are stored as Google Apps Script, which is based on JavaScript.
Question 2: Which menu path is used to begin recording a new macro?
- Extensions > Macros > Record macro (Correct answer)
- Tools > Macros > Record
- Insert > Macro
- Data > Automation > Record
Correct answer: Extensions > Macros > Record macro
Macro recording lives under Extensions > Macros > Record macro.
Question 3: What is the maximum number of macros you can assign a keyboard shortcut to in a single Google Sheets file?
- 10 (Correct answer)
- 5
- Unlimited
- 3
Correct answer: 10
Google Sheets limits keyboard-shortcut-assigned macros to 10 per file.
Question 4: The keyboard shortcut assigned to a recorded macro typically follows which pattern?
- Ctrl+Alt+Shift+<number> (Correct answer)
- Ctrl+<number>
- Alt+<letter>
- Ctrl+Shift+<letter>
Correct answer: Ctrl+Alt+Shift+<number>
Recorded macro shortcuts use Ctrl+Alt+Shift plus a number key.
Question 5: When recording, choosing 'Relative references' means the macro will:
- Act on cells relative to your current selection (Correct answer)
- Always affect the exact same cell addresses
- Ignore the active cell entirely
- Only work on the first sheet
Correct answer: Act on cells relative to your current selection
Relative references make the macro operate based on the position of the active cell.
Question 6: After editing a macro's Apps Script code, what must you do before the changes take effect?
- Save the script project (Correct answer)
- Delete and re-record the macro
- Restart the browser
- Reinstall Google Sheets
Correct answer: Save the script project
Saving the Apps Script project applies your code edits to the macro.
Question 7: Where can you view and manage all macros defined in a spreadsheet?
- Extensions > Macros > Manage macros (Correct answer)
- File > Settings > Macros
- View > Macros
- Format > Macros
Correct answer: Extensions > Macros > Manage macros
The 'Manage macros' option under Extensions > Macros lists and edits existing macros.
Google Sheets Test Google Sheets Automation with Macros 2
When you record a macro in Google Sheets, what language is the underlying code written in?