-You work for Rockville auto sales and have been asked to aid in the development
ID: 3752377 • Letter: #
Question
-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 34Explanation / Answer
2 - Freeze the top row
Click View from the top ribbon > Click Freeze Panes > Click Freeze Top Row
3 - Convert the data to a table, name the table Inventory
Using the mouse select the data in consideration. Once the data is selected, click on the "Name Box" and type "Inventory". Using the steps, you now have a reference to the data
4 Remove duplicate records
Click on the column A, while the column is selected, Click Data from the top ribbon bar. Next click Remove Duplicates
5 Sort the table by Make in alphabetical order, add a second level to sort by Year
Smallest to Largest, and a third level to sort by Sticker Price Smallest to Largest
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.