Gids-gekoppelde quiz · Middelmatig Niveau

Spreadsheetscripts en macro's schrijven met AI Quiz

Test wanneer u scripts in plaats van formules moet gebruiken, hoe u veilige VBA- en Apps Script-verzoeken schrijft en hoe u e-mail- en opschoonmacro's test zonder gegevensverlies.

Vraag 1 van 8

Which task calls for a script rather than a formula?

Bekijk elke vraag8 vragen

Antwoorden en uitleg verschijnen terwijl je de quiz doet.

  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