QuestionQ7
Manage prompts and conversations by using AIYou have a Microsoft Excel workbook open that includes a table. The table holds sales data in these columns:
- OrderDate
- OrderNumber
- Amount
You plan to use Microsoft Copilot in Excel to create a monthly summary of the table's sales data.
What should the prompt include to produce an effective summary? More than one answer choice may achieve the goal. Select the BEST answer.
- A the desired format of the response
- B a specific cell range from the worksheet
- C the file name of the workbook
- D the clear goal of the summary
- E a formula to calculate monthly totals
Community Discussion