3 SIM: Preparing a bank reconciliation. 1. Prepare a bank reconciliation using a company's bank statement and cash account. X Preparing a bank reconciliation Excel FORMULAS DATA REVIEW VIEW PAGE LAYOUT LE HOME INSERT - Formula Bar Page Break Page Custom Gridines Headings Preview Layout View Show Zoom 100% Zoom to Window Selection Zoom > F D B BANK STATEMENT Deposits Other 8 Checies Date June 1 3 4 5 6 7 8 9 10 11 10.000 NSP Balance 16.500 18.060 16,860 16.360 15.160 24910 23,990 49.190 48,840 44,240 60.540 59.570 59.000 10 13 20 22 26 27 840 440 1.200 500 1.200 250 NO 9.00 350 4.500 700 920 35.000 17.000 50 14 15 16 Serv. Charge Interest Earned 30 600 17 18 19 20 21 June Bal June 13 deposit June 22 deposit June 29 deposit June 30 deposit Sheet1 Caschi 18,500 10.00 35.000 17.000 28.000 440 Check 100 1.200 Check 101 500 Check 1102 1.200 Check 3103 23 34 100% READY Step 10 Celle haighted in red have been filed aytamatically as they are partially attempted to an incorrect responses or attempts exhausted) Cells highlighted in green are the correspons