Google Sheets Test Google Sheets Formula 2 — Questions and Answers
Question 1: Which function returns the number of cells in A1:A20 that contain the text "Yes"?
- =COUNTIF(A1:A20,"Yes") (Correct answer)
- =SUMIF(A1:A20,"Yes")
- =COUNT(A1:A20,"Yes")
- =COUNTA(A1:A20)
Correct answer: =COUNTIF(A1:A20,"Yes")
COUNTIF counts cells that match a single condition.
Question 2: What does =IFERROR(A1/B1,0) return when B1 is empty?
- 0 (Correct answer)
- #DIV/0!
- A1
- An empty string
Correct answer: 0
IFERROR replaces the division error with the specified value 0.
Question 3: Which symbol locks both the column and row in a cell reference?
- $A$1 (Correct answer)
- A$1
- $A1
- A1
Correct answer: $A$1
A dollar sign before both letter and number makes an absolute reference.
Question 4: What does =CONCATENATE(A1," ",B1) do?
- Joins A1 and B1 with a space between them (Correct answer)
- Adds A1 and B1 numerically
- Counts characters in A1 and B1
- Splits A1 by spaces
Correct answer: Joins A1 and B1 with a space between them
CONCATENATE joins text values, here separated by a space.
Question 5: Which formula returns TRUE only if both A1>10 and B1>10?
- =AND(A1>10,B1>10) (Correct answer)
- =OR(A1>10,B1>10)
- =IF(A1>10,B1>10)
- =BOTH(A1>10,B1>10)
Correct answer: =AND(A1>10,B1>10)
AND returns TRUE only when every condition is met.
Question 6: What does =ROUND(3.14159,2) return?
- 3.14 (Correct answer)
- 3.142
- 3
- 3.15
Correct answer: 3.14
ROUND with 2 decimal places gives 3.14.
Question 7: Which function returns today's date and updates automatically?
- =TODAY() (Correct answer)
- =NOW("date")
- =DATE()
- =CURRENT()
Correct answer: =TODAY()
TODAY() returns the current date and recalculates each day.
Google Sheets Test Google Sheets Formula 2
Which function returns the number of cells in A1:A20 that contain the text "Yes"?