help me to do it step by step

For Project 21, you will need the following file: e021. Palms You will save your workbook as: Lastname_Firstname_21_Palms Melanie Castillo, Product Manager for Rosedale Landscape and Garden, has requested a 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 four categories of palm trees, and she would like the items to be sorted from lowest to highest retail price. She would also like a separate column for Item # and for Category. Edit the file c021 Palms to provide Melanie with the information requested, and use the Table 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 properties. Save the file as Lastname_Firstname_2L Palms and print or submit as directed by your instructor. r You have completed Project 2L END A 1 Rosedale Landscape ahd Garden 2 Pasadena Facility Palm Tree Inventory 3 Number of Product Types 4 Quantity in Stock Retail Price 47.50 5 Queen 6 Pygmy Date 7 King 8 Sago 9 10 Quantity in Stock 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Item #/Category 54 12398-King 74 13189-Queen 98 15688-Queen 12 16555-Pygmy 15 22189-Pygmy 124 23371-Pygmy 143 23677-King 129 25844-King 76 26787-Sago 15 32544-Sago 41 34793-Sago 122 37283-Queen 234 43877-King 98 49293-Pygmy Product Name King Palm 15 Gallon Queen 1 Gallon Queen 30" Box Pygmy Date 24" Box Pygmy Date 36" Box Pygmy Date 10" King Palm 1 Gallon King Palm 36" Box Sago Palm 1 Gallon Sago Palm 10" Sago Palm 17" Queen 24" Box King Palm 5 Gallon Pygmy Date 14" 5.00 325.00 195.00 475.00 15.00 5.50 450.00 7.50 N 30.00 155.00 135.00 15.50 52.00 A B D E F Pygmy Date "King Sago Quantity in Stock B 4 5 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Item# Product Name 54 12398 King Palm 15 Gallon 74 13189 Queen 1 Gallon 98 15688 Queen 30" Box 12 16555 Pygmy Date 24" Box 15 22189 Pygmy Date 36" Box 124 23371 Pygmy Date 10" 143 23677 King Palm 1 Gallon 129 25844 King Palm 36" Box 76 26787 Sago Palm 1 Gallon 15 32544 Sago Palm 10" 41 34793 Sago Palm 17" 122 37283 Queen 24" Box 234 43877 King Palm 5 Gallon 98 49293 Pygmy Date 14" 66 65213 Sago Palm 14" 23 76352 Pygmy Date 17" 56 78324 Queen 5 Gallon 32 98376 Queen 15 Gallon Retail Price Category 47.50 King 5.00 Queen 325.00 Queen 195.00 Pygmy 475.00 Pygmy 15.00 Pygmy 5.50 King 450,00 King 7.50 Sago 30.00 Sago 155.00 Sago 135.00 Queen 15.50 King 52.00 Pygmy 65.00 Sago 95.00 Pygmy 15.00 Queen 45.00 Queen