Back to lesson
1. What characteristics are required in the source data to create a PivotTable?
A list or table with values in it.
The data is housed in an Excel table or covered by a named range.
A contiguous data range with headers.
2. How do you remove an item from a PivotTable?
Right click the item in the field list and select Remove.
Delete it from the source data, and then refresh the PivotTable.
Drag it back from the Pivot fields into the field well.
3. Suppose you change something in your source data. What are the implications?
You must close your workbook and re-open it to get the PivotTable to update.
You must manually refresh your PivotTable in order to see the change show up there.
The PivotTable will update automatically.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement