fx Google Apps Script

Getting Started

59 min4 lessons8 quiz questions

Lessons

Practice file coming soon.

1. Where does Apps Script code run? a) On your laptop b) On Google's servers c) Inside Excel

On Google's servers

2. Which task is a poor fit for Apps Script? a) Emailing a weekly report b) Auto-creating invoices c) Processing 5 million rows of data

Processing 5 million rows of data

3. Which script can add a custom menu to a spreadsheet? a) Bound script b) Standalone script c) Neither

Bound script

4. Where do you see the history of past runs? a) Libraries b) Executions c) Deploy

Executions

5. In data[3][1], which sheet cell is that (if data starts at A1)? a) C2 b) B4 c) D2

6. Which helper works like Excel's FILTER? a) map b) filter c) reduce

filter

7. Which button lets you pause at a breakpoint? a) Run b) Debug c) Deploy

Debug

8. Cannot read properties of null (reading 'getRange') most often means… a) The script ran too long b) A sheet name is wrong c) No internet

A sheet name is wrong