Please format your excel document according to the requirements and share every function used in the process. Thank you!

Bondo Auto Sales You are a car salesman for Bondo Auto Sales. Your manager requires you to prepare a monthly sales report for him. This report will list all car sales for the month of February. You will create a summary area which will include highest price, lowest price, and the average interest rate. a) Using the information on the next page, key the information into an Excel worksheet using landscape orientation b) Center the title, Bondo Auto Sales, over the worksheet. c) Key the month. d) Compute the amount you are putting toward the price of the vehicle. This would include your trade in plus the cash you put down. e) Compute the amount you will be actually paying for the car. (Amount to be Financed) Compute the monthly payment for the cars which were financed using 7 years. You may want to add a column for this information f) Copy the formulas as appropriate. g) Enter the appropriate formula to calculate total sales and highlight the cell. h) Compute the statistics at the end of the worksheet. Use the min, max and average function. i) Format the completed worksheet using currency and percentage. 1) Enhance the worksheet to show your knowledge of Excel. k) Add a pie chart showing the cars sold and the amount. Include the chart as part of the worksheet. Show the names of the cars in the data labels. 1) Insert your name, today's date and time in a footer. Bondo Auto Sales February Amount of Trade in and Cash Amount to be Financed Cars Sold Camaro Charger Corvette Mustang GT Selling Price 40000 35000 85950 55000 Trade In 3000 8000 15000 10000 Cash 1000 5000 15000 3000 Monthly Interest Payment 4.00% 2.50% 3.00% 2.00% Total Sales Car Statistics Highest Price (based on selling price) Lowest Price (based on selling price) Average Interest Rate