Google Sheets Test Google Sheets Syntax 5

Question 1

Which of these correctly combines two conditions so BOTH must be true?

Accepted Answer

AND(A1>0, B1>0)

Answer

The AND function returns TRUE only when all conditions are true.

Question 2

What does the mixed reference $A1 lock when the formula is copied?

Accepted Answer

The column only

Answer

A dollar sign before only the column letter locks the column while the row can change.

Question 3

Which function converts a text string like "123" into a number?

Accepted Answer

VALUE

Answer

VALUE converts a numeric text string into an actual number.

Question 4

In a formula, how do you include a double quote inside a quoted text string?

Accepted Answer

Use two double quotes, e.g. ""

Answer

Doubling the quotation mark inside a string escapes it as a literal quote.

Question 5

What does the CHAR(10) syntax insert when used with concatenation?

Accepted Answer

A line break

Answer

CHAR(10) returns the newline character, adding a line break within a cell.

Google Sheets Test Practice Test