Google Sheets Test Cheat Sheet 2026

The 30 highest-yield Google Sheets Test facts, distilled from real exam questions. Print it, save it as a PDF, or study it here — free, no sign-up.

1. Which symbol is used for exponentiation (raising a number to a power) in Sheets? → ^
2. What does the AVERAGEIF function do in Google Sheets? → Returns the average of cells that meet a specified condition
3. In QUERY, which clause sorts the returned results? → ORDER BY
4. Can you protect an entire sheet while leaving certain cells editable? → Yes, by adding exceptions for specific cells
5. Which symbol must every formula in Google Sheets begin with? → =
6. Which function removes non-printable characters from a text string in Google Sheets? → CLEAN()
7. How can you delete a chart from a Google Sheet? → Select it and press Delete, or use the three-dot menu > Delete chart
8. What does the HARMEAN function calculate in Google Sheets? → The harmonic mean of a set of positive numbers
9. Which formula flags cells where the text length exceeds 10 characters? → =LEN(A1)>10
10. To make conditional formatting reference another sheet's value, what must you use inside the custom formula? → An INDIRECT or a range imported to the same sheet
11. What is the purpose of freezing a row in Google Sheets? → Keep it visible while scrolling
12. To require a cell contain only a valid email address, which criterion is used? → Text is valid email
13. To ensure that users can only enter a customer satisfaction score from 1 to 5 (inclusive) in column F, which is the most direct data validation rule to apply? → Criteria: Number, between, 1 and 5.
14. Which chart is designed specifically to visualize a single value against a target range using colored bands? → Gauge chart
15. What does 'Publish to the web' do for a Google Sheet? → Creates a public web page or embeddable link of the sheet's content
16. When you copy =A1+B1 from row 1 down to row 2, what does it become? → =A2+B2
17. Which formula converts text in A1 to all uppercase letters? → =UPPER(A1)
18. What does the MONTH() function return for the date December 15, 2025? → 12
19. A calculated field named Margin uses ='Profit'/'Revenue'. Why might it show errors for some rows? → Revenue could be zero, causing division by zero
20. What does 'Suggesting' behavior look like in Google Sheets compared to Google Docs? → Sheets has no full Suggesting mode; suggestions are made via comments
21. What does a custom formula rule of =ISODD(ROW()) accomplish when applied to a range? → Highlights alternating (odd) rows for a banded look
22. Which syntax correctly references a named range called 'Taxes' in a formula? → =SUM(Taxes)
23. What does =LEN(A1) return? → The number of characters in A1
24. When using the `QUERY` function in Google Sheets, how do you refer to columns within the query string argument when the data range is A1:F50? → By using their column letter identifiers (e.g., A, B, C)
25. When recording, choosing 'Relative references' means the macro will: → Act on cells relative to your current selection
26. A validation rule set to 'Reject input' with criterion 'Number between 1 and 10' does what when 15 is entered? → Rejects the entry and keeps the old value
27. What does the green funnel/filter icon on a column header indicate? → A filter condition is currently applied to that column
28. What does =FILTER(A1:A10,B1:B10>5) return? → Only A values where the matching B value exceeds 5
29. Which function is generally preferred over VLOOKUP because it can look both left and right of the search column? → INDEX/MATCH
30. Which function returns the position of an item within a range? → MATCH