How to Write Spreadsheet Scripts and Macros with AI Quiz

Answers and explanations appear as you take the quiz.

1. Which task calls for a script rather than a formula?
   • Totaling a column of sales
   • Looking up a price from a table
   • Emailing every person whose status is Approved
   • Formatting a number as currency
2. What language does Google Sheets use for scripts?
   • VBA
   • Apps Script, which is JavaScript-based
   • Python
   • Office Scripts only
3. Why does the guide stress testing Excel macros on a copy of the file?
   • Macro changes generally cannot be undone with Ctrl+Z
   • Copies run macros faster
   • Excel refuses to run macros on original files
   • The AI cannot read the original file
4. What is the safest first test for a script that sends emails?
   • Send to the whole list at once to save time
   • Turn off the authorization prompt
   • Run it on a sheet with no data
   • Send only to yourself first, or list recipients before sending
5. Why should a macro delete rows from the bottom up?
   • VBA syntax requires it
   • Deleting from the top shifts row numbers and causes rows to be skipped
   • The bottom rows are always blank
   • It avoids hitting email quotas
6. What is the most efficient way to process many cells in Apps Script?
   • Call getValue and setValue once for each cell
   • Write a separate script for each row
   • Read with getValues, process in memory, then write back with setValues
   • Refresh the sheet after every change
7. How can a script avoid redoing work if it stops partway and is run again?
   • Mark each processed row, for example by writing "Sent" in a status column
   • Delete the script after each run
   • Ask Google to raise the quota
   • Hide rows once they are processed
8. According to the guide, where does the real risk of macros come from?
   • The .xlsm file extension itself
   • Adding comments to the code
   • Using time-driven triggers
   • Running code you do not understand, especially in files from strangers