Google Sheets Test Google Sheets Formula 2

Question 1

Which function returns the number of cells in A1:A20 that contain the text "Yes"?

Accepted Answer

=COUNTIF(A1:A20,"Yes")

Answer

COUNTIF counts cells that match a single condition.

Question 2

What does =IFERROR(A1/B1,0) return when B1 is empty?

Accepted Answer

0

Answer

IFERROR replaces the division error with the specified value 0.

Question 3

Which symbol locks both the column and row in a cell reference?

Accepted Answer

$A$1

Answer

A dollar sign before both letter and number makes an absolute reference.

Question 4

What does =CONCATENATE(A1," ",B1) do?

Accepted Answer

Joins A1 and B1 with a space between them

Answer

CONCATENATE joins text values, here separated by a space.

Question 5

Which formula returns TRUE only if both A1>10 and B1>10?

Accepted Answer

=AND(A1>10,B1>10)

Answer

AND returns TRUE only when every condition is met.

Google Sheets Test Practice Test