Google Sheets Test Google Sheets Formula 4

Question 1

What does =AVERAGEIF(A1:A10,">50") calculate?

Accepted Answer

The average of values greater than 50

Answer

AVERAGEIF averages only the cells meeting the criterion.

Question 2

Which formula returns the number of non-empty cells in A1:A100?

Accepted Answer

=COUNTA(A1:A100)

Answer

COUNTA counts all non-empty cells, including text.

Question 3

What does =LEFT("Google",3) return?

Accepted Answer

Goo

Answer

LEFT extracts the first 3 characters from the text.

Question 4

Which function removes extra spaces from a text string?

Accepted Answer

=TRIM(A1)

Answer

TRIM removes leading, trailing, and duplicate spaces.

Question 5

What does =LEN(A1) return?

Accepted Answer

The number of characters in A1

Answer

LEN returns the length (character count) of the text.

Google Sheets Test Practice Test