Excel & Data Literacy Practice Test
Twenty-five original questions on the spreadsheet skills employers actually test: relative and absolute references, the formulas worth knowing cold, lookups with VLOOKUP and XLOOKUP, pivot tables, picking the right chart, cleaning messy data, and reading a statistic without being misled by it. Scored instantly, with a breakdown by topic and an explanation for every answer.
For information and self-assessment only, to help you prepare. Always refer to the official certifying body's own materials and content outline as the source of record.
Official body: Microsoft ↗ — publisher of the Microsoft Office Specialist: Excel Associate certification
What it covers
25 questions across 7 topics, scored by topic so you can see where the gaps are rather than just how many you missed:
- Cell references
- Core formulas
- Lookups
- Pivot tables
- Charts
- Data cleaning
- Reading data critically
Ready when you are
25 questions, about 25 minutes. Nothing is sent anywhere — the whole thing runs in your browser, and no account is needed.
Frequently asked questions
Is this the Microsoft Office Specialist exam?
No. Every question is written from scratch to cover the areas an entry-level spreadsheet certification and most employer skills tests cover. Reproducing questions from a real exam would breach copyright and the candidate agreement. It would also miss the point, because spreadsheet competence is about choosing the right approach rather than recalling a menu path.
What score suggests I know the fundamentals?
Seventy percent is the threshold used here, though an even spread across topics tells you more. The common pattern is strong formula skills alongside no pivot table experience, which averages to a respectable score and falls apart on the first real task. That is why results break down by topic rather than into one number.
How long does it take, and what should I do afterward?
About twenty-five minutes at roughly a minute per question. Afterward, open a real spreadsheet and rebuild whichever topic you scored worst on, because spreadsheet skills fade quickly when they are only read about. Retaking this a week later measures whether the practice stuck, which rereading the explanations does not.
Does this apply to Google Sheets as well as Excel?
Almost entirely. References, the core functions, pivot tables and chart choices work the same way in both, and where the names differ the question says so. XLOOKUP is the main exception, since availability depends on the version you have; the VLOOKUP questions cover the approach that works everywhere. Data literacy is tool-independent.