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 sales manager needs to analyze quarterly sales data to identify top-performing products and regions. They enter sales data into Excel, including columns for product names, regions, and sales figures. What should they do next to complete the task?
They should use Copilot to create a PivotTable by typing a natural language prompt like, 'Create a PivotTable to summarize sales by product and region.'
They should export the data to a separate analytics tool for analysis.
They should manually calculate the total sales for each product and region.
A data engineer is working with customer data imported from two different systems. The column headers differ slightly, and they need to combine the datasets for analysis. How should they use Copilot in Excel?
Delete one of the tables to avoid confusion.
Merge the tables and align columns with similar data.
Highlight all cells with duplicate values.
A financial analyst is preparing a report and needs to summarize a dataset with over 1,000 rows. They want to quickly identify key trends without manually reviewing the data. What's the most efficient way to use Copilot?
Ask Copilot to 'Summarize key insights from this dataset.'
Scroll through the data and take notes.
Use the filter tool to isolate each column.
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?