Please include formulas, thank you!

251 Automobiles Instructions - Protected View - Saved to this PC- Mailings Review View Help ses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing YO19_Excel_Ch06_PS1_Automobiles Project Description: Community Auto Sales is considering opening a new location on the east side of town. They need to determine the types of vehicles that they would like to have on the lot for sale. They have acquired a sample data set of vehicle features and estimated MSRP (manufacturer's suggested retail price) and need your help in setting up some analysis so that they can explore their options Steps to Perform Step Instructions Points Possible 1 0 2 8 3 2 4 5 5 2 Start Excel Download and open the file named Excel Ch06 PS1 Automobiles xlsx Grader has automatically added your last name to the beginning of the filename Save the file to the location where you are storing your files Converting plain data sets to Excel Tables can provide easy ways to explore the data The data on the AutoSample worksheet includes details about vehicles that the company may be interested in buying for resale On the AutoSample worksheet, insert a table with headers using the data With the table selected, including the headers, create a CarDatabase named range to be used in database functions later Insert sex rows above the table to make room to create an advanced filter In order to create an Advanced Filter you must include the column headings to which you will be specifying criteria Copy the headers in A7.J7 and paste the headincas starting in coll A1. Using the Advanced Filter, display only the records with an Automatic transmission type, that are a Midsize vehicle size, with an MSRP of