Excel Quiz: Test Your Knowledge
Pick a category, choose a topic and answer 5 quick questions. You see the answer, and the reason, after every question.
EXCEL QUIZ3 topics
Excel Basics
Cells, rows, columns, sheets and the parts of the screen.
15 questionsStart →
EXCEL QUIZ12 topics
Formulas & Functions
SUM, IF, VLOOKUP, text functions and the maths behind them.
60 questionsStart →
EXCEL QUIZ2 topics
Shortcuts
The keys that save you time every day. (Excel on Windows.)
10 questionsStart →
EXCEL QUIZ1 topic
Formatting
Wrap text, merge cells, colours and the Format Painter.
5 questionsStart →
EXCEL QUIZ1 topic
Sorting, Filtering & Lists
Sort, filter and drop-down lists.
5 questionsStart →
EXCEL QUIZ1 topic
Data Cleaning
Extra spaces, duplicates and splitting names.
5 questionsStart →
EXCEL QUIZ1 topic
Dates & Times
TODAY, NOW, YEAR, MONTH and date maths.
5 questionsStart →
EXCEL QUIZ1 topic
Charts
Which chart to pick, and how to make it fast.
5 questionsStart →
EXCEL QUIZ1 topic
Pivot Tables & Tables
Summarise big data in a few clicks.
5 questionsStart →
EXCEL QUIZ1 topic
Fixes & Errors
What do #DIV/0!, #N/A and ###### really mean?
5 questionsStart →
EXCEL QUIZ1 topic
Print, Share & Protect
Fit on one page, repeat headers, lock a sheet.
5 questionsStart →
EXCEL QUIZ1 topic
Import, Export & Convert
CSV, PDF and the file types Excel uses.
5 questionsStart →
EXCEL QUIZ1 topic
Macros & VBA
Record steps once, replay them forever.
5 questionsStart →
