Apps Script Quiz - Day 2 Lesson

With Apps Script, you can programmatically manipulate Google Sheets and send email alerts.

• True

• False

This is the parent class for the Spreadsheet service. It is used to reference a Google Sheet file for any automation task.

•  GmailApp

• FormApp

• SpreadsheetApp

• GoogleSheetApp

A SpreadsheetApp method that gets the active sheet in a spreadsheet.

• getActiveRange()

• getActiveSheet()

• getActive()

• getActiveSpreadsheet()

Is sheet.getRange("A1:C3") same as sheet.getRange(1,1,3,3)?

• True

• False

This function automatically executes a script when a user opens a spreadsheet, document, presentation, or form that they have permission to edit.

• onOpen()

• onEdit()

• onInstall()

• doGet()

This class provides access to Gmail threads, messages, and labels.

• SpreadsheetApp

• GmailApp

• FormApp

• calendarApp

This method allows you to reference the Ui class to add features like menus, dialogs, and sidebars.

• SpreadsheetApp

  .getMenu()

• SpreadsheetApp

  .getUserInterface()

• SpreadsheetApp

  .getUi()

• None of the above

In sending email, you can use this key-value parameter under {options} to send an email with a "[e-mail]" account.

• noReply: false

• noReply: true

• replyTo: '[e-mail]'

• doNotReply: true

if set, devices capable of rendering HTML will use it instead of the plain text body argument.

• htmlContent

• htmlBody

• isHtml

• htmlEmail

You can use this key-value parameter under {options} to set a name that will appear in the sender's name when sending email.

• from: <name>

• name: <name>

• fromName: <name>

• None of the above