Home › Quizzes › Quiz Makers & AI Tools › Excel Quiz Generator

Turn your Excel notes into a practice quiz in minutes

Upload a lecture deck, a chapter or your class notes on formulas, functions and shortcuts. Get questions with explanations so you can check what you actually remember.

Create quizzes nowFree · No credit card required

Drop files here or browsePDF, DOCX, PPTX, text or photos of your notes · several files with Plus

Free · First set needs no signup · Creates quizzes in seconds

Why practice Excel with questions instead of rereading

Studying spreadsheets from a lecture deck often means reading formulas without ever testing yourself on them. DeckOwl works as an Excel quiz generator: upload your slides or notes and it writes questions about functions, cell references and shortcuts, each with an explanation.

Questions are drawn from your own course material
Explanations show why the right answer is correct
Multiple-choice, true/false and short-answer formats
Free plan includes 3 generations per month to start

Example Excel formula practice questions

What does the fourth argument of VLOOKUP set to FALSE do?It requests an exact match instead of an approximate one. Exact match is the safer choice for unsorted lookup tables.

What does =SUM(A1:A5) return when every cell in A1 to A5 contains text?It returns 0. SUM ignores text values, whereas adding the cells with + would return a #VALUE! error.

What is the difference between A1 and $A$1 when you copy a formula?A1 shifts relative to its new position, while $A$1 stays fixed. The dollar signs anchor the reference so it does not change when copied.

Which function counts only the cells that contain numbers: COUNT or COUNTA?COUNT. COUNTA counts every non-empty cell, including cells that contain text.

What happens when you press F4 while editing a cell reference?It cycles through the absolute and relative forms of that reference. This is faster than typing dollar signs by hand.

Generate the full set

Multiple-choice, true/false and short answer

Pick the question style that fits your study session. Each question comes with an explanation of the correct answer.

Built from your own material

Questions come from the PDF, slides, DOCX or notes you upload, so the quiz matches your course rather than a generic list.

Study in the browser

The free plan includes 3 generations per month you can study right away, with no credit card needed to start.

How it works

Upload your notes

Add a PDF, PPTX, DOCX, plain text file or a photo of a page from your Excel course.

Choose the question types

Select multiple-choice, true/false or short-answer questions, then generate the quiz.

Answer and review

Work through the questions, read the explanation for each one, and retry the ones you missed.

Questions are most useful when they make you predict a result, such as what a formula returns or why a reference changed when copied. Start with the free plan to try a few sets. Exports to PDF or DOCX are available on Plus, and Moodle XML export is on Pro.

Explore related topics

Quiz Maker Excel Template Alternative

Skip the blank spreadsheet. Generate quiz questions with explanations from your notes.

Excel Quiz Maker from Your Notes

Build Excel practice quizzes from your notes, slides or PDFs, with explanations included.

Free MCAT Practice Test Answers

Build MCAT practice questions and explanations from your own notes, PDFs or slides.

Online quiz maker: how it works

How an AI online quiz maker works, which question types it makes, and when a paid plan is worth it.

AI Math Quiz Generator

Upload math notes or PDFs and get practice quizzes with answers and explanations.

Adaptive AI Exam Generator

Practice exam questions from your notes, with explanations for every answer.

Adobe Acrobat Online Quiz Maker

Turn Acrobat training PDFs and slides into quizzes with explanations.

Adobe Quiz Maker from Your Notes

Turn Adobe course PDFs, slides and notes into AI quizzes with explanations and exports.

Frequently asked questions

How should I practice Excel formulas with a quiz?

Predict the result of each formula on sample data before checking the answer. Retype the formulas you missed from memory a day later to make them stick.

Which Excel topics work well for quiz questions?

Functions such as SUM, COUNT and VLOOKUP, cell reference types, and keyboard shortcuts work well because each has a clear correct answer.

Does the free plan include quizzes?

Yes, the free plan gives you 3 generations per month that you can study in the browser. Exports are not included on the free plan.

Can I export an Excel quiz to Word or Moodle?

DOCX export is included on Plus at $39/year or $7.99/month. Moodle XML export is included on Pro at $14.99/month.

Generate free quizzes

Keep exploring the topic

Review the main ideas visually or practice recalling them.