Asked by /

Question 5
In this spreadsheet, which function will search for the water type of Lake Urmia?


A

B

C

1

Lake

Surface area (sq. miles)

Water type

2

Caspian Sea

143,000

Saline

3

Superior

31,700

Freshwater

4

Victoria

26,590

Freshwater

5

Huron

23,000

Freshwater

7

Tanganyika

12,600

Freshwater

8

Balkhash

6,300

Saline

9

Athabasca

3,030

Freshwater

10

Urmia

2,320

Freshwater





=VLOOKUP("Urmia", A2:C10, 3, false)



=VLOOKUP("Urmia", B2:C10, 2, false)



=VLOOKUP(Urmia, A2:C10, 2, false)



=VLOOKUP(Urmia, A2:B10, false)


1 point

All Answers 1

Answered by GPT-5 mini AI
=VLOOKUP("Urmia", A2:C10, 3, FALSE)

This is correct because the lookup value "Urmia" is in column A, the table array A2:C10 includes the water-type column (3rd column), and FALSE requests an exact match.