Continents Excel Project

Continents
Project Description:
In this problem, you will investigate the area and populations of the 7 continents. You will also provide the results as a pie chart.

1) Start Excel. Download and open the workbook named: Chapter_2-6_Continents_Start
2) In cell B14, calculate the total land area in square kilometers.
3) In cell C14, calculate the total land area in square miles.
4) In cell D6, calculate the ratio of Asia continent area in square kilometers to the total land area in square kilometers. Fill cell D6 down the column to cell D12. Format cells D6:D12 as Percentage with 1 decimal place.
5) In cell E14, calculate the total population of the world.
6) In cell F6, calculate the ratio of Asia continent population to the total population of the world. Fill cell F6 down the column to cell F12. Format cells F6:F12 as Percentage with 1 decimal place.
7) In cell G6, calculate the population density (people per square kilometer) for Asia continent. Fill cell G6 down the column to cell G12. Format cells G6:G12 as Number with 1 decimal place.
8) In cell H6, calculate the population density (people per square mile) for Asia continent. Fill cell H6 down the column to cell H12. Format cells H6:H12 as Number with 1 decimal place.
9) In cell B31, calculate the ratio of Asia continent area in square kilometers to North America continent area in square kilometers. To calculate other ratios of Asia's statistics to North America's statistics in cells C30:H30, fill cell B31 across columns C-H. Format cells B31:H31 as Number with 2 decimal places.
10) In cell H35, determine how many times Asia continent land is larger than North America continent land. Note: Enter your answer as a whole number.
11) In cell H37, determine how many times Asia population is larger than North America population. Note: Enter your answer as a whole number.
12) In cell H39, determine how many times Asia population density is larger than North America population density. Note: Enter your answer as a whole number.
13) In cells D16:I29, insert a Pie Chart of the continents' populations. Select ranges A6:A12 and E6:E12, on the Insert tab, click Recommended Charts, and then click Pie. Apply Style 6 on the Design tab. Add a chart title above the chart axis titles. Replace Chart Title with Populations. Click Quick Layout and choose Layout 6.

Questions
The area and populations of the 7 continents is given (World Population Prospects, the 2010 Revision. United Nations Department of Economic and Social Affairs. 28 June 2011. Retrieved 24 October 2011).
(Per linked individual article definitions, North America includes UN population estimates for North America, Central America and Caribbean; Australia includes Australia and Papua New Guinea.)
a.) Compute the total land area in km2 and miles2.
b.) Compute the part-to-whole ratio for each continent's area and format as a percentage.
c.) Compute the total population of the world.
d.) Compute the part-to-whole ratio for each continent's population and format as a percentage to one decimal place.
e.) For each continent, compute the ratio of population (of the continent) to area (of the continent). This is called population density, people per square kilometer and people per square mile. Format as a number with one decimal place.
f.) For each row in the table, compute the ratio of Asia's statistic to North America's statistic, and scale the second quantity to 1. Format each entry to two decimal places.
g.) Asia has how many times as much land as North America? Simply enter a whole number, rounding off one of the numbers you just computed.
h.) Asia has how many times as many people as North America? Simply enter a whole number rounding off one of the numbers you just computed.
i.) Asia is how many times as dense as North America? Simply enter a whole number rounding off one of the numbers you just computed.
j.) Make a pie chart of the continents' populations. Ensure to include the following:
a. Title: Populations
b. Legend
c. Percentages for each pie section displayed on the pie chart