Page 15 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.


You create a PivotTable view of your data by dragging fields from the PivotTable Field List:

True

False

What are PivotTable fields?

Column information from the source data.

The PivotTable report layout area.

The area where you pivot data.

To see sales amount figures totaled, into which drop area would you drag that field?

Drop Column Fields Here

Drop Row Fields Here

Drop Data Items Here

You have names in your data, and you want to see each name on a row. Into which drop area would you drag that field?

Drop Column Fields Here

Drop Row Fields Here

Drop Data Fields Here

In the practice, you learned how to determine which fields are already displayed in the report: they are shown in bold letters on the PivotTable Field List.

True

False

Page 15 of 16PREVNEXT