Page 12 of 13PREVNEXT

PivotTable I: Get started with PivotTable reports in Excel 2007

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.

After you build a PivotTable report, you can't change the layout.



What are PivotTable fields?

Columns from the source data.

The area where you pivot data.

The PivotTable report layout area.

In the PivotTable Field List, you can tell which fields are already displayed on the report.



How do you remove a field from a PivotTable report?

In the Drag fields between areas below area of the PivotTable Field list, click the arrow beside the field name, and then select Remove Field.

Right-click the field you want to remove, and then on the shortcut menu, select Remove "Field Name".

Clear the check box beside the field name in the PivotTable Field List.

All of the above.

The first field you add to a PivotTable report that does not contain numbers will automatically be added in the _____ part of the report.

Column Labels.

Report filter.

Row Labels.

As you learned in the practice, when you see a plus sign (+) beside a field, there is more detail about the field in the report.



Page 12 of 13PREVNEXT