Google Sheets
0Loading crowd target
0Loading crowd target
7correct to beat the crowd
40 free Google Sheets trivia questions with answers — science & nature quiz, new questions added Oct 2026.
Google Sheets looks simple: a grid, a few menus and a blinking cursor. Behind that grid sits a spreadsheet used every day in classrooms and offices, with a long list of built-in functions and a history that goes back to a small startup's web experiment. This quiz checks how well you really know it. The questions cover everyday formulas and what they return, the symbols that hold a formula together, error messages, tools for tidying and summarising data, sharing and collaboration, keyboard shortcuts, and where the app came from. It suits high school and college students learning spreadsheets, teachers looking for a ready-made class quiz, and office workers who want to test their skills. Every question comes with the answer and a short explanation, so you pick up a new trick even when you miss one.
30 of 40 questions with answers and explanations. Play the quiz
Q 01In the Google Sheets function VLOOKUP, what does the letter V stand for?
Vertical
Vertical is the word, because the search runs down a column, while the sister function HLOOKUP does the same job horizontally across the top row.
Q 02Google Sheets can open and edit .xlsx files, the native format of which rival spreadsheet program?
Microsoft Excel
Microsoft Excel still treats 1900 as a leap year, a long-standing bug that Google Sheets quietly corrects in its own date system.
Q 03In the Google Sheets formula =GOOGLETRANSLATE(A2,"en","ko"), which language does the code "ko" request?
Korean
Korean is the target here, because the function reads its codes in order, source first and target second, and "auto" lets it detect the source language itself.
Q 04Google Sheets labels its first 26 columns A to Z, so which label does the very next column carry?
AA
AA comes next, then AB, AC and onwards: once the single letters run out, spreadsheet column labels simply double up.
Q 05Which Google app for building surveys and quizzes can save every response to a linked Google Sheets file?
Forms
Forms can create a fresh response spreadsheet in one click, and Sheets automatically arranges the incoming answers in a table.
Q 06Which command in the Google Sheets View menu pins a header row so that it stays visible while scrolling?
Freeze
Freeze works on columns as well as rows, so a first column of names can stay put while everything else slides sideways.
Q 07Typing which short web address into a browser instantly creates a blank Google spreadsheet?
sheets.new
Typing sheets.new works because Google runs the whole .new domain as a set of shortcuts, and meet.new starts a video meeting the same way.
Q 08Google Sheets can be automated with Apps Script, whose code is written in which programming language?
JavaScript
JavaScript powers Apps Script, which began as a side project by Mike Harm while he was working as a developer on Sheets itself.
Q 09Google Sheets can open .csv files, a plain-text table format whose three letters stand for which phrase?
Comma-separated values
Comma-separated values files are so plain that the IMPORTDATA function can pull one into a sheet straight from a web address.
Q 10A student types =SUM(2,3,4) into an empty Google Sheets cell; which number appears there?
9
9 is the total, because SUM adds up whatever sits inside its brackets, and it can take a whole block of cells at once, as in =SUM(A1:A7).
Q 11Which Google Sheets function, given the numbers 1, 2 and 9, returns 2 as the middle value?
MEDIAN
MEDIAN lines the numbers up and takes the one in the centre, so one huge outlier barely moves it, whereas AVERAGE would return 4 for the same three numbers.
Q 12Which Google Sheets function counts only the cells that meet a condition, such as scores above 50?
COUNTIF
COUNTIF takes a range and a test, and the test can use wildcards: a question mark stands for any single character and an asterisk for any run of them.
Q 13Which Google Sheets function, written with empty brackets, returns the current date and time?
NOW
NOW is a volatile function, meaning it updates on every edit made to the spreadsheet, while its calmer sibling TODAY returns the date alone.
Q 21Which Google Sheets feature recolours a cell whose value meets a rule, such as falling below zero?
Conditional formatting
Conditional formatting can also shade a whole column as a colour scale, tinting each cell according to where it falls between a minimum and a maximum.
Q 22Which Google Sheets feature lets editors browse a file's earlier states, name them and restore one?
Version history
Version history comes with a catch in Sheets: restoring an earlier version clears the cell-by-cell edit history for changes made before the restore.
Q 23What does Google Sheets call a recorded series of actions that a keyboard shortcut can replay?
Macro
Q 14Which Google Sheets function draws a miniature chart that fits entirely inside one cell?
SPARKLINE
SPARKLINE draws a line graph by default but can switch to bars, columns or a win-loss chart, which plots two outcomes like a run of coin tosses.
Q 15Which Google Sheets function runs SQL-like commands such as "select A where B > 5" over a table?
QUERY
QUERY runs Google's Visualization API Query Language, which borrows clauses such as select, where, group by and order by, so one formula can filter, sort and total a table.
Q 16Which Google Sheets function strips stray spaces from the start and end of imported text?
TRIM
TRIM matters because spaces in front of or after text are significant in formulas, so two entries that look identical can refuse to match until one is tidied.
Q 17Which Google Sheets function capitalises each word, turning "ada lovelace" into "Ada Lovelace"?
PROPER
PROPER is the tidy-up for names typed in a hurry, whereas UPPER converts the whole string to capitals and LOWER does the reverse.
Q 18Which Google Sheets function shows "Pass" or "Fail" depending on a test such as A1>50?
IF
IF takes a test followed by two results, the first shown when the test is true and the second when it is false, so =IF(A1>50,"Pass","Fail") grades a score in a single formula.
Q 19Which Google Sheets function pulls cells in from a separate spreadsheet, identified by its URL?
IMPORTRANGE
IMPORTRANGE must be granted permission before it works: the first time one spreadsheet pulls from another, the user is prompted to allow access.
Q 20Which Google Sheets tool, added from the Insert menu, summarises a large data set by grouping it?
Pivot table
A pivot table can reveal, for example, which salesperson produced the most revenue in a given month, without a single formula being typed.
A macro saves time on repetitive tasks, and behind the scenes Google Sheets stores each one as an Apps Script that can be edited by hand.
Q 24Which Google Sheets sharing role lets a person leave remarks on cells but not change the data?
Commenter
Commenter access can be tightened further still: a file's owner can stop commenters and viewers from downloading, printing or copying it.
Q 25Strangers who open a Google Sheets file through a public link are shown as anonymous what?
Animals
Animals stand in for every viewer who was not invited individually, while people who were invited by name show up under their own names.
Q 26Which Google Sheets toolbar tool copies one cell's fonts and colours onto other cells?
Paint format
Paint format normally switches off after one use, but double-clicking the button keeps it on so the same look can be pasted in several places.
Q 27What does Google Sheets call a function placed inside another, as SUM is in =ABS(SUM(A1:A7))?
Nested
Nested is Google's term, and the innermost function is always calculated first, with its result handed to the function that surrounds it.
Q 28On a PC, the Google Sheets shortcut Ctrl+Shift+V pastes which part of whatever cells were copied?
Values only
Values only pastes just the text from the original cells, so the result of a calculation arrives as a plain number, without the formula behind it.
Q 29Which Google Sheets screen offers ready-made budgets and other Google-made files to start from?
Template gallery
The template gallery never hands over the original: choosing a design opens a copy, so the master stays untouched for the next person.
Q 30Which symbol, typed before a column letter or row number, locks a Google Sheets cell reference?
Dollar sign
The dollar sign makes a reference absolute, so $A$1 always points at the same cell, while a plain A1 shifts along as the formula is copied elsewhere.