Google Sheets Syntax 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 Syntax flashcards as text
Which function syntax correctly looks up a value: VLOOKUP(search_key, range, index, [is_sorted])?
Answer: VLOOKUP(search_key, range, index, is_sorted)
VLOOKUP takes the search key first, then the range, the column index, and an optional sort flag.
What does the # in a spilled reference like A1# indicate in newer Sheets syntax?
Answer: It refers to the entire spilled array range
The hash after a cell reference points to the whole array that spilled from it.
In an IF statement IF(logical_expression, value_if_true, value_if_false), what is the second argument?
Answer: The value returned when the condition is true
The second argument is the result returned if the logical test evaluates to true.
Which syntax correctly uses a wildcard to match any characters in functions like COUNTIF?
Answer: An asterisk *
The asterisk acts as a wildcard matching any sequence of characters.
How do you escape a literal wildcard character so it is treated as plain text?
Answer: Precede it with a tilde ~
A tilde before a wildcard tells Sheets to treat it literally.
What is the correct QUERY function clause keyword to filter rows?
Answer: WHERE
QUERY uses SQL-like syntax, and WHERE filters rows by condition.
In INDEX(range, row, column), what does the third argument specify?
Answer: The column offset within the range
The third argument of INDEX identifies which column to return.
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