PLEASE DO IN EXCEL PLEASE DO IN EXCEL SHOW HOW ITS DONE IN EXCEL

1. Compute the Area of a Circle AND Volume of a Sphere for the following diameters. 1.8, 3.65, 7.68, 9.3, 10.8, 15.98, and 20.54. All given values are in meters. Provide answers in Square Meters, Square Feet, Cubic Meters, and Cubic Feet. All data must be neat, labeled (with units), and have three decimal places. 2. The formula for calculating interest for a loan is shown below. r A= P(1+-)nt n Where: A = The Final Loan Amount P = Initial Principle Balance r= Interest Rate n= Number of times interest is applied per time period t= Number of time periods Calculate the final loan amount for the following loan amounts and he time periods. $200,000, $250,000, $300,000, $350,000, $400,000, $450,000, and $500,00. Length of loans shall be 10, 15, 20, and 30 years. The interest rate shall be entered by the user as a whole number (no decimal entries allowed) and the number of compound periods shall be user configurable too. Use 2.75% and compounded monthly to start. Final Amount shall be formatted as a dollar value with 2 decimal places. 1. Compute the Area of a Circle AND Volume of a Sphere for the following diameters. 1.8, 3.65, 7.68, 9.3, 10.8, 15.98, and 20.54. All given values are in meters. Provide answers in Square Meters, Square Feet, Cubic Meters, and Cubic Feet. All data must be neat, labeled (with units), and have three decimal places. 2. The formula for calculating interest for a loan is shown below. r A= P(1+-)nt n Where: A = The Final Loan Amount P = Initial Principle Balance r= Interest Rate n= Number of times interest is applied per time period t= Number of time periods Calculate the final loan amount for the following loan amounts and he time periods. $200,000, $250,000, $300,000, $350,000, $400,000, $450,000, and $500,00. Length of loans shall be 10, 15, 20, and 30 years. The interest rate shall be entered by the user as a whole number (no decimal entries allowed) and the number of compound periods shall be user configurable too. Use 2.75% and compounded monthly to start. Final Amount shall be formatted as a dollar value with 2 decimal places