This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Choose the best response for each of the questions.
A business analyst has quarterly sales reports from five regional teams stored in separate files. They need to compare performance across all five reports before consolidating data into a workbook. Which Copilot capability is best suited for this initial cross-file exploration?
The Analyst agent, by attaching all five files in the Microsoft 365 Copilot app and asking a cross-file comparison question.
Copilot in Excel with Python, by describing a multi-file statistical analysis to Copilot in natural language.
Copilot in Excel PivotTable creation, by first importing and consolidating all five datasets into one workbook.
A financial analyst needs to forecast monthly revenue for the next six months based on the year-to-date trend in their Excel workbook. The analyst has no coding background. Which Copilot capability should the analyst use?
Copilot in Excel with Python, by describing the forecast in natural language.
Use Copilot to retrieve existing information from organizational data sources.
A Copilot-generated PivotTable that groups and summarizes the year-to-date sales figures by month and quarter.
A project manager is building a budget workbook in Excel and needs to include cost figures that were discussed in a recent internal meeting. The figures aren’t saved in a file. Which approach should they use?
Use Copilot to retrieve organizational data from Microsoft 365 sources, such as meetings or emails, and add the relevant figures to the workbook.
Use Copilot to search the web for publicly available budget benchmarks.
Use the Analyst agent to compare multiple files and extract the meeting data.
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?