NEW
Font size
WorksheetsGoogle Sheets Basics Quiz
Total questions: 25
Worksheet time: 13mins
What symbol do all formulas in Google Sheets begin with?
$
+
=
@
What is a cell reference?
A way to name text
A way to name a cell using its column and row
A formula
A math function
What is the reference for the top-left cell in a Google Sheet?
A0
A1
1A
Cell A
What is a range in Google Sheets?
A cell’s name
A function
A group of adjacent cells
A math operator
How is a range written?
A1,A2,A3
A1:A2
Range(A1-A2)
A1::A2
What is the range for the rectangle from cell A1 to B2?
A1:B2
A1-A2-B1-B2
A1, B2
A1:B1
What function adds up numbers or ranges?
=ADD
=TOTAL
=SUM
=PLUS
What is the result of =SUM(2, 3, 4)?
7
8
9
10
What happens if you type A1,A2,A3 without a function?
It works
It adds them
It gives a #VALUE! error
It gives a #ERROR!
What data type is TRUE or FALSE?
Text
Logic
Boolean
Numeric
Which of these is considered text?
"123"
123
=123
1 + 2
How are numbers aligned in a default cell?
Left
Center
Right
Bold
Which of these is NOT a valid mathematical operator in Sheets?
+
-
^
#
What does =4^2 return?
6
8
16
32
What operator is used to join two text strings?
+
&
^
~
What does ="Hello"&"World" display?
Hello World
HelloWorld
"HelloWorld"
Error
What logic operator means “not equal to”?
!=
NOT
<>
^=
What will =IF(1=2, "Yes", "No") display?
Yes
No
TRUE
FALSE
What will =IFS(A1>A2, "Greater", A1=A2, "Equal", A1
Greater
Equal
Less
Error
What does =COUNTIF(A1:A10, ">100") do?
Counts cells with values over 100
Counts cells with values under 100
Adds all numbers
Averages A1:A10
Which formula joins first and last names with a space?
=A1+B1
=JOIN(" ",A1,B1)
=A1&" "&B1
=MERGE(A1,B1)
What function checks if two cells are equal and returns “Match” or “No Match”?
=EQUALS
=IF
=CHECK
=COMPARE
What is the default alignment for text in a cell?
Left
Right
Center
Top
What does =AVERAGEIF(B1:B10, "<1500") do?
Finds average of numbers under 1500
Finds the largest number
Averages all numbers
Sums numbers under 1500
What does =SUM(B2:D6) do?
Sums B2 and D6 only
Gives an error
Sums everything in the B2 to D6 block
Multiplies cells
