Microsoft Excel PivotTables and PivotCharts 1

Question 1

What is a PivotTable in Microsoft Excel?

Accepted Answer

An interactive tool that summarizes large data sets into a compact, organized format

Answer

A chart type that rotates around a central axis

Answer

A table with locked cells that cannot be edited

Answer

A table that automatically converts data to percentages

Question 2

Which tab in Excel's ribbon is used to insert a PivotTable?

Accepted Answer

Insert

Answer

Home

Answer

Data

Answer

Formulas

Question 3

Which of the following is NOT one of the four field areas in the PivotTable Fields pane?

Accepted Answer

Headers

Answer

Rows

Answer

Values

Answer

Filters

Question 4

What default summary function does the Values area use for numeric fields in a PivotTable?

Accepted Answer

SUM

Answer

COUNT

Answer

AVERAGE

Answer

MAX

Question 5

What does refreshing a PivotTable do?

Accepted Answer

Updates the PivotTable to reflect changes in the source data

Answer

Deletes all filters applied to the PivotTable

Answer

Converts the PivotTable to a regular table

Answer

Resets the PivotTable layout to the default

Question 6

What is a Slicer in Microsoft Excel?

Accepted Answer

A visual filter control that provides clickable buttons for filtering PivotTable data

Answer

A keyboard shortcut for filtering data

Answer

A function that splits text into separate cells

Answer

A tool that removes duplicate rows from a PivotTable

Question 7

What happens when you double-click a value cell in a PivotTable?

Accepted Answer

Excel drills down and creates a new sheet showing the underlying detail records

Answer

The value is highlighted for editing

Answer

A dialog box opens to change the value

Answer

The cell is merged with adjacent cells