Font Paldyi api Sales summary for Amy's Orchard Data: Sales of Amy's Orchard for the four quarters of 2014 by product is presented below: 03 10,000 6,000 Product Red Delicious apple Granny Smith apple Fuji apple Mandarin orange Navel orange Blood orange Haas avocado Pinkerton avocado 01 $2,000 5,000 6,000 4,000 7,000 4,000 3,800 2,300 Q2 $8,000 4,000 5,000 8,000 9,000 5,500 4,600 5,150 8,000 10,000 11,000 Q4 12,000 9,000 10,000 10,000 8,000 9,000 7,500 5,200 2.900 3.750 4,850 Output: Using Excel, create a Sales Summary by Quarter for Amy's Orchard for the year 2014 as follows: (1) Show sales by quarter and in total for 2014. Using the sum function, insert subtotal for each product (ie, apples, oranges, avocados) and total sales for each quarter and for the year. (2) Format worksheet as follows: (a) Merge and center title over all columns. (b) Insert a column between each quarter and total column. Set column width to 2. (c) Insert two rows between each type of product (i.e., apples, oranges and avocadoes) and calculate subtotals for each quarter. (d) Center amount in cells and round to nearest dollar. (e) Insert "S" sign in first cell of each column and in Total Sales row. (f) Insert double underline under Total Sales. of 1 234 words C E E- + 70