PivotTables and PivotCharts Flashcards

What is a PivotChart in Excel?

Answer: A chart linked to a PivotTable that dynamically updates when the PivotTable changes

A PivotChart is directly linked to a PivotTable and automatically updates when the PivotTable is filtered, changed, or refreshed.

Which of the following is NOT a standard date grouping option available in PivotTables?

Answer: Decades

Excel's built-in date grouping options include Seconds, Minutes, Hours, Days, Months, Quarters, and Years — Decades is not an available option.

What does the 'Show Values As' option allow you to do in PivotTable Value Field Settings?

Answer: Calculate values relative to other data, such as % of Grand Total or Running Total

Show Values As enables you to display values as % of Grand Total, Running Total, Difference From, and other comparative calculations.

What is a calculated field in a PivotTable?

Answer: A new field created using a formula within the PivotTable itself, not present in the source data

A calculated field is a custom field defined by a formula inside the PivotTable using existing fields as inputs, without modifying the source data.

Which keyboard shortcut is used to refresh a PivotTable?

Answer: Alt+F5

Alt+F5 refreshes the active PivotTable, updating it to reflect any changes in the source data.

What does the Report Layout option control in a PivotTable?

Answer: How the PivotTable is visually displayed — Compact, Outline, or Tabular form

Report Layout changes the PivotTable's visual display format among Compact Form (default), Outline Form, and Tabular Form.

How can you connect a single Slicer to filter multiple PivotTables simultaneously?

Answer: Use the Report Connections option from the Slicer tab or right-click menu

The Report Connections option lets you connect one Slicer to multiple PivotTables so they all filter at the same time.