Google Sheets Test Google Sheets Syntax 2 — Questions and Answers
Question 1: Which symbol must every Google Sheets formula begin with?
- = (Correct answer)
- +
- @
- #
Correct 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?
- An absolute reference that will not change when copied (Correct answer)
- A currency format
- A relative reference
- A named range
Correct answer: An absolute reference that will not change when copied
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)?
- A comma (Correct answer)
- A semicolon
- A colon
- A period
Correct answer: A comma
In the US locale, arguments are separated by commas.
Question 4: What does the colon in the range A1:A10 represent?
- A continuous range from A1 through A10 (Correct answer)
- Division of A1 by A10
- A comparison operator
- A text separator
Correct answer: A continuous range from A1 through A10
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?
- & (Correct answer)
- +
- #
- %
Correct answer: &
The ampersand joins text values together into one string.
Question 6: How do you reference cell B2 on another tab named 'Sales'?
- =Sales!B2 (Correct answer)
- =Sales.B2
- =Sales:B2
- =B2(Sales)
Correct answer: =Sales!B2
Sheet references use the sheet name followed by an exclamation mark and the cell.
Question 7: Which symbol is used for exponentiation (raising a number to a power) in Sheets?
- ^ (Correct answer)
- **
- %
- !
Correct answer: ^
The caret symbol raises a number to a power, as in 2^3.
Google Sheets Test Google Sheets Syntax 2
Which symbol must every Google Sheets formula begin with?