Day 12 — 12 practice questions
Everything from the first eleven days. Try each one before you open the answer.
How to use this page
Each question shows a working formula. Read the question, write your own answer first, then run the box to compare. Getting a different formula that produces the same number is a good sign, not a bad one.
Every formula on this page runs against the Sales sheet below. The row numbers and column letters are real — F2 really is 165000.
1. Total revenue
What is the total of every amount?
2. Average order, rounded
The average amount, with no decimal places.
3. Orders above 100,000
How many orders were worth more than 100,000?
4. Revenue for one region
Total amount for the East region.
5. Two conditions at once
Total amount for Laptops sold in the West.
6. Label each order
Mark order 1004 as "Bulk" if the quantity is 10 or more, otherwise "Standard".
7. A three-way grade
Grade order 1009: 200,000 and above is A, 100,000 and above is B, anything else is C.
8. Look up a value
Find the product for order 1013 — without using VLOOKUP.
9. Look leftwards
Find the order ID of the first Mouse sale.
10. A month total
Total revenue for March 2025.
11. Share of total, formatted
What percentage of revenue came from Laptops, to one decimal place?
12. Clean and split a name
On the Raw sheet, pull a properly capitalised first name out of the messy column A.
This lesson uses the Raw sheet below — deliberately messy, the way exported data really arrives.
Where to go next
You now have the formula half of Advanced Excel. The parts that need the real application — PivotTables, Power Query, charts, macros and VBA — are what the classroom course covers, and there are free video lessons for several of them on the courses page.
The SQL tutorial is the natural next step: the same grouping and filtering ideas, on data too big for a spreadsheet.
Try these yourself
- Redo question 5 with SUMPRODUCT instead of SUMIFS and confirm you get the same number.
- Find the largest single order and the region it came from.
- Count how many distinct products appear in column D.
- Total the revenue for the first quarter of 2025.
- Work out the average price per unit across the whole sheet.