Microsoft Excel PivotTables and PivotCharts 3

Question 1

What is the GETPIVOTDATA function used for?

Accepted Answer

To retrieve a specific value from a PivotTable using field and item names

Answer

To create a new PivotTable from a formula

Answer

To delete rows from a PivotTable automatically

Answer

To convert PivotTable data into a flat table format

Question 2

What is a Timeline filter in Excel PivotTables?

Accepted Answer

A visual date filter control that lets you filter PivotTable data by dragging across time periods

Answer

A column that tracks when each record was added to the source data

Answer

A chart overlay that shows trends over time

Answer

A function that calculates elapsed time between two date fields

Question 3

How do you prevent a PivotTable's column widths from automatically resizing every time it is refreshed?

Accepted Answer

Uncheck 'Autofit column widths on update' in PivotTable Options

Answer

Protect the worksheet before refreshing

Answer

Set fixed column widths using Format > Column > Fixed Width

Answer

Apply a PivotTable style that locks column widths

Question 4

Which of the following correctly describes Grand Totals in a PivotTable?

Accepted Answer

Summary values at the bottom row and/or rightmost column that aggregate all data

Answer

Totals that appear only when a filter is actively applied

Answer

Averages displayed at the top of each column in the PivotTable

Answer

Totals calculated only for the currently visible rows

Question 5

What does 'Value Field Settings' allow you to configure for a PivotTable Values field?

Accepted Answer

The display name, summary function (Sum/Count/Average), and number format

Answer

The source data range used by the field

Answer

The sort order and custom grouping of the field

Answer

The conditional formatting rules applied to the field

Question 6

When a PivotTable is filtered using a Slicer, what happens to its associated PivotChart?

Accepted Answer

The PivotChart is automatically updated to reflect the filtered data

Answer

The PivotChart remains unchanged until manually refreshed

Answer

A warning message appears asking whether the chart should be updated

Answer

The PivotChart is disconnected from the PivotTable

Question 7

What is the purpose of grouping items in a PivotTable?

Accepted Answer

To organize items into custom categories or time periods for more meaningful analysis

Answer

To merge selected rows into a single cell

Answer

To move items to a different column in the PivotTable

Answer

To hide items without removing them from the source data