Page 5 of 16PREVNEXT

PivotTable I: What's so great about PivotTable reports?

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.

To create a PivotTable report, what's the first step?

Open the PivotTable Wizard.

Drag and drop data from your worksheet into a PivotTable report view.

Decide what you want to know.

There's no wrong way to pivot data.



Which of these can you do with PivotTable views?

All of the below.

Analyze and summarize data.

Organize and compare data.

Page 5 of 16PREVNEXT