of 2020. 1. Create a copy of "Fleet Information Raw Data" worksheet into a new worksheet named "Fleet Information Completed." 2. Create a copy of "Sales Information Raw Data" worksheet into a new worksheet named "Sales Information Completed." 3. Both Fleet Information Completed worksheet and Sales Information Completed worksheet should be moved to the end, according to the following order. Fleet Information Completed Instructions 4- 7 pertain to the Fleet Information Completed worksheet. 4. Freeze the top row in the Fleet Information Completed worksheet. 5. Convert the data to a table, name the table Inventory, and apply the Table style Medium 19 style. 6. Remove duplicate records. 7. Sort the table by Make in alphabetical order, add a second level to sort by Year, and a third level to sort by Sticker Price smallest to largest. Instruction 8- 13 pertain to the Sales Information Completed worksheet. 8. In the Sales Information Completed worksheet, convert the data to a table, name the table Sales, and apply the Table Style Dark 11. heading in the formula. 10. Format range E2:E30 with Percentage Style Number Format 11. Name column E "\% of Sticker Price" 12. Add a total row (found on the "Design tab" once clicked on the table) to display the Average of \% of Sticker Price and Sum of Sticker Price and Sale Price. 13. Adjust the width of column B:E to show the total values. Dark Yellow Text." Instruction 15- 18 pertain to the First Quarter Sales worksheet. 15. Copy the "Sales Information Completed" worksheet and name it "First Quarter Sales" place the duplicate sheet to the right of the original. 16. Rename the table FirstQuarter. 17. Display the filter arrows for the data. 18. Filter the data to display January, February, and March Sales only. 19. Save the file name as is with your Last and first name at the end. Submit your completed file to your instructor. \begin{tabular}{|c|c|c|c|c|} \hline Make & Model & Year & Mileage & Sticker Price \\ \hline 2906934387 BMW & 5 Series & 2019 & 25709 & $30,000.00 \\ \hline 6393487147 Honda & Civic & 2019 & 26609 & $30,000.00 \\ \hline 9356019403 Toyota & Prius & 2000 & 96905 & $22,000.00 \\ \hline 8000086254 BMW & 5 Series & 2017 & 28681 & $30,000.00 \\ \hline 9340076442 BMW & 5 Series & 2007 & 18384 & $34,000.00 \\ \hline 7433901231 Chevy & Malibu & 2010 & 37085 & $27,000.00 \\ \hline 1328395941 Chevy & Malibu & 2002 & 48868 & $25,000.00 \\ \hline 8137529693 BMW & 5 Series & 2001 & 61480 & $22,000.00 \\ \hline 9650039042 Ford & F150 & 2012 & 28541 & $30,000.00 \\ \hline 1344751603 Toyota & Prius & 2004 & 42890 & $25,000.00 \\ \hline 3732185591 BMW & 5 Series & 2001 & 36595 & $27,000.00 \\ \hline 8251440185 Ford & F150 & 2011 & 76254 & $22,000.00 \\ \hline 9414505869 Toyota & Prius & 2004 & 21380 & $30,000.00 \\ \hline 4942016124 Ford & F150 & 2006 & 63737 & $22,000.00 \\ \hline 4094989639 BMW & 5 Series & 2017 & 92048 & $22,000.00 \\ \hline 4700777743 BMW & 5 Series & 2017 & 44667 & $25,000.00 \\ \hline 1380128961 BMW & 5 Series & 2007 & 11158 & $34,000.00 \\ \hline 3860813150 Ford & F150 & 2009 & 14095 & $34,000.00 \\ \hline 2069016783 Honda & Civic & 2014 & 34428 & $27,000.00 \\ \hline 2488607421 BMW & 5 Series & 2008 & 68172 & $22,000.00 \\ \hline 7541058788 Chevy & Malibu & 2011 & 77099 & $22,000.00 \\ \hline 3345743062 Ford & F150 & 2007 & 31562 & $27,000.00 \\ \hline 1889854267 BMW & 5 Series & 2012 & 14427 & $34,000.00 \\ \hline 8131908841 BMW & 5 Series & 2004 & 14966 & $34,000.00 \\ \hline 7679546980 BMW & 5 Series & 2010 & 7877 & $40,000.00 \\ \hline 1360867906 Chevy & Malibu & 2004 & 70797 & $22,000.00 \\ \hline 5739567111 Honda & Civic & 2013 & 99041 & $22,000.00 \\ \hline 6007144763 BMW & 5 Series & 2008 & 95344 & $22,000.00 \\ \hline 3695501103 Ford & F150 & 2015 & 99021 & $22,000.00 \\ \hline 2482451414 Ford & F150 & 2014 & 83281 & $22,000.00 \\ \hline 7397531553 BMW & 5 Series & 2017 & 36000 & $27,000.00 \\ \hline 3133070112 Honda & Civic & 2009 & 46323 & $25,000.00 \\ \hline 5322014014 Ford & F150 & 2011 & 46216 & $25,000.00 \\ \hline 5726149503 Ford & F150 & 2015 & 6971 & $40,000.00 \\ \hline 4820173885 Ford & F150 & 2016 & 6921 & $40,000.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline 2706112648 BMW & 5 Series & 2012 & 22089$ & 30,000.00 \\ \hline 7377188604 Ford & F150 & 2016 & 52774$ & 22,000.00 \\ \hline 5293323010 Honda & Civic & 2001 & 30840$ & 27,000.00 \\ \hline 2406189439 Honda & Civic & 2010 & 49544$ & 25,000.00 \\ \hline 3578026701 Honda & Civic & 2003 & 34825$ & 27,000.00 \\ \hline 1462643171 Toyota & Prius & 2006 & 8887$ & 40,000.00 \\ \hline 5122993766 Toyota & Prius & 2014 & 84930$ & 22,000.00 \\ \hline 7092958553 Chevy & Malibu & 2014 & 11654$ & 34,000.00 \\ \hline 8156049535 Honda & Civic & 2005 & 3997$ & 40,000.00 \\ \hline 9305933928 Ford & F150 & 2011 & 40807$ & 25,000.00 \\ \hline 9537026620 Toyota & Prius & 2008 & 27785$ & 30,000.00 \\ \hline 8019012354 BMW & 5 Series & 2017 & 50120$ & 22,000.00 \\ \hline 3737821324 Toyota & Prius & 2001 & 35426$ & 27,000.00 \\ \hline 7596630806 Ford & F150 & 2003 & 81699$ & 22,000.00 \\ \hline 5718003239 BMW & 5 Series & 2016 & 39202$ & 27,000.00 \\ \hline 8010477805 BMW & 5 Series & 2009 & 50527$ & 22,000.00 \\ \hline 3814357405 Chevy & Malibu & 2016 & 54060$ & 22,000.00 \\ \hline 1213463078 Toyota & Prius & 2000 & 93430$ & 22,000.00 \\ \hline 1563229851 Chevy & Malibu & 2002 & 13764$ & 34,000.00 \\ \hline 9027521957 Ford & F150 & 2002 & 90009$ & 22,000.00 \\ \hline 8893900890BMW & 5 Series & 2006 & 79293$ & 22,000.00 \\ \hline 7454528548 BMW & 5 Series & 2002 & 37753 \$ & 27,000.00 \\ \hline 8054683334 Chevy & Malibu & 2012 & 36934$ & 27,000.00 \\ \hline 5742570103 BMW & 5 Series & 2011 & 78360$ & 22,000.00 \\ \hline 8163497575 Ford & F150 & 2004 & 91310$ & 22,000.00 \\ \hline 5276867505 Honda & Civic & 2018 & 39645$ & 27,000.00 \\ \hline 1409363873 Chevy & Malibu & 2004 & 80047$ & 22,000.00 \\ \hline 1089138532 BMW & 5 Series & 2012 & 95298$ & 22,000.00 \\ \hline 6015917869 Toyota & Prius & 2001 & 87698$ & 22,000.00 \\ \hline 9885757629 Ford & F150 & 2004 & 19686$ & 34,000.00 \\ \hline 5306541595 BMW & 5 Series & 2013 & 81096$ & 22,000.00 \\ \hline 2747847524 Chevy & Malibu & 2014 & 50650$ & 22,000.00 \\ \hline 7718062943 BMW & 5 Series & 2013 & 55145$ & 22,000.00 \\ \hline 2976194513 Toyota & Prius & 2003 & 27493$ & 30,000.00 \\ \hline 8281760371 Chevy & Malibu & 2012 & 44985$ & 25,000.00 \\ \hline 4730270762 Honda & Civic & 2007 & 8541$ & 40,000.00 \\ \hline 5161605236 & Civic. & 2013 & 3127 & 27.000 .00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline & & & & \\ \hline 7473005747 BMW & 5 Series & 2003 & 41747$ & 25,000.00 \\ \hline 6891374035 Honda & Civic & 2003 & 75313$ & 22,000.00 \\ \hline 5463769134 Ford & F150 & 2012 & 99161$ & 22,000.00 \\ \hline 3867060534 Honda & Civic & 2003 & 52586$ & 22,000.00 \\ \hline 3849719202 BMW & 5 Series & 2006 & 33661$ & 27,000.00 \\ \hline 7200319445 Honda & Civic & 2005 & 23147$ & 30,000.00 \\ \hline 8725850239 Honda & Civic & 2016 & 57432$ & 22,000.00 \\ \hline 5903493846 BMW & 5 Series & 2001 & 91463$ & 22,000.00 \\ \hline 2373147058 BMW & 5 Series & 2009 & 40492$ & 25,000.00 \\ \hline 6161188244 BMW & 5 Series & 2012 & 65420$ & 22,000.00 \\ \hline 4913951544 Chevy & Malibu & 2003 & 40380$ & 25,000.00 \\ \hline 8806645278 Honda & Civic & 2012 & 76217$ & 22,000.00 \\ \hline 5250708704 BMW & 5 Series & 2006 & 61969$ & 22,000.00 \\ \hline 8357455137 Ford & F150 & 2016 & 17398$ & 34,000.00 \\ \hline 4370047837 Toyota & Prius & 2012 & 38800$ & 27,000.00 \\ \hline 6290615001 Honda & Civic & 2009 & 96345$ & 22,000.00 \\ \hline 8279091856 Honda & Civic & 2003 & 4129$ & 40,000.00 \\ \hline 1218797573 Ford & F150 & 2010 & 11098$ & 34,000.00 \\ \hline 1218797573 Ford & F150 & 2015 & 11098$ & 34,000.00 \\ \hline 2700853328 BMW & 5 Series & 2004 & 97812$ & 22,000.00 \\ \hline 6729292004 Ford & F150 & 2001 & 63166$ & 22,000.00 \\ \hline 9622942163 BMW & 5 Series & 2000 & 57736$ & 22,000.00 \\ \hline 1532392596 Honda & Civic & 2019 & 3308$ & 40,000.00 \\ \hline 1532392596 Honda & Civic & 2018 & 3308$ & 40,000.00 \\ \hline 6851036813 Toyota & Prius & 2013 & 79226$ & 22,000.00 \\ \hline 5095450285 Ford & F150 & 2019 & 70078$ & 22,000.00 \\ \hline 1531278978 Honda & Civic & 2019 & 82011$ & 22,000.00 \\ \hline 4174658862 Ford & F150 & 2009 & 54406$ & 22,000.00 \\ \hline 4174658862 Ford & F150 & 2009 & 54406$ & 22,000.00 \\ \hline 6556316751 Ford & F150 & 2016 & 58076$ & 22,000.00 \\ \hline 6287671745 Honda & Civic & 2007 & 49295$ & 25,000.00 \\ \hline \end{tabular} \begin{tabular}{lrrlll} Vin \# & Date sold & \multicolumn{2}{l}{ Sticker Price } & \multicolumn{2}{l}{ Sale Price } \\ 2906934387 & 3/18/2019 & $30,000.00 & $30,000.00 \\ 6393487147 & 9/27/2020 & $30,000.00 & $27,000.00 \\ 9356019403 & 7/22/2020 & $22,000.00 & $13,200.00 \\ 8000086254 & 7/1/2020 & $30,000.00 & $27,000.00 \\ 9340076442 & 12/31/2020 & $34,000.00 & $27,200.00 \\ 7433901231 & 4/21/2020 & $27,000.00 & $16,200.00 \\ 1328395941 & 1/31/2020 & $25,000.00 & $17,500.00 \\ 8137529693 & 3/4/2020 & $22,000.00 & $19,800.00 \\ 9650039042 & 10/16/2020 & $30,000.00 & $27,000.00 \\ 1344751603 & 4/18/2020 & $25,000.00 & $25,000.00 \\ 3732185591 & 6/15/2020 & $27,000.00 & $18,900.00 \\ 8251440185 & 3/21/2020 & $22,000.00 & $19,800.00 \\ 9414505869 & 8/6/2020 & $30,000.00 & $30,000.00 \\ 4942016124 & 7/22/2020 & $22,000.00 & $15,400.00 \\ 4094989639 & 9/20/2020 & $22,000.00 & $13,200.00 \\ 4700777743 & 4/11/2020 & $25,000.00 & $22,500.00 \\ 1380128961 & 1/6/2020 & $34,000.00 & $20,400.00 \\ 3860813150 & 12/17/2020 & $34,000.00 & $30,600.00 \\ 2069016783 & 8/3/2020 & $27,000.00 & $27,000.00 \\ 2488607421 & 3/21/2020 & $22,000.00 & $19,800.00 \\ 7541058788 & 6/1/2020 & $22,000.00 & $17,600.00 \\ 3345743062 & 10/9/2020 & $27,000.00 & $21,600.00 \\ 1889854267 & 1/25/2020 & $34,000.00 & $27,200.00 \\ 8131908841 & 11/4/2020 & $34,000.00 & $23,800.00 \\ 7679546980 & 11/2/2020 & $42,000.00 & $28,000.00 \\ 1360867906 & 1/22/2020 & $22,000.00 & $22,000.00 \\ 5739567111 & 5/29/2020 & $22,000.00 & $22,000.00 \\ 6007144763 & 10/26/2020 & $22,000.00 & $17,600.00 \\ 3695501103 & 2/14/2020 & $22,000.00 & $22,000.00 \end{tabular}