Practice Test GeeksPractice Test Geeks
← All Microsoft Excel Flashcard Decks

Excel Pivot Charts Flashcards

12 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 12 Excel Pivot Charts flashcards as text

  1. What is the main difference between a PivotChart and a standard Excel chart?

    Answer: A PivotChart is linked to a PivotTable and updates as fields change

    PivotCharts are bound to PivotTable data and include interactive field buttons.

  2. Which ribbon tab contains the command to insert a PivotChart?

    Answer: Insert

    PivotChart is in the Charts group on the Insert tab.

  3. In the PivotChart Fields pane, fields placed in the Axis (Categories) area correspond to which PivotTable area?

    Answer: Rows

    Axis categories map to Row fields in the underlying PivotTable.

  4. Which chart type is NOT available for a PivotChart?

    Answer: XY Scatter

    Scatter, bubble, and stock charts cannot be created as PivotCharts.

  5. What do the gray buttons displayed on a PivotChart allow you to do?

    Answer: Filter, sort, and expand fields directly on the chart

    Field buttons provide interactive filtering and sorting without touching the PivotTable.

  6. What happens to a PivotChart when the underlying PivotTable is deleted?

    Answer: The chart becomes a static regular chart with the last data

    Without its PivotTable, the chart converts to a standard chart with fixed data.

  7. Which tool lets you add clickable buttons that filter both a PivotTable and its PivotChart at the same time?

    Answer: Slicer

    Slicers provide visual filters connected to one or more PivotTables and their charts.

  8. To display Sales by Region as separate lines over Month on a PivotChart, where should the Region field be placed?

    Answer: Legend (Series)

    Each series in a chart comes from the Legend area, which maps to Columns.

  9. Which feature adds interactive date-based filtering with a draggable time range to a PivotChart?

    Answer: Timeline

    A Timeline slicer filters PivotTables and PivotCharts by date periods.

  10. New records were added to the source table of a PivotChart, but the chart has not changed. What should you do?

    Answer: Click Refresh on the PivotChart Analyze tab

    PivotCharts do not update until the PivotTable cache is refreshed.

  11. Which option in PivotTable Options makes a PivotChart automatically reflect changes when the workbook is opened?

    Answer: Refresh data when opening the file

    This setting on the Data tab of PivotTable Options refreshes the cache at file open.

  12. You want to show only the five best-selling products on a PivotChart. Which filter should you apply to the Product field?

    Answer: Value Filter > Top 10 set to 5 items

    Top 10 value filters can be adjusted to any number of items by sum of a value field.

How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

  1. learn.microsoft.com — Retake policy, test delivery, time limit, eligibility · verified Oct 2026
  2. certiport.pearsonvue.com — Exam format, score validity, passing score, score release, exam information · verified Oct 2026