Question
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 solution.
NOTE: Each correct selection is worth one point.
- A. Customize the conditional formatting rules for your data.
- B. Insert a custom chart that has specific formatting.
- C. Generate a summary of key insights from your data. Correct
- D. Build a pivot table based on your data. Correct
Explanation
Copilot in Excel is built to interpret your data and give insights about it, so asking for a summary of key insights is a core task. It can also create and organize PivotTables that summarize your data. Fine-tuning conditional formatting rules and producing a chart to an exact formatting specification are precise formatting jobs better suited to Excel's own Conditional Formatting and chart tools, so they are not the best answers here.
