A is incorrect: Writing Coach focuses on improving writing quality by refining tone, grammar, and style. It does not perform data analysis or generate visualizations from spreadsheet data. The Analyst agent is specifically designed for these data analysis tasks. Reference: https://support.microsoft.com/en-us/topic/agents-built-by-microsoft-9cc7cccf-b1ed-4b17-b416-2c15e5e13d5a
B is incorrect: Researcher excels at complex multi-step research tasks that require gathering and synthesizing information from work files and the web. For direct data analysis of a spreadsheet — including trend identification and chart creation — the Analyst agent is the purpose-built tool. Reference: https://learn.microsoft.com/en-us/copilot/microsoft-365/researcher-agent
C is correct: The Analyst agent is designed to work like a skilled data scientist, using chain-of-thought reasoning to analyze raw data from spreadsheets and other files. It can calculate statistics, identify trends, show outliers, and generate charts — making it ideal for analyzing large datasets without requiring advanced data expertise. Reference: https://support.microsoft.com/en-us/topic/get-started-with-analyst-in-microsoft-365-copilot-ff505b9c-a06c-4be9-b855-69d89b1d25d2
D is incorrect: Prompt Coach helps users learn to write better prompts for Copilot — it does not perform data analysis or create visualizations. The Analyst agent is the correct choice for analyzing raw data, identifying trends, and generating charts directly. Reference: https://support.microsoft.com/en-us/topic/agents-built-by-microsoft-9cc7cccf-b1ed-4b17-b416-2c15e5e13d5a