dac7a55-d395-4894-b208-4a539edc45d9/page WHAT-IF ANALYSIS 4. Erase all October data and use the worksheet to complete the following bank reconciliation at November 30, 2011: {:[" Adjusted balance ",$7","608,],[" Balance per bank ",$7","950,],[" Balance per books ",?,],[" Checks outstanding ",$547," (details omitted) "],[" Deposits in transit ",?,],[" Service charges ",$16,]:} Save your completed file as NOV30. Print the worksheet. CHART ANALYSIS 5. Open the OCT31 file. Click the Chart sheet tab. On the screen, a column chart appears illustrating relative book and bank balances at July 31 and August 31 . In the space provided below, list at least two reasons why the discrepancy between book and bank balances may have existed at July 31 . a. b. Why may the dis