Microsoft Excel PivotTables and PivotCharts 2

Question 1

What is a PivotChart in Excel?

Accepted Answer

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

Answer

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

Question 2

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

Accepted Answer

Decades

Answer

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

Question 3

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

Accepted Answer

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

Answer

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

Question 4

What is a calculated field in a PivotTable?

Accepted Answer

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

Answer

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

Question 5

Which keyboard shortcut is used to refresh a PivotTable?

Accepted Answer

Alt+F5

Answer

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

Excel Practice Test