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 of these correctly combines two conditions so BOTH must be true?
Answer: AND(A1>0, B1>0)
The AND function returns TRUE only when all conditions are true.
What does the mixed reference $A1 lock when the formula is copied?
Answer: The column only
A dollar sign before only the column letter locks the column while the row can change.
Which function converts a text string like "123" into a number?
Answer: VALUE
VALUE converts a numeric text string into an actual number.
In a formula, how do you include a double quote inside a quoted text string?
Answer: Use two double quotes, e.g. ""
Doubling the quotation mark inside a string escapes it as a literal quote.
What does the CHAR(10) syntax insert when used with concatenation?
Answer: A line break
CHAR(10) returns the newline character, adding a line break within a cell.
Which syntax correctly references a named range called 'Taxes' in a formula?
Answer: =SUM(Taxes)
A named range is referenced simply by its name without quotes or symbols.
In IFERROR(value, value_if_error), what does the function do?
Answer: Returns the fallback if the first argument produces an error
IFERROR returns the second argument whenever the first evaluates to an error.
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