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.
Customize the conditional formatting rules for your data.
Insert a custom chart that has specific formatting.
Generate a summary of key insights from your data.
Build a pivot table based on your data.
Show answer and explanation
Correct answer: C, D. Generate a summary of key insights from your data; Build a pivot table based on your data.
Copilot in Excel can generate summaries of key insights from data by analyzing patterns and trends, and can build pivot tables automatically based on the data structure and user intent. These are AI-driven analytical tasks that Copilot handles well. Conditional formatting rules and custom chart formatting require more granular user control and specific design choices that are better suited to manual configuration or direct commands rather than AI summarization.
Why the other options are wrong
A. Conditional formatting customization is a granular formatting task better handled through Excel's native conditional formatting dialog rather than Copilot.
B. Custom chart formatting with specific styling preferences requires direct user control over design elements that Copilot cannot reliably predict.
Question 2
You are using Microsoft 365 Copilot to enhance your productivity in Microsoft Word. Which two tasks can you achieve by using Copilot in Word? Each correct answer presents a complete the solution. NOTE: Each correct selection is worth one point.
Insert a table of contents based on the headings in your document.
Customize the page margins to match your company's document standards.
Generate a summary of the key points in your document.
Insert a custom watermark that has specific text and formatting.
Show answer and explanation
Correct answer: C, D. Generate a summary of the key points in your document; Insert a custom watermark that has specific text and formatting.
Copilot in Word can generate summaries of key points by analyzing document content and extracting main ideas, and can insert custom watermarks with specific text and formatting as a design element. These are content analysis and document design tasks that align with Copilot's strengths. Table of contents generation is an automated feature in Word itself rather than a Copilot capability, and margin customization is a formatting preference that does not require AI assistance.
Why the other options are wrong
A. Table of contents insertion is a standard Word feature based on heading styles, not a Copilot-specific capability.
B. Customizing page margins is a straightforward formatting task that does not require AI assistance from Copilot.
Question 3
You are using Microsoft 365 Copilot to enhance your productivity in Microsoft Outlook. Which two tasks can you achieve by using Copilot in Outlook? Each correct answer presents a complete the solution. NOTE: Each correct selection is worth one point.
Insert a custom HTML signature that has specific formatting.
Generate a draft response to an email based on the context of the conversation.
Create a summary of unread emails in your inbox.
Customize the folder structure to organize your emails.
Show answer and explanation
Correct answer: B, C. Generate a draft response to an email based on the context of the conversation; Create a summary of unread emails in your inbox.
Copilot in Outlook can generate draft responses to emails by understanding conversation context and suggesting appropriate replies, and can create summaries of unread emails to help users quickly understand key information in their inbox. These are context-aware content generation and summarization tasks that leverage Copilot's language understanding. Custom HTML signatures require manual technical configuration, and folder structure organization is a personal preference management task unrelated to AI capabilities.
Why the other options are wrong
A. Custom HTML signatures with specific formatting are administrative customizations that do not require or benefit from Copilot's AI capabilities.
D. Folder structure organization is a personal preference management task that Copilot cannot intelligently automate.
Each step includes the one before, so buying only adds new questions.
You are here10questionsFree sampleThree on this page, all ten as a PDF.Download the sample
2224% of the bankPractice pageFree on the site, every answer explained.Go to the practice page
43the first half of the packHalf PackFree by email, as one PDF, every answer explained.Get the Half Pack
92100%, the whole bankFull pack, US$39Plus the questions-only PDF, monthly updates, refund if you fail.Get the full pack
ABOUT THIS PACK
What’s in the Microsoft AB-730 pack
92 questions mapped to the AB-730 exam objectives
Answers and explanations for every question, including the wrong options
A questions-only PDF for timed practice runs
Instant delivery by email the moment you check out
Free monthly updates for as long as the exam is live
Pass or your money back
Fail the AB-730 and it costs another US$99. This pack is US$39, paid once, and refunded if you fail.
What makes the AB-730 hard
AB-730 is not about memorising Copilot menus, it is about knowing when to use which AI experience: Copilot Chat versus a dedicated agent, Researcher versus Analyst, create from file in Word versus drafting from scratch. The exam does not test whether buttons can be clicked, it tests whether the right AI tool can be matched to a business scenario, and whether fabrications, prompt injection or over-reliance can be spotted before AI-generated work ships. That is where most first-time candidates lose marks.
The exam runs 40 to 60 questions in 45 minutes with a pass mark of 700 out of 1000. At US$99 it is one of the more affordable Microsoft exams, but a retake costs another US$99 plus a 24-hour wait.
This pack has 92 practice questions for the AB-730, covering prompt management, agent use cases and responsible AI, so the best-answer scenario questions Microsoft leans on are not a surprise on exam day.
About the exam
AB-730 is Microsoft's certification for business professionals who use generative AI and Microsoft 365 Copilot to improve daily work, without writing code or building AI apps. It suits anyone working across Outlook, Word, Teams, PowerPoint and Excel, no technical background required.
Questions before you buy
How quickly do I receive it?
Straight away. The full PDF and a questions-only copy are emailed to you the moment your payment goes through, and the same links are on your order page.
Are updates included?
Yes. The pack is updated every month for as long as the exam is live, and updates are free for everyone who has bought it.
What if I fail the exam?
We refund the pack, or swap it for any other pack if you would rather keep studying. Sit the exam 7 to 30 days after buying, then send your official score report within 7 days of the exam date, as set out in the refund policy.
What is your pass rate?
99% of customers who prepare with a CertStash pack pass. If you do not, we refund the pack, or swap it for another pack.
Can I share it with colleagues?
Each purchase is licensed to one person. For a team, school or training organisation, email support@certstash.com for a licence that fits.
