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.
In which area of the report can you use a calculated field formula?
The Data area.
The Row area.
The Column area.
How do you enter a calculated field formula?
On the Insert menu, click Function.
Click PivotTable on the PivotTable toolbar and then point to Formulas.
On the Data menu, click PivotTable and PivotTable Chart Report.
In the practice, you learned how to turn automatic subtotals off. First, you click in the field in which you want to turn the subtotals off. Then, you:
Click PivotTable on the PivotTable toolbar.
Right-click and click Group and Show Detail.
Click Field Settings on the PivotTable toolbar.
You cannot create formulas outside of the report, using PivotTable data.
True.
False.
