Excel & Sheets practice: Statistical Ranking & Positions
Chapter 32 · 3 questions · included in full access
Question 1 · easy
Rank orders by revenue
Solve it in your browserRank every order by Revenue, 1 = largest. Start in K2, fill to K21.
Question 2 · medium
Conditional formatting rule
Solve it in your browserWrite the custom formula for a rule applied to
A2:I21that highlights a whole row when Revenue ≥ 35,000 and Region is North. Test it in K2 filled to K21 — it must return TRUE/FALSE, with columns pinned so it would work from any column of the row.Question 3 · easy
Reorder quantity
Solve it in your browserOn Products, return how many units must be ordered to bring Stock (E) up to the Reorder level (F) — or 0 if stock is already enough. Start in G2, fill to G8.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing