Fundamentals of Apps Script with Google Sheets

  1. When you record a macro, Sheets automatically saves the actions in a ___.

  2. The ___ class allows you to read, update, and organize groups of cells.

  3. Fill-in-the-blanks

    Enter one or more words to complete the sentence.

    In Apps Script, ___ provide a way of running specific Apps Script code in response to specific conditions or events.

  4. True or false? When changing or updating cells, it is a best practice to call Range.setValue(value) for each cell.

  5. Fill-in-the-blanks

    Enter one or more words to complete the sentence.

    Windows that appear over the Sheets interface are known as ___ ___ , and they prevent a user from interacting with Sheets while present.