Excel quiz: 72 questions

72 questions from the 18 lessons of Excel: From Beginner to Advanced. Each answer is explained, with a link back to the lesson it comes from, and your best score stays on this device.

Test yourself

72 questions from this course's lessons, in a random order. See what you remember, then go back to the lessons behind the questions you missed.

How many questions?

What the quiz covers

  1. The Excel window, workbooks and navigation (4 questions)
  2. Entering and editing data (4 questions)
  3. Formatting cells and number formats (4 questions)
  4. Formulas and operators (4 questions)
  5. Relative, absolute and mixed references (4 questions)
  6. SUM, AVERAGE, COUNT and conditional totals (4 questions)
  7. IF, AND, OR, IFS and handling errors (4 questions)
  8. Text functions (4 questions)
  9. Dates and times (4 questions)
  10. Lookups: VLOOKUP, XLOOKUP and INDEX with MATCH (4 questions)
  11. Sorting, filtering and Excel Tables (4 questions)
  12. Conditional formatting and data validation (4 questions)
  13. Charts and sparklines (4 questions)
  14. PivotTables (4 questions)
  15. What-if analysis: Goal Seek, data tables and scenarios (4 questions)
  16. Dynamic arrays, LET and LAMBDA (4 questions)
  17. Power Query: getting and cleaning data (4 questions)
  18. Protecting, printing and sharing workbooks (4 questions)