Google Sheets Test Google Sheets Formula 3

Question 1

Which formula looks up "Apple" in column A and returns the matching value from column C?

Accepted Answer

=VLOOKUP("Apple",A:C,3,FALSE)

Answer

VLOOKUP searches column A and returns column 3 (C) with an exact match.

Question 2

What does the FALSE argument in VLOOKUP request?

Accepted Answer

An exact match

Answer

FALSE (or 0) forces VLOOKUP to require an exact match.

Question 3

Which formula sums B1:B10 only where A1:A10 equals "North"?

Accepted Answer

=SUMIF(A1:A10,"North",B1:B10)

Answer

SUMIF checks the range, matches the criterion, then sums the sum_range.

Question 4

What does =INDEX(A1:A10,3) return?

Accepted Answer

The 3rd value in A1:A10

Answer

INDEX returns the item at the given position within a range.

Question 5

Which function finds the position of "Blue" within the range A1:A5?

Accepted Answer

=MATCH("Blue",A1:A5,0)

Answer

MATCH returns the relative position of a value in a range.

Google Sheets Test Practice Test