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

Manually re-arrange the items on each PivotTable you create.

Answer 6

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

Answer 7

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

Answer 8

Don’t know

Answer 9

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

Answer 10

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

Answer 11

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 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?