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.
Gray boxes in the PivotTable report contain the totals of summarized data.
True
False
How do you update your PivotTable report if the source data changes?
Delete the report and create a new one.
Click Refresh Data.
Add the new data into the report yourself.
To count the number of individual sales made by each salesperson, you would click the button on the PivotTable toolbar.
Format Report
Field Settings
Show Detail
You can't rename a field heading.
True.
False.
In the practice, you learned how to delete a PivotTable report. First, you click the PivotTable report. Then, you click the _____:
PivotTable toolbar.
Edit menu.
Data menu.
