Microsoft 365 Copilot Excel Capabilities: Summaries and Pivot Tables

AB-730 By islever Editorial Last updated

Understand the differences in features and capabilities of the Copilot experience in various Microsoft 365 apps

Short answer

CD Copilot in Excel generates data summaries and builds pivot tables, but cannot directly customize conditional formatting rules or insert specifically formatted charts.

Question

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.
  1. Customize the conditional formatting rules for your data.
  2. Insert a custom chart that has specific formatting.
  3. Generate a summary of key insights from your data. Correct Answer
  4. Build a pivot table based on your data. Correct Answer

Key Takeaways

The main trap is assuming Copilot handles all Excel features; it excels at data analysis (summaries, pivots) but struggles with precise visual customization (conditional formatting, custom charts).

Learn which two tasks Microsoft 365 Copilot performs natively in Excel: generating data summaries and building pivot tables, versus limitations in custom charting and formatting.

Common mistake: Option B is a common distractor because Copilot suggests charts, but it cannot directly insert 'custom' charts with specific manual formatting constraints, unlike the automated pivot generation.

Expert Analysis

Data Analysis and Summarization Copilot in Excel is designed to interpret datasets and provide actionable insights. The core capability here is generating natural language summaries of key trends, patterns, and statistics within the data. This directly maps to option C, as Copilot can analyze the selected range and output a concise textual summary of findings.

Automated Pivot Table Creation A distinct feature of Copilot in Excel is its ability to generate Pivot Tables based on natural language requests. Users can ask Copilot to "create a pivot table showing sales by region," and it will build the structure, fields, and layout automatically. This confirms option D as a correct answer, representing a complete solution for data aggregation tasks.

Limitations in Visual Formatting and Charting While Copilot can suggest chart types or visualize data, it does not currently support inserting fully custom-formatted charts with specific manual styling constraints (option B). Similarly, while it can apply basic formatting, it cannot deeply customize complex conditional formatting rules via natural language prompts in the manner described (option A). Community feedback highlights that users often confuse Copilot's suggestion capabilities with direct execution of complex visual customizations. Comments indicate that attempts to force custom chart formats or detailed conditional rule edits fail because the AI lacks the granular control over aesthetic properties required for these specific options.

Conclusion The question tests the boundary between analytical automation (summarization, pivot tables) and manual design customization (conditional formatting, custom charts). Only C and D represent tasks where Copilot provides a complete, automated solution without requiring significant manual post-processing.

Exam Strategy

When answering questions about AI assistant capabilities in Office apps, distinguish between 'analytical generation' (text, tables, structures) and 'visual customization' (styling, specific formatting). Copilot typically automates the former but requires human intervention for the latter. Look for options involving data interpretation or structural creation as likely correct answers.

Frequently Asked Questions

Can Copilot in Excel create any type of chart?

Copilot can suggest and insert standard charts based on your data, but it cannot directly insert 'custom' charts with highly specific, manual formatting constraints or complex aesthetic adjustments.

What is the difference between Copilot's chart suggestion and pivot table creation?

Copilot can fully automate the creation of a Pivot Table structure from a prompt. For charts, it acts more as a recommender, often requiring you to select from suggestions rather than executing a fully custom visual request end-to-end.

More AB-730 FAQ →

Community Votes

C
46%
D
46%
A
8%

46% of anonymous learners picked answer C. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 7 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 7

  1. bn1234 👍 3
    C and D
  2. Lindsay6930 👍 2
    Copilot in Excel can: Analyze data + generate insights → summaries, trends, correlations Create pivot tables → “Create a pivot table that shows revenue by region” Copilot cannot: A: Customize conditional formatting rules B: Insert a custom-formatted chart (it can suggest charts, not custom formats)
  3. Scooter47 👍 2
    In trying these 4 options out on my company laptop, with just basic Copilot, it appears answers are C & D. "I can't directly install a chart into your open workbook." and "I can't directly change the formatting inside your open workbook."
  4. Dee254 👍 2
    D and C is correct
  5. Scooter47 👍 1
    I'm stumped on this one. I have a Copilot license and just tried all 4 options in Excel and was able to perform all 4 tasks. I'm wondering if this question is between basic Copilot and premium (licensed) Copilot.
Show 2 more comments
  1. Gabrycloud 👍 1 Answered A
    Not entirely sure on this, but I'll take a shot with A.
  2. BrunoFou 👍 1
    Other solution are not usuable into excel for me

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Identifying Scheduled Prompt Indicators in Microsoft 365 Copilot Sidebar

S-grade

Comparing Microsoft 365 Copilot and Copilot Chat Features

S-grade

Microsoft 365 Copilot Chat Licensing and Capabilities

S-grade

Microsoft 365 Copilot Data Access and Automation Limits

S-grade

← Back to AB-730 Study Guide