Google Sheets Test Google Sheets Syntax 2

Question 1

Which symbol must every Google Sheets formula begin with?

Accepted Answer

=

Answer

Every formula starts with an equals sign to tell Sheets to evaluate it.

Question 2

In the reference $A$1, what does the dollar sign before both the column and row indicate?

Accepted Answer

An absolute reference that will not change when copied

Answer

Dollar signs lock both the column and row so the reference stays fixed when copied.

Question 3

What separates arguments inside a function in the US locale, such as SUM(A1,B1)?

Accepted Answer

A comma

Answer

In the US locale, arguments are separated by commas.

Question 4

What does the colon in the range A1:A10 represent?

Accepted Answer

A continuous range from A1 through A10

Answer

A colon defines a range spanning all cells between the two references.

Question 5

Which operator is used to concatenate (join) two text strings in a formula?

Accepted Answer

&

Answer

The ampersand joins text values together into one string.

Google Sheets Test Practice Test