Explore BrainMass

Explore BrainMass

    Earth Excel

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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 ad1c9bdddf
    https://brainmass.com/math/algebra/earth-excel-650290

    Attachments

    Solution Summary

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

    $2.49

    ADVERTISEMENT