# Earth Excel

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 ).

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.

c.) Compute the total area of Earth in both square kilometers and square miles.

d.) Compute the percentage each continent and ocean is of the entire Earth, using cell references in your formulas. Format as percentage to 1 place.

e.) Create a well labeled pie chart of this table.

Â© BrainMass Inc. brainmass.com March 5, 2021, 1:54 am ad1c9bdddfhttps://brainmass.com/math/algebra/earth-excel-650290

#### Solution Summary

All formulas, computations, charts and solutions are in the Excel file.