Google Sheets Test Google Sheets Syntax 3 — Questions and Answers
Question 1: What must text values be wrapped in when typed directly inside a formula?
- Double quotation marks (Correct answer)
- Parentheses
- Square brackets
- Single dashes
Correct answer: Double quotation marks
Literal text in a formula must be enclosed in double quotes.
Question 2: Which comparison operator means 'not equal to' in a Sheets formula?
- <> (Correct answer)
- !=
- =/=
- ><
Correct answer: <>
Google Sheets uses the less-than/greater-than pair to mean not equal.
Question 3: In the ARRAYFORMULA syntax, what does it allow a formula to do?
- Apply a formula across an entire range at once (Correct answer)
- Sort a column automatically
- Convert text to numbers
- Freeze a header row
Correct answer: Apply a formula across an entire range at once
ARRAYFORMULA applies one formula to a whole range instead of a single cell.
Question 4: What is the correct syntax to reference an entire column A?
- A:A (Correct answer)
- A1:A
- A*
- AllA
Correct answer: A:A
Repeating the column letter with a colon references the whole column.
Question 5: Which character combination begins a comment or is NOT valid syntax to start a formula?
- A leading space before the equals sign breaks the formula (Correct answer)
- Starting with =
- Starting with +
- Starting with -
Correct 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.
Question 6: How is a decimal number correctly written in a US-locale formula?
- Using a period, e.g. 3.14 (Correct answer)
- Using a comma, e.g. 3,14
- Using a slash, e.g. 3/14
- Using a colon, e.g. 3:14
Correct answer: Using a period, e.g. 3.14
In the US locale, decimals use a period as the separator.
Question 7: What does wrapping a function name in another function, like SUM(FILTER(...)), demonstrate?
- Nesting functions (Correct answer)
- Absolute referencing
- Range chaining
- Comment syntax
Correct answer: Nesting functions
Placing one function inside another is called nesting.
Google Sheets Test Google Sheets Syntax 3
What must text values be wrapped in when typed directly inside a formula?