AB-730 Certification Practice Question #1

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 the solution.
NOTE: Each correct selection is worth one point.

Accepted Answer

Copilot in Excel is positioned around analysis and insight generation, not manual cell/chart formatting. Generating a summary of key insights (C) and building a pivot table (D) are core Copilot Excel tasks per MS Learn and the community. Conditional-formatting rules (A) and custom chart formatting (B) are precise formatting operations the user performs with Excel's own tools — Copilot can suggest, not apply them.

More AB-730 practice questions