FREE SKILLS PRACTICE · NO ACCOUNT REQUIRED
Excel Intermediate Practice
Practise lookup logic, conditional summaries and checking spreadsheet data. Formula examples use English names and commas. XLOOKUP requires a supported modern Excel version; functions and separators vary by application.
What you practise and receive
- Lookups and references — Create five product codes and prices. Check an exact lookup for a matching code and a missing code; explain the difference between a row reference and a fixed range.
- Conditional summaries — Build six fictional sales rows. Compare SUMIFS and COUNTIFS, then check a filtered total with SUBTOTAL against the visible source rows.
- Data checks — Make a small table with a duplicate row, an ordinary extra space and a date. Check how each cleaning action changes the original records before applying it.
12 original questions, three topic scores, worked explanations for every answer, a free practice guide and optional progress saved on your device. Every question has equal weight. No compulsory timer.
This original 12-question practice set describes only the sampled questions. It is not a validated proficiency level, aptitude percentile, language certificate or hiring recommendation. All examples and data are fictional. Your temporary server session and result expire after 24 hours. No name or email is requested.