Google Sheets Test Study Guide 2026
Everything you need to pass the Google Sheets Test exam in one place: the exam format, every topic to study, real practice questions with explanations, flashcards, and full-length practice tests. Free, no sign-up needed.
📋 Google Sheets Test Exam Format at a Glance
📚 Google Sheets Test Topics to Study (69)
✍️ Sample Google Sheets Test Questions & Answers
1. In a QUERY WHERE clause, how should a text value be enclosed?
Text literals inside the query string are wrapped in single quotes so they don't clash with the outer double quotes.
2. In a color scale, what does the 'Midpoint' setting control?
The midpoint adds an optional third color at a chosen value type such as percentile, number, or percent.
3. What does the MEDIAN function return for a dataset?
MEDIAN returns the middle value after sorting; for an even count it averages the two middle values.
4. Which chart type stacks categories to compare both totals and component parts across groups?
A stacked column chart shows segment contributions and overall totals per group.
5. Which Google Sheets function returns a number (1–7) representing the day of the week for a given date?
WEEKDAY(date, [type]) returns the day of the week as a number, with the type argument controlling which day is numbered 1.
6. To return the LAST matching value instead of the first, which XLOOKUP argument do you adjust?
search_mode -1 searches from last to first, returning the final match instead of the first.