Excel Formulas Quiz Generator
Make an Excel formulas quiz on a small sample sheet: what a formula returns, which formula gets a given result, and why one fails. Pick the functions and level; every question has its answer explained.
- Free
- No sign-up to try
- Works as you type
What you'll get
Make an interactive Excel formulas quiz built on a small sample sheet, with:
- a small sample sheet shown as a table with column letters and row numbers
- multiple-choice questions on that sheet: what a formula returns, which formula gets a given result, why a formula fails
- formulas written exactly as typed in Excel, starting with =
- the right answer and a short explanation for each question
- a score at the end and what to review next
Written by AI from your answers when you create it: read it through before you use it.
Free, no sign-up to try. Your quiz becomes a Room you can edit, publish and share.
How it works
How the Excel Formulas Quiz Generator works
- 1
Answer a few questions
Say what it's about and who it's for.
- 2
WZRD writes it
WZRD's AI writes it from your answers in about a minute.
- 3
Check and share
Read it through, edit anything in the Room, then share one link.
Worked example
What it makes
Make an interactive Excel formulas quiz built on a small sample sheet, with:
- a small sample sheet shown as a table with column letters and row numbers
- multiple-choice questions on that sheet: what a formula returns, which formula gets a given result, why a formula fails
- formulas written exactly as typed in Excel, starting with =
- the right answer and a short explanation for each question
- a score at the end and what to review next
Written by AI from your answers when you create it. Read it through before you use or share it.
Who it's for
Who uses it
Office trainers
Check a group after a spreadsheet skills session.
Managers
Help new starters practise the formulas your team's reports use.
Learners
Practise lookups and IF statements before a job test.
Good to know
What to consider
- AI works out the formula results: check any answer by typing the formula into the sample sheet in Excel.
- Functions differ between versions: XLOOKUP isn't in Excel 2019 or earlier, and Google Sheets has some differences. Name your version in the functions box.
Questions
About the Excel Formulas Quiz Generator
Does it work for Google Sheets?
Mostly: the common functions behave the same. Write "Google Sheets" in the functions box and the questions will stick to functions Sheets has.
Who writes the content?
WZRD's AI writes it from your answers when you create it, so every one is different. Read it through before you use or share it: AI can make mistakes. You can edit everything in the Room.
Make your quiz now
Free, no sign-up to try. It becomes a Room you can edit, publish and share.
Create my quizRelated
Related tools
- SQL Quiz GeneratorMake SQL practice questions on a small sample table: what a query returns, which query answers a question, and what's wrong with a broken one. Each comes with the answer and why, in your SQL dialect.
- Percentage Quiz GeneratorMake a percentages practice quiz: percent of a number and what percent one number is of another, with worked solutions and three difficulty levels.
- Quiz GeneratorGive a topic or upload your material. Get an interactive quiz as one link: questions, instant answers and explanations, with an AI tutor that helps people understand what they got wrong.