I need help with this Excel assignment. If you answer all questions correctly and follow the steps, I will leave a positive review on their profile.

Most important to remember when completing:

"Use a cell reference or a single formula where appropriate in order to receive full credit. Don't paste and copyied values or type values, because the system will not accept it as correct."

Here is the link to the drive with the assignment. Thank you so much!:

https://docs.google.com/spreadsheets/d/1t64uX9BHzrXWocUktJm2pjOwJsFRYbCL/edit?usp=sharing&ouid=113568201145949224291&rtpof=true&sd=true

Al fx Earth Use a cell reference 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 receive full credit for your answers. Continent Asia Europe Africa North America South America Australia Antarctica Total Land: Oceans Pacific Atlantic Indian Southern Arctic Total Ocean: Earth: 1km = Total Area (square km) 43,820,000 10,180,000 30,370,000: 24,490,000) 17,840,000 9,008,500, 13,720,000 0.621371 a.) Total Area (square miles) miles a.) Percentage of Land Total Area (square km) 155,557,000 76,762,000: 68,556,000 20,327,000 14,056,000 b.) Total Area (square miles) a.) b.) Percentage of Ocean d.) Pie Chart Table Region Percentage of Earth Asia Europe Africa North America South America Australia Antarctica Pacific Atlantic Indian Southern Arctic e.) b.) c) The area covered by each of the Earth's oceans and by each of the continents is given (Continents: https://en.wikipedia.org/wiki/Continent Oceans: http://www.worldatlas.com/aatlas/infopage/oceans.htm ). a.) Compute the total area covered by land. Convert the areas of continents and the total land area to square miles using the km to miles conversion given on the sheet. Compute the percentage each continent is of the total land area. Format as percentage to 1 place. b.) Compute the total area covered by oceans. Convert the areas of oceans and the total ocean area to square miles using the km to miles conversion given on the sheet. Compute the percentage each continent is of the total land area. Format as percentage to 1 place. ) Compute the total area of Earth in both square kilometers and square mi d.) Compute the percentage each continent and ocean is of the entire Earth, using cell references in your formulas. Format as percentage to 1 place. e.) Create a well-labeled pie chart of this table. Include a key, labels and percent on each section of the pie chart and use the following for the title: Percentage of Earth