Step by step on how to compute this excel with cell formulas for each.
fx V B D E G H K Continents b.) d.) e.) Percent of Percent of Density Density Total Total People per 5 Continent Area (km ) Area (mile ) People per Landmass Population Asia 43,820,000 16,920,000 4,164,252,000 Population km mile Most Populous City Africa 30,370,000 11,730,000 1,022,234,000 Shanghai, China 8 North America 24,490,000 9,460,000 Lagos Nigeria 9 542,056,000 South America 17,840,000 6,890,000 Mexico 392,555,000 City, Mexico Sao 10 Antarctica 13,720,000 Paulo, 5,300,000 Brazil 4,490 11 Europe 10,180,000 3,930,000 738,199,000 Australia 9,008,500 3,478,200 Moscow, Russia 12 29,127,000 13 a.) Sydney, Australia a.) c. 14 Totals 15 16 17 j.) 18 19 20 21 22 23 24 25 26 27 28 29 Percent of Percent of Density Density Total Total People per People per 30 Area (km) Area (mile ) Population 31 Landmass mile Asia Population km 32 f.) 33 North America - .. 34 H . - .. 35 36 g.) Times as much land: 37 h. ) 38 Times as many people: 39 40 Times as dense: 41 42 43 44 45 46 47 48 49 50fx V A B 6 Stens to Perform: 7 Step Instructions Po 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. 10 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 12 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. 13 In cell F6, calculate the ratio of Asia continent population to the total population of the world. Fill cell F6 down the 14 6 column to cell F12. Format cells F6:F12 as Percentage with 1 decimal place 15 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 16 column to cell H12. Format cells H6:H12 as Number with 1 decimal place In cell B31, calculate the ratio of Asia continent area in square kilometers to North America continent area in 9 square kilometers. To calculate other ratios of Asia's statistics to North America's statistics in cells C30:H30, fill 17 cell B31 across columns C-H. Format cells B31:H31 as Number with 2 decimal places. 18 In cell H35, determine how many times Asia continent land is larger than North America continent land. 10 19 20 Note: Enter vour answer as a whole number. In cell H37, determine how many times Asia population is larger than North America population. 21 11 22 23 Note: Enter vour answer as a whole number. In cell H39, determine how many times Asia population density is larger than North America population density. 24 12 25 26 Note: Enter vour answer as a whole number. In cells D16:129, insert a Pie Chart of the continents' populations. Select ranges A6:A12 and E6:E12, on the Insert 13 tab, click Recommended Charts, and then click Pie. Apply Style 6 on the Design tab. Add a chart title above the 27 chart axis titles. Replace Chart Title with Populations. Click Quick Layout and choose Layout 6. 29
