Find the top 3 sales categories for last quarter.
The result should look like this:
You should use the Rank function within each quarter, e.g. the rough formula for the beverages rank in q3 of 1994 is RANK B3 for B$3 through B$10. Hold the row’s sticky with the $ sign so that when applying this formula it will always rank within the same range of categories.
The top 3 categories were: 1 – Beverages, 2 – Dairy, 3 – Confections
The expert performance time for this task is 30 seconds. This assumes you already have the quarterly sales data in place in excel.