(3) Cakes. 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

Cakes

Product

Price ($)

Quantity Sold

Chocolate

18.95

1,096

Vanilla

18.95

543

Lemon

17.95

227

Apple Cinnamon

19.95

2,377

Maple Pumpkin

17.95

4,311

Pies

Product

Price ($)

Quantity Sold

Mincemeat

15.95

1,087

Pecan

19.95

3,209

Pumpkin

15.95

1,044

Apple

19.95

2,054

Cherry

15.95

3,423

Mincemeat

15.95

1,087

Pecan

19.95

3,209

You are asked to create a sales summary worksheet in excel 2013. All calculations involved in the worksheet preparation must be completed using appropriate formulae. Format your worksheet as shown below: