Excel Formulas and Data Analysis Course: final exam 2026
A new random set of 35 questions from the course every time. Score 80% or more to download your certificate. You see your answers at the end.
- 35 questions
- Score 80% or more to download your certificate.
- 35 minutes
How this mock exam works
Each attempt draws 35 questions at random from all 96 questions for this test, so no two attempts are the same.
At the end you see your score, every answer and its explanation. Your best score is saved in this browser, so you can try again until you pass comfortably.
What you will learn
- Make decisions in formulas with IF, IFS, AND, OR and NOT
- Add, count and average data that meets several conditions with SUMIFS, COUNTIFS and AVERAGEIFS
- Look up values with XLOOKUP, VLOOKUP and INDEX/MATCH, and handle missing values with IFERROR and IFNA
- Split, clean and join text, and calculate with dates and working days
- Highlight data with conditional formatting, control entries with data validation and remove duplicates safely
- Summarize data with PivotTables and choose charts that answer a business question
Score 80% or more to download your certificate.