How this works. Click
Generate quiz to draw one random question from each of the four question types:
- Type 1 — Descriptive Statistics: mean, median, standard deviation, percentiles
- Type 2 — Conditional Functions & Lookups: COUNTIF, SUMIF, AVERAGEIF, XLOOKUP, IF
- Type 3 — PivotTables: build PivotTables and answer questions from them
- Type 4 — Charts: histograms, box plots, and time-series line charts
Download the dataset, work through the questions in Excel, then click
Reveal answer to check yourself.
Datasets (same data, two shapes):
rm_yields_1990plus.csv (wide) — one crop per column. Use for descriptive stats & lookups (Types 1, 2, 4).
rm_yields_1990plus_long.csv (long) — crop in its own column. Use for PivotTables (Type 3), to group by crop.
Import with Data → Get Data → From Text/CSV, not by double-clicking. Blank cells mean a crop was not grown/reported — leave them blank. Lentils are in lb/ac; all other crops in bu/ac.