Back to lesson
1. How would you change the value of the Sales $ column of a PivotTable from Sum to Average?
Right click any cell within a Sales $ column in the PivotTable, choose Value Field Settings, and select Average.
Double click the value in the PivotTable, choose Value Field Settings, and select Average.
Right click the header for the Sales $ column in the PivotTable, choose Value Field Settings, and select Average.
2. When you drag the Sales Units column to the Values area of your PivotTable it shows up as “Count of Sales Units”. What is the most likely cause?
The Sales Units column of the source data is formatted as text.
There is at least one text value somewhere in the Sales Units column of the source data.
Someone has already defined a Count of Sales Units column on the PivotTable and that format is being forced on the newly added column.
3. How many times can we use the same field in the Values area of a PivotTable?
As many as we like.
Once per aggregation type.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement