Excel Expert
Unscored tasks with hints and instant feedback. Practice results never become credentials.
Short lesson
Specialist exams combine several L4–L5 tasks under time pressure; practise the hardest tasks of the base module first.
In G2:G4 (regions EU, US, APAC in F2:F4) return the rep with the highest single deal in that region. Formulas only.
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 practiseB1 holds starting monthly revenue (10,000) and B2 the monthly growth rate (4%). In B4:B15 build revenue for months 1–12 (month 1 = starting revenue), and in B17 the 12-month total.
Sign up to practise