MTH 154 Earth Excel update

xlsx

School

Northern Virginia Community College *

*We aren’t endorsed by this school

Course

154

Subject

Geography

Date

Feb 20, 2024

Type

xlsx

Pages

4

Uploaded by ChancellorBison2771

Report
Name Titile Date Minh Thao Nguyen Earth Excel 2/27/2023 Continent Total Area (square km) Percentage of Land Asia 43,820,000 29.3% Europe 10,180,000 6.8% Africa 30,370,000 20.3% North America 24,490,000 16.4% South America 17,840,000 11.9% Australia 9,008,500 6.0% Antarctica 13,720,000 9.2% Total Land: 149,428,500 Oceans Total Area (square km) Percentage of Ocean Pacific 155,557,000 46.4% Atlantic 76,762,000 22.9% Indian 68,556,000 20.4% Southern 20,327,000 6.1% Arctic 14,056,000 4.2% Total Ocean: 335,258,000 Earth surface in sq. km Square Miles Earth: 484,686,500 Pie Chart Table Region Percentage of Earth Asia 9.0% Europe 2.1% Africa 6.3% North America 5.1% South America 3.7% Australia 1.9% Antarctica 2.8% Pacific 32.1% Atlantic 15.8% Indian 14.1% Southern 4.2% Arctic 2.9% One thing that I found very useful in excel is anchoring a cell in a formula. It helps a lot when I need to use a formula and fill them in multiple cell. It helps me to quickly fill formula for multiple cell without edit the cell that need to be anchor. The area covered by (Continents: https:/ http://www.worldat a.) Compute the to continent is of the to b.) Compute the to continent is of the to c.) Compute the tot d.) Compute the pe cell references in you e.) Create a well lab Atlantic 16% In 1
y each of the Earth’s oceans and by each of the continents is given //en.wikipedia.org/wiki/Continent Oceans: tlas.com/aatlas/infopage/oceans.htm ). otal area covered by land. Compute the percentage each otal land area. Format as percentage to 1 place. otal area covered by oceans. Compute the percentage each otal land area. Format as percentage to 1 place. tal area of Earth in square kilometers. ercentage each continent and ocean is of the entire Earth, using ur formulas. Format as percentage to 1 place. beled pie chart of this table. Asia 9% Europe 2% Africa 6% North America 5% South America 4% Australia 2% Antarctica 3% Pacific 32% ndian 14% Southern 4% Arctic 3% Regions percentage
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help