A is incorrect: Prompt Coach helps you learn to write better prompts for Copilot, but it does not itself analyze data or process spreadsheets. To identify trends and outliers in datasets, use the Analyst agent, which is purpose-built for advanced data analysis. Reference: https://support.microsoft.com/en-us/topic/agents-built-by-microsoft-9cc7cccf-b1ed-4b17-b416-2c15e5e13d5a
B is incorrect: The People agent helps you find colleagues by role or skill, view top collaborators, and prepare for upcoming meetings or conversations. It does not perform data analysis on spreadsheets or CSV files. The Analyst agent is designed for this data analysis task. Reference: https://support.microsoft.com/en-us/topic/get-started-with-people-in-microsoft-365-copilot-frontier-3fffc8db-e8ec-4c5f-8276-1609463e9288
C is correct: The Analyst agent is specifically designed for advanced data analysis. It uses a reasoning model optimized for data analytics, can run Python code to tackle complex data queries, and produces easy-to-read reports with visualizations from enterprise data files including Excel spreadsheets and CSVs. Reference: https://support.microsoft.com/en-us/topic/get-started-with-analyst-in-microsoft-365-copilot-ff505b9c-a06c-4be9-b855-69d89b1d25d2
D is incorrect: Researcher is designed for complex, multi-step research that synthesizes information from the web and work files into source-cited reports. For analyzing raw data across spreadsheets to find trends and outliers, the Analyst agent is the better choice due to its data-specific reasoning model. Reference: https://support.microsoft.com/en-us/topic/get-started-with-researcher-in-microsoft-365-copilot-e63ab760-f3de-4c47-ae87-dad601b0e9c4