Google Sheets Test Google Sheets Automation with Macros 4

Question 1

Which trigger type lets a macro run on a time-based schedule, such as every hour?

Accepted Answer

An installable time-driven trigger

Answer

Time-driven installable triggers run scripts on a schedule you define.

Question 2

In Apps Script, getRange('A1:B2') on a sheet returns:

Accepted Answer

A Range object spanning those cells

Answer

getRange returns a Range object representing the specified cells.

Question 3

Which method writes a value into a single cell Range?

Accepted Answer

setValue()

Answer

setValue() sets the content of a single-cell range.

Question 4

A simple onEdit(e) trigger is best used to:

Accepted Answer

React automatically when a user changes a cell

Answer

onEdit runs automatically each time a user edits a cell in the spreadsheet.

Question 5

Why might a recorded macro fail after you delete a sheet it referenced?

Accepted Answer

The macro's code still points to a sheet that no longer exists

Answer

Recorded macros reference sheets by name, so removing a referenced sheet breaks the code.

Google Sheets Test Practice Test