Ex16 Xl Ch04 Grader Rockville Auto Sales

-You work for Rockville auto sales and have been asked to aid in the development of spreadsheets to manage sales and inventory information. You will start the task with the prior worksheet that contains vehicle information and sales data for 2018. You need to convert the data to a table. You will manage the large worksheet, prepare the worksheet for printing, sort and fill the table, include calculations, and then format the table.

R7 fr 2 29069343873/18/18 30,000.00 30,000.00 36393487147 9/27/18 $ 30,000.00 $ 27,000.00 90% 4 9356019403 7/22/18 $ 22,000.00 $ 13,200.00 1111 I 60% 5 8000086254 7/1/18 30,000.00 27,000.00 2 717433901231 4/21/18 $ 27,000.00 $ 16,200.00 1111 60% 8 1328395941 1/31/18 25,000.00 $ 17,500.00 9 8137529693 109650039042 10/16/18 $ 30,000.00 $ 27,000.00 0111150% 11 1344751603 4/18/18 $ 25,000.00 25,000.00 12 3732185591 6/15/18$ 27,000.00 18,900.00 13 8251440185 3/21/18 22,000.00 19,800.00 14 9414505869 8/6/18 30,000.00 30,000.00 15 4942016124 7/22/18 $ 22,000.00 15,400.00 16 4094989639 9/20/18 22,000.00 $ 13,200.00 17 4700777743 4/11/18 $ 25,000.00 $22,500.00 70% 3/4/18 $ 22,000.00 19,800.00 70% 70% 60% 60% 19 3860813150 12/17/18 $ 34,000.00 $ 30,600.00 20 2069016783 8/3/18 27,000.00 $ 27,000.00 21 2488607421 3/21/18 $ 22,000.00 $ 19,800.00 22 754 1058788 6/1/18 $ 22,000.00 $ 17,600.00 1111 E0% 23 3345743062 10/9/18 $ 27,000.00 $ 21,600.00 1889854267 1/25/18 $ 34,000.00 $ 27,200.00 25 8131908841 11/4/18 $ 34,000.00 $ 23,800.00 70% 26 7679546980 11/2/18 s 40,000.00 28,000.00 27 1360867906 1/22/18 $ 22,000.00 $ 22,000.00 28 5739567111 5/29/18 $ 22,000.00 $ 22,000.00 29 6007144763 10/26/18 $ 22,000.00 $ 17,600.00 30 3695501103 2/14/18 S 22,000.00 $ 22,000.00 31 Total 32 0% S 785,000.00 $649,300.00 83 34