FREE CES PivotTables & Data Manipulation Questions and Answers

Question 1

What is a PivotTable used for in Excel?

Accepted Answer

To summarize and analyze large datasets

Answer

To create charts.

Answer

To filter data only.

Answer

To create formulas.

Question 2

How can you refresh a PivotTable after the source data is updated?

Accepted Answer

By clicking the 'Refresh' button

Answer

By deleting the PivotTable and recreating it.

Answer

By manually updating each cell.

Answer

By exporting the data.