You work for a golf course and frequently create PivotTables where you want to see your departments sorted into the following order from top to bottom: Green Fees, Retail, Rentals, Food & Beverage, Maintenance, General & Admin. How should you set up your sorting to be most efficient?

Answer 1

Create a custom list with the items displayed in the order you’d like to see them

Answer 2

Add the departments to the PivotTable, but sort them by the department number

Answer 3

Manually re-arrange the items on each PivotTable you create

Answer 4

Don’t know

Answer 5

Create a custom list with the items displayed in the order you’d like to see them

Answer 6

Manually re-arrange the items on each PivotTable you create

Answer 7

Add the Product Names to the PivotTable, but sort them by the product number

Answer 8

Don’t know

Answer 9

Select the range of cells > Formulas > Defined Names > Create from selection

Answer 10

Go to File > Options > Advanced > General > Edit Custom Lists > NEW LIST > click in the Import list from cells box and select the list of products

Answer 11

Go to File > Options > Advanced > General > Edit Custom Lists > NEW LIST > enter the list manually

Answer 12

Don’t know

You have a list of product names in cells A1:A10 of a worksheet, sorted in a non-alphabetical order. You’d like to use this sort order for all of your PivotTables. How would you do this?