GoSkills
Back to lesson
Question
1
of
3
1. 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. 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?
Create a custom list with the items displayed in the order you’d like to see them.
Manually re-arrange the items on each PivotTable you create.
Add the Product Names to the PivotTable, but sort them by the product number.
Don’t know
3. 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 > enter the list manually.
Select the range of cells > Formulas > Defined Names > Create from selection.
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.
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement