
Google Sheets Trivia Questions
Explore the spreadsheet app behind shared budgets, data charts, and collaborative projects. Test your knowledge of its formulas, features, and place in Google’s productivity tools.
Google Sheets trivia questions and answers
Which function totals the numbers in a specified range of cells?
Show answerHide answer
SUM
You can give SUM individual values, cell references, or whole ranges, and combine several ranges in one formula.
What kind of cell reference uses dollar signs to keep its row and column fixed when a formula is copied?
Show answerHide answer
Absolute reference
A reference such as $A$1 locks both parts; pressing F4 while editing a reference can cycle through reference styles.
Which function searches down the first column of a range and returns a value from a specified column in the matching row?
Show answerHide answer
VLOOKUP
The V in the function name refers to vertical lookup; its search key must be in the range’s first column.
What is the name for the box at the intersection of a spreadsheet row and column?
Show answerHide answer
Cell
Each cell is identified by a reference made from its column letter and row number, such as C5.
In the cell reference D12, what does the number identify?
Show answerHide answer
Row
Spreadsheet cell references put the column label before the row number.
How to play
- • Each game has 10 questions. Before each one you see only a hint about its topic.
- • Choose what it’s worth, from $1 to $20. Each value can only be used once per game.
- • Type your answer. Small spelling mistakes are fine. Get it right and you win that amount.

