Mark the steps as checked when you complete them.
Open the start file EX2019-ChallengeYourself-33.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 registration fee information in cells B 11:C17
on the Data sheet will be used in lookup formulas later in this project. Name the range RegistrationFees to make it easier to use later.
Return to the Purchase worksheet.
Calculate the average MPG for each vehicle.
a.Enter a formula in cell C 1.0using the AVERAGE function to calculate the average value of