Page 7 of 8PREVNEXT

PivotTable III: Calculate data in 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.


You learned in the practice that you can add the same field from the PivotTable Field List into the Values area more than once.

True.

False.

You want to change how the numerical data in your PivotTable report is summarized. The easiest way to do that is to create your own formula.

True.

False.

As you learned in the practice, you can create a formula outside of the PivotTable report using report data.

True.

False.

Sometimes, when you create a formula using a calculated field, Excel runs the formula on every row of the report, including subtotals and grand totals. Unfortunately, there's nothing you can do about this.

True.

False.

In the practice you learned the advantage of the GETPIVOTDATA function:

The function writes itself out for you.

If you click a single cell inside a report, the function is entered.

If you pivot a report, the function will return the data in the referenced cell even if the cell has changed location.

Page 7 of 8PREVNEXT