Spreadsheets
Unscored tasks with hints and instant feedback. Practice results never become credentials.
Short lesson
XLOOKUP(key, lookup_range, return_range) replaces VLOOKUP. SUMIFS/COUNTIFS give pivot-style summaries. Use $A$1 for fixed references.
In D8 calculate the total of all order amounts with a formula.
Sign up to practiseIn F2 count how many orders are above 1,000 using a formula. In E2:E7 calculate amount including 20% VAT, using the rate in F1 with an absolute reference so the formula can be filled down.
Sign up to practiseYou copy =B2*C1 from D2 down to D3. What formula appears in D3?
Sign up to practiseFill B2:B6 with each customer's region from the table in D:E, using XLOOKUP (or INDEX/MATCH).
Sign up to practiseBuild a summary: in G2:G4 the regions EU, US, APAC are listed. In H2:H4 calculate total revenue per region with formulas (a pivot-style summary).
Sign up to practiseRemove duplicate contacts (same email) and fix the names: trim extra spaces and use proper capitalisation (“Cleo Park”). Keep the header row. You may use the Remove duplicates tool, helper columns, or edit cells.
Sign up to practiseIn G2 calculate Q2 revenue for the EU region only, and in G3 the number of Q1 deals above 650. Use SUMIFS / COUNTIFS.
Sign up to practiseIn E2:E9 compute each deal's commission: 5% for revenue under 800, 8% from 800 to 1,199, 10% from 1,200. Use one formula filled down (IFS or nested IF).
Sign up to practise