Back to lesson
1. When you drag a row field on to a PivotTable, it will sort in what order by default?
Ascending order from lowest letter/number at the top, to highest letter/number at the bottom.
The order the data first appears in the data set.
Descending order from highest letter/number at the top, to lowest letter/number at the bottom.
2. You have two major product groups on your PivotTable: Food and Alcohol. Unhappy with Food showing up at the bottom, you manually drag it to the top of the PivotTable so it shows as below. Now the accountant adds a new major product group called “Sundries” to the source data. What will happen when you update the PivotTable?
Because you have manually overridden the sort order it will not re-sort and the new group will be added at the end of the PivotTable after the Alcohol group.
Because you have changed the sort order to Descending, it will add the Sundries group above the Food category.
Because there is new data the sort order will revert to Ascending, and the items will be displayed from top to bottom as Alcohol, Food, Sundries.
3. Assuming you have the PivotTable shown below. You right click cell B2 and choose to Sort by Z-A (Descending). What would happen?
The columns would re-arrange to be displayed in the following order: Feb, Jan, Grand Total.
Nothing would change, as the table is already arranged in that order.
The rows will resort to show the values in order from the largest number at the top to the smallest at the bottom, as per the numbers in the Jan column.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement