Question

Am confused on this question, part B said to go by the total land, but the different formula I found online said to divide, any ideas. am so lost.

AutoSave on gtq1eU 4 10 Earthxlsx -Excel File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Trace PrecedentsShow Formulas Error Checking Define Name Calculate Now Watch Calculation Calculate Sheet % use in Formula new Trace Dependents nsert AutoSum Recently Financial Logical Text Date &Lookup & Math & MoreName Time Reference Trig Functions Manager Create from Selection Remove ArrowsEvaluate Formula Window Options Function Library Defined Names Formula Auditing D6 FU 03 0.621371 miles The area covered by each of the Earth's oceans and by each of the continents is given (Continents: https://en.wikipedia.org/wiki/Continent Oceans: http://www.worldatlas.com/aatlas/infopage/oceans.htm) 3 Continent Total Area (square km) Total Area (square miles)Percentage of Land 4 Asia 43,820,000 10,180,000 30,370,000 24,490,000 17,840,000 9,008,500 13,720,000 27228477.2 6325556.78 18871037.2 15217375.79 11085258.64 5597620.654 8525210.12 62.1 62.1% 62.1% 5 Europe 6 Africa 7 North America 8 South America 9 Australia 10 Antarctica 11 Total Land: 12 a.) Compute the total area covered by land. Convert the areas of continents and the total land area to square miles using the km to miles conversion given on the sheet. Compute the percentage each continent is of the total land area. Format as percentage to 1 place. b.) Compute the total area covered by oceans. Convert the areas of oceans and the total ocean area to square miles using the km to miles conversion given on the sheet. Compute the percentage each continent is of the total land area. Format as percentage to 1 place 13 Oceans Total Area (square km) Total Area (square miles) Percentage of Ocean 14 Pacifi 15 Atlantic 16 Indian 17 Southern 18 ArctiC 19 Total Ocean: 20 155,557,000 76,762,000 68,556,000 20,327,000 14,056,000 c.)Compute the total area of Earth in both square kilometers and square miles. 22 Earth: d.) Compute the percentage each continent and ocean is of the entire Earth #10 Earth Ready + 100% 10:41 PM 3/21/2019 0E

Answer 1

To calculate the total area covered by oceans(in km), add the area of Pacific, Atlantic, Indian, Southern and Arctic.

In cell B19, write =B14+B15+B16+B17+B18 and you will get 335258000 (in km).

Now to find the area of oceans in miles, multiply 0.621371 with the respective area in km (the reason behind it is we use the unitary method, 1km= 0.621371miles then 5km=5*0.621371 miles). Again to calculate the total area covered by oceans (in miles), add the area of Pacific, Atlantic, Indian, Southern and Arctic.

In cell C19, write =C14+C15+C16+C17+C18 and you will get 208319598.7 (in MILES).

Now to find the percentage of the ocean,

percentage of the ocean=

area of ocean total area 100

Calculations are shown in the picture below.

Home Insert Page Layout ぬCut Ea Copy Data Review View Calibri Paste B | U▼睦1 Or▼▲▼ 還遲国Merge & Cente te Format Painter Clipboard Font Alignment 120 1km= 0.621371 miles 4 oceans t e(square km) total area(square miles) Percentage of ocean 5 pacific 6 atlantic 7 indian 8 southern 9 arctic 10 total ocean 155557000 76762000 68556000 20327000 14056000 335258000 96658608.65 47697680.7 42598710.28 12630608.32 8733990.776 208319598.7 46.39919107 22.89639621 20.44872904 6.063091708 4.192591974