Microsoft Azure (legacy) — Question 9

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.

Answer options

• 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.
• D. Build a pivot table based on your data.

Correct answer: C, D

Explanation

The correct answers are C and D because Copilot can analyze data and provide summaries, as well as assist in building pivot tables for data analysis. Options A and B involve more manual customization and design work that Copilot does not specifically automate.