Open the start file EX$2021-$ChallengeYourself$-3-3-$ALT. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it$.$ If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify it$.$ The sustainability rating information and vehicle information on the HybridCar$\_$Data sheet will be used in lookup formulas later in this project. Name the following cell ranges on the HybridCar$\_$Data sheet: Cells B$12$:C$23$ name: GreenRatings Cells B$26$:D$37$ name: VehicleData Cells B$26$:B$37$ name: Vehicle Cells C$26$:C$37$ name: EngineType Cells D$26$:D$37$ name: GreenScore Return to the NewHybridCar worksheet. Calculate the average MPG for each car. Enter a formula in cell C$15$ using the AVERAGE function to calculate the average value of C$13$:C$14.$ Use only one argument. Copy the formula to the appropriate cells for the other cars. Excel will detect a possible error with these formulas. Use the SmartTag to ignore the error. Hint: Use the SmartTag while cells C$15$:F$15$ are selected and the error will be ignored for all the selected cells. Use XLOOKUP to lookup the Engine Type for each vehicle. Enter a formula in cell C$9$ to look up the engine for the first vehicle. Use the vehicle in cell C$4$ as the Lookup$\_$value argument. Use the Vehicle named range as the Lookup$\_$array argument. Use the EngineType named range as the Return$\_$array argument. Copy the formula to the appropriate cells for the other vehicles. Use VLOOKUP to calculate the Green Score for each vehicle. Enter a formula in cell C$10$ to look up the Green Score for the first vehicle. Use the vehicle type in cell C$4$ as the Lookup$\_$value argument. Use the VehicleData named range as the Table$\_$array argument. The green scores are located in column $3$ of the data table. Require an exact match. Copy the formula to the appropriate cells for the other vehicles. Look up the Sustainability Rating for each car listed. Enter a formula in cell C$16$ to look up the sustainability rating for the first car. Use the car name in cell C$4$ as the Lookup$\_$value argument. Use the GreenRatings named range as the Table$\_$array argument. The ratings are located in column $2$ of the data table. Require an exact match. Copy the formula to the appropriate cells for the other cars. Determine whether or not you will need a loan for each potential purchase. In cell C$22,$ enter a formula using an IF function to determine if you need a loan. Your available cash is located on the HybridCar$\_$Data sheet in cell A$3.$ If the price of the car is less than or equal to your available cash, display $"$no$".$ If the price of the car is more than your available, cash, display "yes". Use absolute references where appropriate$$you will be copying this formula across the row. Copy the formula to the appropriate cells for the other cars. Calculate how much you would need to borrow for each purchase. In cell C$23,$ enter a formula to calculate the price of the car minus your available cash $($from cell A$3$ in the HybridCar$\_$Data worksheet$).$ Use absolute references where appropriate$$you will be copying this formula across the row. Copy the formula to the appropriate cells for the other cars. Calculate the monthly payment amount for each loan. In cell C$27,$ enter a formula using the PMT function to calculate the monthly loan payment for the first car. Hint: Divide the interest rate by $12$ in the Rate argument to reflect monthly payments. Hint: Multiply the number of years by $12$ in the Nper argument to reflect the number of monthly payments during the life of the loan. Hint: Use a negative value for the loan amount in the Pv argument so the payment amount is expressed as a positive number. Copy the formula to the appropriate cells for the other cars. Compute the monthly cost of gas. In cell C$28,$ enter a formula to calculate the number of miles you expect to drive each month. Divide the value of number of miles $($cell A$5$ from the HybridCar$\_$Data sheet$)$ by the average MPG for the vehicle multiplied by the price of a gallon of gas $($cell A$6$ from the HybridCar$\_$Data sheet$).$ Copy the formula to the appropriate cells for the other cars. If cells D$28$:F$28$ display an error or a value of $0,$ display formulas and check for errors. If you still can$$t find the error, try displaying the precedent arrows. Hint: The references to the cells on the HybridCar$\_$Data sheet should use absolute references. If they do not, the formula will update incorrectly when you copy it across the row. Compute the monthly cost of maintenance. In cell C$29,$ enter a formula to calculate the monthly maintenance cost: Divide cell C$19$ by $12.$ Copy the formula to the appropriate cells for the other cars. Compute the monthly cost of insurance. In cell C$30,$ enter a formula to calculate the monthly insurance cost: Divide cell C$21$ by $12.$ Copy the formula to the appropriate cells for the other cars.