Exam AB-730 Topic 2 Question 25 Discussion
Actual exam question for Microsoft's AB-730 exam
Question #: 25
Topic #: 2
Question #: 25
Topic #: 2
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.
- 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.
Suggested Answer: D Vote an answer
To generate an effective monthly sales summary using Microsoft Copilot in Excel, your prompt must include a clear goal that specifies exactly what you want to achieve.
Why the Goal Matters
A clear goal is the most critical part of a prompt. Without it, Copilot may provide generic insights that don't align with your business needs.
Elements of an Effective Prompt
While a goal is the only required element, adding these components can significantly improve results:
Goal: What you specifically want Copilot to do (e.g., "Summarize monthly sales").
Context: Why you need it or who the audience is (e.g., "for a leadership briefing").
Expectations: How you want the output to look (e.g., "in a bulleted list" or "as a PivotTable").
Source: Which specific data to use (e.g., "from the 'SalesTable'").
Example of an Effective Prompt
Instead of saying "Summarize this data," use a structured prompt like this:
"Summarize the monthly revenue from the 'SalesTable' [Goal/Source]. Identify the top-performing product category and any significant sales trends [Context]. Present the findings in a concise bulleted list for my manager [Expectations]." Reference:
https://stringfestanalytics.com/how-to-write-effective-prompts-for-copilot-in-excel/
Why the Goal Matters
A clear goal is the most critical part of a prompt. Without it, Copilot may provide generic insights that don't align with your business needs.
Elements of an Effective Prompt
While a goal is the only required element, adding these components can significantly improve results:
Goal: What you specifically want Copilot to do (e.g., "Summarize monthly sales").
Context: Why you need it or who the audience is (e.g., "for a leadership briefing").
Expectations: How you want the output to look (e.g., "in a bulleted list" or "as a PivotTable").
Source: Which specific data to use (e.g., "from the 'SalesTable'").
Example of an Effective Prompt
Instead of saying "Summarize this data," use a structured prompt like this:
"Summarize the monthly revenue from the 'SalesTable' [Goal/Source]. Identify the top-performing product category and any significant sales trends [Context]. Present the findings in a concise bulleted list for my manager [Expectations]." Reference:
https://stringfestanalytics.com/how-to-write-effective-prompts-for-copilot-in-excel/
by Reuben at Jul 07, 2026, 03:02 AM
0
0
0
10
Comments
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).