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

$1$ point

$=$VLOOKUP$($Victoria$,$ A$2$:C$10,$ false$)$

$=$VLOOKUP$($Victoria$,$ A$2$:B$10,3,$ false$)$

$=$VLOOKUP$("$Victoria$",$ B$2$:C$10,2,$ false$)$

$=$VLOOKUP$("$Victoria$",$ A$2$:B$10,2,$ false$)$