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.
What the quiz covers
- The Excel window, workbooks and navigation (4 questions)
- Entering and editing data (4 questions)
- Formatting cells and number formats (4 questions)
- Formulas and operators (4 questions)
- Relative, absolute and mixed references (4 questions)
- SUM, AVERAGE, COUNT and conditional totals (4 questions)
- IF, AND, OR, IFS and handling errors (4 questions)
- Text functions (4 questions)
- Dates and times (4 questions)
- Lookups: VLOOKUP, XLOOKUP and INDEX with MATCH (4 questions)
- Sorting, filtering and Excel Tables (4 questions)
- Conditional formatting and data validation (4 questions)
- Charts and sparklines (4 questions)
- PivotTables (4 questions)
- What-if analysis: Goal Seek, data tables and scenarios (4 questions)
- Dynamic arrays, LET and LAMBDA (4 questions)
- Power Query: getting and cleaning data (4 questions)
- Protecting, printing and sharing workbooks (4 questions)