AI Spreadsheet Copilots Quiz

Answers and explanations appear as you take the quiz.

1. What is a key advantage of AI spreadsheet copilots over a fully automated black-box tool?
   • Results land in real, auditable cells and formulas you can inspect and edit
   • They hide all formulas from the user
   • They only work offline
   • They delete your original data
2. How does a spreadsheet copilot know which function to use for your request?
   • It guesses randomly every time
   • It uses schema awareness — knowing your column names and data types
   • It asks another human first
   • It only ever uses the SUM function
3. What can Copilot in Excel do in its documented advanced-analysis mode?
   • Change the workbook’s macros without approval
   • Train a new large language model inside the spreadsheet
   • Create a new sheet and run Python code for more complex data analysis
   • Guarantee a calculation is correct without review
4. Why is human review still essential when using a spreadsheet copilot?
   • Because the AI never produces any output
   • Because spreadsheets cannot show numbers
   • Because review makes the file smaller
   • Because a confident but wrong number is still wrong and models can misread data
5. Which task is a spreadsheet copilot well suited to handle?
   • Cleaning messy data like inconsistent dates and duplicates
   • Physically printing the spreadsheet
   • Charging a laptop battery
   • Designing the keyboard layout
6. What control does Microsoft document for Copilot in Excel skills?
   • Skills run without any user control or settings
   • Users can manage which skills are enabled or invoke a skill by name
   • Skills permanently rewrite the workbook’s formulas
   • Skills replace the need to save workbook versions
7. What source detail can appear with Copilot’s analysis of text in Excel?
   • A guarantee that every theme is objectively true
   • A database record that automatically updates the workbook
   • A superscript reference that points to source data used in the analysis
   • A legal approval for sharing the comments
8. What can Microsoft Copilot in Excel do with a formula it generates?
   • Guarantee the formula is correct for every workbook
   • Modify macros without user review
   • Replace the workbook’s source data with generated values
   • Suggest a formula and explain how it works