Google Sheets Test Google Sheets Automation with Macros 5

Question 1

What is a key limitation of the macro recorder compared to writing Apps Script manually?

Accepted Answer

It cannot capture conditional logic or custom functions

Answer

The recorder captures literal actions but not logic like if-statements or custom functions.

Question 2

Google Apps Script execution is subject to which type of constraint?

Accepted Answer

Daily quotas and maximum runtime limits

Answer

Apps Script enforces quotas and per-execution runtime limits.

Question 3

To show a custom menu of macros to users, an onOpen() function typically uses:

Accepted Answer

SpreadsheetApp.getUi().createMenu()

Answer

getUi().createMenu() builds a custom menu shown when the sheet opens.

Question 4

Which best describes an 'installable trigger' versus a 'simple trigger'?

Accepted Answer

Installable triggers can access services requiring authorization and run on schedules

Answer

Installable triggers support authorization-dependent services and time-based scheduling that simple triggers cannot.

Question 5

If two macros are assigned the same keyboard shortcut, Google Sheets will:

Accepted Answer

Prevent the duplicate and require a different shortcut

Answer

Sheets does not allow two macros to share the same shortcut and prompts for a unique one.

Google Sheets Test Practice Test