Google Sheets Syntax Flashcards
7 cards from real Google Sheets Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Google Sheets Syntax flashcards as text
Which symbol must every Google Sheets formula begin with?
Answer: =
Every formula starts with an equals sign to tell Sheets to evaluate it.
In the reference $A$1, what does the dollar sign before both the column and row indicate?
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.
What separates arguments inside a function in the US locale, such as SUM(A1,B1)?
Answer: A comma
In the US locale, arguments are separated by commas.
What does the colon in the range A1:A10 represent?
Answer: A continuous range from A1 through A10
A colon defines a range spanning all cells between the two references.
Which operator is used to concatenate (join) two text strings in a formula?
Answer: &
The ampersand joins text values together into one string.
How do you reference cell B2 on another tab named 'Sales'?
Answer: =Sales!B2
Sheet references use the sheet name followed by an exclamation mark and the cell.
Which symbol is used for exponentiation (raising a number to a power) in Sheets?
Answer: ^
The caret symbol raises a number to a power, as in 2^3.
How this page was made: written with AI tools. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy