Search for courses or lessons
Redeem a coupon
Start free trial
When you drag a row field on to a PivotTable, it will sort in what order by default?
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
Ascending order from lowest letter/number at the top, to highest letter/number at the bottom
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 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
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
Assuming you have the PivotTable shown below. You right-click cell B2 and choose to Sort by Z-A (descending). What would happen?
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
Nothing would change, as the table is already arranged in that order
The columns would re-arrange to be displayed in the following order: Feb, Jan, Grand Total
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement