AB-730 Certification Practice Question #35

Question

You have a Microsoft Excel workbook open that contains a table. The table contains sales data and the following columns:
• OrderDate
• OrderNumber
• Amount
You plan to use Microsoft Copilot in Excel to generate a monthly summary of the sales data in the table.
What should you include in the prompt to generate an effective summary? More than one answer choice may achieve the goal. Select the BEST answer.

Accepted Answer

Among effective-prompt elements, a clear goal is the single most important for an accurate monthly summary — it tells Copilot what to aggregate. Format (A) improves presentation but is secondary; cell range, file name, and a hand-written formula are unneeded since Copilot works on the open table. With a "BEST answer" instruction, D wins; A as a close second keeps confidence at 84%.

More AB-730 practice questions