Question 1
You are using Microsoft 365 Copilot to enhance your productivity in Microsoft Excel.
Which two tasks can you achieve by using Copilot in Excel? Each correct answer presents a complete the solution.
NOTE: Each correct selection is worth one point.
I agree with the suggested answer CD. Microsoft 365 Copilot in Excel is primarily designed for data analysis, transformation, and insight generation, making the creation of summaries and pivot tables core functionalities.
Reason
Option C is correct because Copilot can analyze a dataset to identify trends, outliers, and key metrics, providing a written or visual summary of insights. Option D is correct because Copilot can automatically generate PivotTable suggestions or build them based on specific natural language prompts to help categorize and compare data.
Why the other options are not as suitable
- Option A is incorrect because while Copilot can suggest data highlighting, it does not currently support the deep customization of complex conditional formatting rule logic or management.
- Option B is incorrect because while Copilot can suggest and insert standard charts, it lacks the ability to apply specific custom formatting (such as precise hex codes, custom line weights, or proprietary branding styles) directly through the chat interface.