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.
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.
You can't rename a field heading.
In the practice, you learned how to delete a PivotTable report. First, you click the PivotTable report. Then, you click the _____: