AB-731 practice question 11 of 35

Tailwind Traders’ finance controller wants to understand budget vs. actual performance using an exported Excel file. They attach the file in the…

Full set: 389 questions
Tailwind Traders’ finance controller wants to understand budget vs. actual performance using an exported Excel file. They attach the file in the Microsoft 365 Copilot app and want to: “find unusual cost centres,” “plot key trends by quarter,” and “ask ‘what-if’ questions” about adjusting spend. They don’t need a long research report; they just want interactive analysis of the data they’ve provided. To support this scenario, they should primarily use the ______ agent in Microsoft 365 Copilot.
Answer options
A: Researcher
B: Standard Copilot Chat only
C: Create
D: Analyst Correct answer
Correct Answer:
D. Analyst
Explanation

The finance controller's tasks—finding unusual cost centers, plotting trends, and asking "what-if" questions—are all core data analysis activities. The "Analyst" agent is the conceptual tool designed specifically for this purpose. It is optimized to work with structured data, such as an Excel file, to perform calculations, identify statistical outliers, generate visualizations (plots), and model scenarios. This specialized function provides the interactive, in-depth analysis required, which goes beyond the capabilities of a general chat or a research-focused agent.

Why Incorrect

A. The Researcher agent is designed for gathering and synthesizing information from a broad set of documents or web sources, not for deep numerical analysis of a single file.
B. Standard Copilot Chat has general file-handling capabilities but lacks the specialized, deep analytical and visualization functions required for this scenario.
C. The Create agent is focused on generating new content like a report or presentation, not on the interactive analysis and exploration of a dataset.

References

1. Microsoft Support. (2024). Analyze data with Copilot in Excel. "Ask Copilot to... 'Show me a bar chart of sales by product'... 'Project the impact of a [variable change]'... This demonstrates the 'what-if' and plotting capabilities of the Analyst function. Section: "Prompt ideas to try".

2. Microsoft 365 Blog. (2024). Announcing Microsoft 365 Copilot. The initial announcements and subsequent feature descriptions consistently differentiate between content creation, summarization, and data analysis as distinct pillars of Copilot's functionality, supporting the use of a specialized agent for analysis.

Scroll to Top