Google Sheets Formula Flashcards
7 cards from real Google Sheets Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Google Sheets Formula flashcards as text
What does the ARRAYFORMULA function allow you to do?
Answer: Apply a formula across an entire range at once
ARRAYFORMULA processes a range and returns results across multiple cells.
Which function pulls live data from another Google Sheet by its URL?
Answer: =IMPORTRANGE(url, range)
IMPORTRANGE imports a specified range from another spreadsheet.
What does =QUERY(A1:C10,"SELECT A WHERE B > 100") do?
Answer: Returns column A rows where column B exceeds 100
QUERY uses SQL-like syntax to filter and return matching data.
Which formula splits "a,b,c" into separate cells by the comma?
Answer: =SPLIT("a,b,c",",")
SPLIT divides text into separate cells using the given delimiter.
What does =TEXTJOIN("-",TRUE,A1:A3) return if the cells hold 1, blank, 3?
Answer: 1-3
With TRUE, TEXTJOIN ignores empty cells, joining 1 and 3 with a hyphen.
Which formula returns a random whole number between 1 and 10?
Answer: =RANDBETWEEN(1,10)
RANDBETWEEN returns a random integer within the given bounds.
What does =FILTER(A1:A10,B1:B10>5) return?
Answer: Only A values where the matching B value exceeds 5
FILTER returns the rows of the range that meet the condition.
How this page was made: written with AI tools. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy