Google Sheets Fundamentals 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 100 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
- Create, name, organize and import spreadsheets, including CSV files
- Enter data and apply number formats, custom formats and autofill
- Write formulas with SUM, AVERAGE, COUNT, MIN, MAX, ROUND and absolute references
- Use IF, COUNTIF, SUMIF, IFERROR, VLOOKUP and XLOOKUP to answer questions about data
- Sort and filter data, add dropdowns and highlight rows with conditional formatting
- Make a chart, share a file with the right role, use comments and restore an earlier version
Score 80% or more to download your certificate.