Google Sheets Test Google Sheets Formulas and Basic Functions 5

Question 1

Which function returns a value from a range based on row and column numbers?

Accepted Answer

INDEX

Answer

INDEX returns the value at a given row and column position within a range.

Question 2

What does MATCH return when it finds a value in a range?

Accepted Answer

The position of the value

Answer

MATCH returns the relative position of a lookup value within a range.

Question 3

Which function returns the current date and time together?

Accepted Answer

NOW

Answer

NOW returns both the current date and time.

Question 4

What does =ARRAYFORMULA(A1:A5*B1:B5) allow you to do?

Accepted Answer

Apply a formula across an entire range at once

Answer

ARRAYFORMULA processes multiple values in a range with a single formula.

Question 5

Which function counts cells in A1:A10 that contain the text "Yes"?

Accepted Answer

=COUNTIF(A1:A10, "Yes")

Answer

COUNTIF with the criterion "Yes" counts only matching cells.

Google Sheets Test Practice Test