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 365 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.
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?