1461c043?locale=null&key=11702797713913780242022 2: Using Functions, Creating Tables, and Managing Large Work... Project Files For Project 2L, you will need the following file: e02L_Palms You will save your workbook as: Lastname_Firstname_2L_Palms Melanie Castillo, Product Manager for Rosedale Landscape and Garden, has requested worksheet that summarizes the current palm tree inventory data. Melanie would like the worksheet to include the total Quantity in Stock and Number of Items for each of the for categories of palm trees, and she would like the items to be sorted from lowest to highes price. She would also like a separate column for Item # and for Category. Edit the file e02L_Palms to provide Melanie with the information requested, and use the feature to find the data requested. Format the worksheet titles and data and include an appropriately formatted table so that the worksheet is professional and easy to read and understand. Insert a footer with the file name, and add appropriate document propertie file as Lastname_Firstname_2L_Palms and print or submit as directed by your instructB4 D E G H A B C F 1 Valley View Facility: Inventory Status of Toppings 2 As of June 30, 2014 W 4 Total Items in Stock 3,328 5 Average Price 8.57 6 Median Price S 7.51 7 Lowest Price 4.75 8 Highest Price S 29.95 9 10 Salsa Types: 11 Salsa Total Quantity: 12 13 14 Quantity in Stock Item# Category Item Name Retail Price Size 15 87 9952 Salsa Verde Hot 8.95 13 oz. 16 235 8582 Syrup Dark Chocolate 15 17 oz. 17 45 8256 Jam Tangerine Marmalade 7.59 13 oz. 18 42 6255 Sauce Artichoke Pesto 9.95 8 oz. 19 153 5664 Dressing Olive Oil and Balsamic 6.89 13 oz. 20 95 5636 Sauce Classic Alfredo 9.59 14 oz. 21 182 5635 Sauce Chocolate Peanut Butter 8.45 9 oz. 22 185 5522 Sauce Bittersweet Chocolate 8.95 12 oz. 23 110 5463 Dressing Balsamic Fig 8.59 11 oz. 24 285 4822 Salsa Black Bean 6.5 8 oz. 25 126 4652 Dressing Creamy Asiago 8.75 13 oz. 26 108 4625 Jam Raspberry Peach 4.75 4 oz