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
What must text values be wrapped in when typed directly inside a formula?
Answer: Double quotation marks
Literal text in a formula must be enclosed in double quotes.
Which comparison operator means 'not equal to' in a Sheets formula?
Answer: <>
Google Sheets uses the less-than/greater-than pair to mean not equal.
In the ARRAYFORMULA syntax, what does it allow a formula to do?
Answer: Apply a formula across an entire range at once
ARRAYFORMULA applies one formula to a whole range instead of a single cell.
What is the correct syntax to reference an entire column A?
Answer: A:A
Repeating the column letter with a colon references the whole column.
Which character combination begins a comment or is NOT valid syntax to start a formula?
Answer: A leading space before the equals sign breaks the formula
A leading space before the equals sign causes Sheets to treat the entry as text, not a formula.
How is a decimal number correctly written in a US-locale formula?
Answer: Using a period, e.g. 3.14
In the US locale, decimals use a period as the separator.
What does wrapping a function name in another function, like SUM(FILTER(...)), demonstrate?
Answer: Nesting functions
Placing one function inside another is called nesting.
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