MTH 154 Earth Excel update
xlsx
keyboard_arrow_up
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
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