Back to School Sale -
Enjoy
20% off all courses with code BTS2019
Toggle navigation
GoSkills
Search for courses or lessons
Courses
For Teams
For Teams
Teach
Blog
Redeem a coupon
Start free trial
Search
Login
Quiz
1
Beginner
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?
Create a custom list with the items displayed in the order you’d like to see them.
Add the departments to the PivotTable, but sort them by the department number.
Manually re-arrange the items on each PivotTable you create.
Don’t know
2
Beginner
You work for a manufacturing company and need to create a PivotTable that displays the products you need to order. You’d like to display your products in the following order: Steel Beams, Stainless Screws, Stainless Bolts, Stainless Nuts, Stainless Washers, Zinc Anodes. How would you do this in order to ensure that the client sees the data the way you sorted it?
Manually re-arrange the items on each PivotTable you create.
Create a custom list with the items displayed in the order you’d like to see them.
Add the Product Names to the PivotTable, but sort them by the product number.
Don’t know
3
Beginner
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?
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.
Select the range of cells > Formulas > Defined Names > Create from selection.
Go to File > Options > Advanced > General > Edit Custom Lists > NEW LIST > enter the list manually.
Don’t know