Microsoft AB-730 - Questions & Answers

Copilot in Excel is designed to help users analyze workbook data and identify insights such as summaries, trends, outliers, charts, and PivotTables. Generating key insights from the data and building a PivotTable from structured data both align with those analysis capabilities. By contrast, creating highly specific chart formatting or manually customizing conditional formatting rules is a direct Excel authoring task, not the core Copilot outcome being tested here. The exam takeaway is that Copilot in Excel is strongest when the prompt asks it to analyze, summarize, calculate, or create data-driven views from existing tabular data.

Copilot in Word can summarize a document and help draft or add text based on document context, referenced files, or a user prompt. The supported capability that is clearly represented in the answer choices is generating a summary of the key points in the document. Table of contents insertion, page margin configuration, and custom watermark formatting are conventional Word layout features and are not reliable examples of Copilot generating or reasoning over document content. Because the question asks for two selections but only one listed task is clearly supported by the cited Copilot in Word behavior, the safest correction is to keep only the document-summary task.

Copilot in Outlook supports drafting email messages and can use the context of an email thread or conversation to help compose a response. Copilot Chat in the Microsoft 365 experience can also help catch up on unread communications, including messages and mail-related work context depending on licensing and host experience. Custom HTML signatures and mailbox folder structures are Outlook configuration and organization tasks rather than Copilot-generated communication assistance. The important distinction is that Copilot helps with content understanding and drafting, not with every mailbox administration or formatting setting.

Copilot in PowerPoint can use presentation content to help create or organize slides and can summarize the important points in a deck. Creating a slide structure from the presentation content and producing a summary-style slide are content-generation and content-analysis tasks that match the PowerPoint Copilot feature set. Manually applying a custom animation to a single object or enforcing a company design theme is a PowerPoint design and formatting workflow, not the primary Copilot reasoning task. Students should associate Copilot in PowerPoint with drafting, summarizing, transforming, and organizing presentation content.

Copilot in Teams can summarize meetings and conversations, including key discussion points, decisions, and action items when the required meeting or chat context is available. Copilot in Teams chat and channels can also help draft or refine responses based on the current conversation thread. Muting participants and creating custom video backgrounds are Teams meeting controls or media settings rather than Copilot language and summarization capabilities. The practical rule is to use Copilot in Teams for catching up, summarizing, answering questions about conversation context, and drafting responses.