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 chart created from scratch without any data source

Answer

A static snapshot of a PivotTable exported as an image

Answer

A chart type that displays data in a circular pivot format

Question 2

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

Accepted Answer

Decades

Answer

Months

Answer

Quarters

Answer

Years

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

Display negative values in red font

Answer

Change the number format to currency

Answer

Show text descriptions alongside numeric values

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 field that shows automatically calculated subtotals

Answer

A field pulled from a formula-based column in the source data

Answer

A field that automatically rounds values to two decimal places

Question 5

Which keyboard shortcut is used to refresh a PivotTable?

Accepted Answer

Alt+F5

Answer

Ctrl+R

Answer

F9

Answer

Ctrl+Shift+R

Question 6

What does the Report Layout option control in a PivotTable?

Accepted Answer

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

Answer

The print orientation (portrait or landscape)

Answer

The page margins for printing the PivotTable

Answer

The number of columns displayed in the PivotTable

Question 7

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

Accepted Answer

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

Answer

Right-click the Slicer and select 'Link to All PivotTables'

Answer

Use the Slicer Settings dialog box

Answer

Hold Ctrl while dragging the Slicer to each PivotTable