Excel

Assignment 1 Description: You work for Miss Lexi’s Baked Goods which sell Cookie Baskets. You are given the price and quantity sold for each item as follows

           Cookie Baskets

            Product

     Price ($)

   Quantity Sold

  Almond Crunches

      15.95

      559

   Cinnamon Sleds

  15.95

 1,026

  Coconut Snowmen

      19.95

      1,598

   Molasses Chews

  19.95

 2,287

  Raspberry Bells

      21.95

      787

   Gingerbread Men

  21.95

 1,065

  Chocolate Delights

     25.95

    1,076

 You are asked to create a sales summary worksheet in excel which contains the information in the above table and additional two columns as follow

1) First additional column to show the cost of the each product. (2points)

2) Second additional column to show the percentage of cost of the product with respect to the total

cost. (2points)

Rest of the points are allocated as follows

1) Professional formatting 2Points

2) Proper usage of Excel formula in both the additional columns 2+2=4Points.