Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
What characteristics are required in the source data to create a Pivot Table?
A list or table with values in it
A contiguous data range with headers
The data is housed in an Excel table or covered by a named range
How do you remove an item from a Pivot Table?
Drag it back from the Pivot fields into the field well
Delete it from the source data, and then refresh the Pivot Table
Right click the item in the field list and select Remove
Suppose you change something in your Pivot Table's source data. What are the implications?
You must close your workbook and re-open it to get the Pivot Table to update
The Pivot Table will update automatically
You must manually refresh your Pivot Table in order to see the change show up there