Exp22_Excel_Ch04_CumulativeAssessment_Variation_Rockville_Auto_Sales_Instructions

Grader - Instructions Excel 2021 Project Exp22_Excel_Ch04_CumulativeAssessment_Variation_Rockville_Auto_Sal es Project Description: You work for Rockville Auto Sales and have been asked to aid in the development of a spreadsheet to manage sales and inventory information. You will start the task with a 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 filter the table, include calculations, and then format the table. Steps to Perform: Step Instructions Points Possible 1 Start Excel. Download and open the file named EXP22_Excel_Ch04_CumulativeAssessment_Variation_AutoSales.xls x . Grader has automatically added your last name to the beginning of the filename. 0 2 Freeze the first row on the Fleet Information worksheet. 5 3 Convert the data to a table, name the table Inventory , and apply the Gold, Table Style Medium 19. 10 4 Remove duplicate records. 3 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. 5 6 Repeat the field names on all pages. 5 7 Change page breaks so each vehicle make is printed on a separate page. 5 8 Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side. 6 9 Display the Sales Information worksheet and convert the data to a table, name the table Sales , and apply the Green, Table Style Dark 11. 10 10 Type % of sticker in cell E1. 2 11 Create a formula with structured references to calculate the percentage of the Sticker Price in column E. 5 12 Format the range E2:E30 with Percent Style Number Format. 5 13 Add a total row to display the Average of % of sticker and Sum of 7 Created On: 11/06/2023 1 Exp22_Excel_Ch04_CumulativeAssessment_Variation - Rockville Auto Sales 1.3