A Bank Statement Reconciliation Form Application: Excel Complete Production Challenge 15-C on page 325 of the textbook then create the bank reconciliation statement using MS Excel. You have already begun to create the statement and have saved it as Working File 15-1 on the Text Enrichment Site. Open the file and complete it by entering the missing information in order to balance the cheque register with the bank statement. Note: You have formatted the reconciliation statement similar to the one on page 318 of the textbook. Exercise 15-2: A Quarterly Sales Report Application: Excel Using MS Excel, create a worksheet for Millennium Appliances, Inc. 2 nd quarter sales using the following information. Also, using TABLESTYLE MEDIUM 4, format. Calculate the total sales for each region using the SUM () function. MILLENNIUM APPLIANCES, INC. 2 nd Quarter Sales (sales in thousands) Eastern Midwestern Northwestern Western Refrigerators $ 1,489 $ 1,295 $ 1,405 $ 2,428 Ovens 760 852 795 684 Garbage Compactors 526 260 347 544 Freezers 945 1,015 962 1,139 Dishwashers 1,710 1,646 834 699 Microwave Ovens 3,465 2,439 1,743 1,842 Washers 2,945 2,258 1,657 2,034 Dryers 1,986 2,395 1,281 1,757 Total Sales $13,826 $12,160 $ 9,024 $11,127 Exercise 15-3: A Quarterly Sales Report Chart Sheet Application: Excel Complete Exercise 15-2 then create and print a CHART SHEET for the Millennium Appliances, Inc. 2 nd Quarter Sales table. Exercise 15-4: A Quarterly Sales Report Embedded Chart Application: Excel Complete Exercise 15-2 then create an EMBEDDED CHART for the 2 nd quarter sales by doing the following: A. Using CHART WIZARD create a PIE CHART for the Eastern Region appliances and sales figures, but not including the Total Sales figure. B. In CHART TYPE, select PIE (first sub-type choice). C. In CHART OPTIONS: TITLES: create the title, Eastern Region 2 nd Quarter Sales LEGEND: select SHOW LEGEND/RIGHT DATA LABELS: choose SHOW PERCENT D. Reposition the title in the chart so it is visible, if required. E. Resize the chart to fit all text and objects. F. Print the table and chart on the same page