Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In this spreadsheet, which function will search for the surface area of Lake Huron? A B C 1 Lake Surface area ( sq . miles

In this spreadsheet, which function will search for the surface area of Lake Huron?
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("Huron", B2:C10,2, false)
=VLOOKUP("Huron", A2:B10,2, false)
=VLOOKUP(Huron, A2:C10, false)
=VLOOKUP(Huron, A2:B10,3, false)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Database Systems For Integration Of Media And User Environments 98

Authors: Yahiko Kambayashi, Akifumi Makinouchi, Shunsuke Uemura, Katsumi Tanaka, Yoshifumi Masunaga

1st Edition

9810234368, 978-9810234362

More Books

Students also viewed these Databases questions