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 below.
What is a key requirement for Copilot in Excel to analyze your data?
The file must be saved on your desktop.
The data must be formatted as a table or supported range and saved on OneDrive.
The data must be in a PDF file.
The file must be emailed to your manager.
How can Copilot in Excel help you visualize your data for a leadership presentation?
By automatically emailing charts to your team.
By creating charts from your data with a prompt and allowing you to refine them (for example, add labels, highlight regions).
By deleting all raw data.
By converting charts into Word documents.
What is the primary function of the Analyst agent in Microsoft Copilot?
To edit PowerPoint slides.
To analyze organizational data, generate visualizations, and provide actionable insights using chain-of-thought reasoning.
To send automated emails.
To delete old Excel files.
Which of the following is a best practice when prompting Copilot or the Analyst agent for data analysis?
Use vague prompts to let Copilot decide what to analyze.
Be specific in your questions and refine your analysis with follow-up prompts.
Only use one-word prompts.
Avoid asking for visualizations.
A business analyst needs to examine three months of sales reports stored in separate files and produce a cited, structured summary. Which tool is best suited for this task?
Copilot Chat, because it handles general AI requests.
Copilot in Excel, because the data is in spreadsheets.
The Analyst agent, because it reasons across multiple files and generates cited reports with visualizations.
Edit with Copilot, because it can build and modify workbooks.
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?