Proctor-Arns_Chapter_4-9_Earth_Start (1).xlsx

Earth Project De In this proble Use a cell re Steps to P Step 1 2 3 4 5 6 7 8 9 10 11 12

escription: em, you will investigate the area of the continents and oceans. You will also provide the results as a pie chart. eference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not recei Perform: Instructions Start Excel. Download and open the workbook named: Chapter_4-9_Earth_Start In cell B14, calculate the total area of land in square kilometers. Format cell B14 as Number with 0 decimal places and with commas. In cell C7, convert the total area of the Asia continent to square miles. Fill cell C7 down the column to cell C14. Format cells C7:C14 as Numb In cell D7, calculate the ratio of the Asia continent area to the total land area. Fill cell D7 down the column to cell D13. Format cells D7:D13 as In cell B23, calculate the total area of the oceans in square kilometers. Format cell B23 as Number with 0 decimal places and with commas. In cell C18, convert the total area of the Pacific ocean to square miles. Fill cell C18 down the column to cell C23. Format cells C18:C23 as Nu In cell D18, calculate the ratio of the Pacific ocean area to the total ocean area. Fill cell D18 down the column to cell D22. Format cells D18:D In cell B25, calculate the total area of the Earth in square kilometers. Fill cell B25 across column C. Format cells B25:C25 as Number with 0 d In cell B30, calculate the ratio of the Asia continent area to the total area of the Earth. Fill cell B30 down the column to cell B36. Format cells B In cell B37, calculate the ratio of the Pacific ocean area to the total area of the Earth. Fill cell B37 down the column to cell B41. Format cells B Save your file and submit for grading. In cells D32:I46, insert a Pie Chart to show how much area each continent or ocean occupies in relation to the total area of Earth. Select rang Charts, and then click Pie. Apply Style 6 on the Design tab. Add a chart title and choose the Above Chart option. Replace Chart Title with Per Layout 1. Add the legend and choose the Right option.

0 4 6 6 4 6 6 6 6 6 4 0 54 Points Possible

Earth Use a cell reference or a single formula where appropriate in order to recei 1 km = 0.621371 a.) Continent Total Area (square km) Total Area (square miles) Asia 44,579,000 27,700,098 Europe 10,180,000 6,325,557 Africa 30,370,000 18,871,037 North America 24,709,000 15,353,456 South America 17,840,000 11,085,259 Australia 8,600,000 5,343,791 Antarctica 14,000,000 8,699,194 Total Land: 150,278,000 93,378,391 b.) Oceans Total Area (square km) Total Area (square miles) Pacific 168,723,000 65,144,274 Atlantic 85,133,000 32,870,015 Indian 70,560,000 27,243,351 Southern 21,960,000 8,478,798 Arctic 15,558,000 6,006,974 Total Ocean: 361,934,000 139,743,412 Earth: 512,212,000 233,121,803 d.) Pie Chart Table Region Percentage of Earth Asia 11.9% Europe 2.7% Africa 8.1% e.) North America 6.6% South America 4.8% Australia 2.3% Antarctica 3.7% Pacific 27.9% Atlantic 14.1% Indian 11.7% Southern 3.6% Arctic 2.6%

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