Bài kiểm tra có liên kết hướng dẫn · Trung bình Cấp độ
Cách viết tập lệnh bảng tính và macro bằng AI Quiz
Kiểm tra thời điểm sử dụng tập lệnh thay vì công thức, cách viết các yêu cầu VBA và Apps Script an toàn cũng như cách kiểm tra email và dọn dẹp macro mà không làm mất dữ liệu.
Câu hỏi 1 của 8
Which task calls for a script rather than a formula?
Xem trước mọi câu hỏi8 câu hỏi
Câu trả lời và giải thích xuất hiện khi bạn làm bài kiểm tra.
- 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
- What language does Google Sheets use for scripts?
- VBA
- Apps Script, which is JavaScript-based
- Python
- Office Scripts only
- 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
- 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
- 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
- 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
- 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
- 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