Google Sheets Test Google Sheets Syntax 3

Question 1

What must text values be wrapped in when typed directly inside a formula?

Accepted Answer

Double quotation marks

Answer

Literal text in a formula must be enclosed in double quotes.

Question 2

Which comparison operator means 'not equal to' in a Sheets formula?

Accepted Answer

<>

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?

Accepted Answer

Apply a formula across an entire range at once

Answer

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?

Accepted Answer

A:A

Answer

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?

Accepted Answer

A leading space before the equals sign breaks the formula

Answer

A leading space before the equals sign causes Sheets to treat the entry as text, not a formula.

Google Sheets Test Practice Test