Question: 01/10
Lives: 3 lives left
Score: 0000
Best: --

Excel Pivot Pop

A messy sales table and one question. Drag fields into Rows, Columns and Values to build the pivot table that answers it.

Excel Pivot Pop

Pip & Pine, a made-up home shop, dumps a messy list of orders on you with one question: which region sold the most, how many Rugs went to the South? Drag Month, Region, Product, Units and Revenue into Rows, Columns and Values, pick Sum, Count or Average, and build the pivot table that answers it. Then tap the cell with the answer.

10 questions
Pivot tables

How to play

Read the question. A fresh, unsorted sales table each round, and one question about it.
Build the pivot. Drag fields into Rows, Columns and Values, or tap a field then a box. Keyboard: Enter on a field, then R, C or V.
Pick the maths. Values can Sum, Count or Average. Tap the button under the field to switch. One field per box.
Score. 100 for a right layout, up to 50 for speed and a streak bonus, then +50 for tapping the cell with the answer. A wrong layout or the clock costs one of 3 lives.

Quick tips

Find the grouping word. "Which region…", "per month", "for each product": the field after which or per goes in Rows.
Count the orders. "How many orders" means Count. Count counts rows, so any field in Values works.
Average is per order. "Biggest average order" means Average: each group's total divided by its number of orders.
Two fields, a grid. When a question names two things, like a product and a region, put one in Rows and one in Columns. Either way round is fine.
Ignore the totals. The Grand Total row and column sum everything. The answer sits inside the grid.