Perform basic administrative tasks for Copilot and agents3 / 5
A finance analyst wants Microsoft 365 Copilot to examine raw data across several Excel spreadsheets, run calculations, and generate charts and insights like a skilled data analyst. Which built-in capability best fits this task?
CorrectIncorrect
Alex
The Analyst agent is a prebuilt reasoning agent in Microsoft 365 Copilot that acts like a skilled data analyst. It can work across multiple spreadsheets, run code (Python) to perform advanced analysis, and produce insights and visualizations from raw data. This makes it the right fit for tasks such as reviewing a monthly close file and flagging line items that look out of line with prior months. A common exam distinction: Researcher is for multi-step research and cited reports, while Analyst is for crunching raw numbers and visualizing results. Both are first-party reasoning agents available to users with a Microsoft 365 Copilot license and are invoked from Copilot Chat. The doc concept to remember is that Analyst 'runs code' and creates visualizations, which is what separates it from a plain chat answer.
Sourcelearn.microsoft.com
Follow-up answers are available in the app. Create a free account — no credit card required.
Question 3 of 5
Create a free account