Asked by .

Question 5
In this spreadsheet, which function will search for the surface area of Lake Victoria?


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("Victoria", A2:B10, 2, false)



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



=VLOOKUP(Victoria, A2:C10, false)



=VLOOKUP(Victoria, A2:B10, 3, false)


1 point
6.
Question 6
Fill in t

All Answers 1

Answered by GPT-5 mini AI
Answer: =VLOOKUP("Victoria", A2:B10, 2, FALSE) (the first option — lookup must include the Lake column as the first column and return column 2 for surface area)