He Excel SIM: Preparing a bank reconciliation. 1. Prepare a bank reconciliation using a company's bank statement and cash account 7 - Preparing a bank reconciliation - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign in Calib 1 B- Paste BTU AA 96 A Alignment Number Conditional Format as Cell Formatting Table Styles Celes E Co Fort A11 > to 20 + B C D E The lune bank statement and the cash Taccount for Superior Printing Company is shown below. 2 3 4 Date June 1 Checies BANK STATEMENT Deposits Other Balance 18,500 18,050 t 440 Prey 1 of 1 !!! Noxd 15 GO 16 GO fB 19 no f 18 9 # 3 % 5 4 6 7 8 9 0 E R. 5 6 U Book D 1 The lune bank statement and the cash account for Superior Printing Company is shown below. 2 3 BANK STATEMENT 4 Checks Deposits Other 5 June 1 6 3 440 7 4 1,200 8 8 SOO 9 10 1,200 10 13 10,000 11 20 80 NSE 840 12 9,800 35,000 26 350 14 27 4,600 15 29 700 17,000 16 30 920 Serv. Charge SO 17 30 Interest 30 Earned 18 19 Cash 20 June 1 Bal 18,500 Balance 18,500 18,060 16,860 16,360 15,160 24,910 23,990 49,190 48,800 44,240 60,540 59,570 rences 600 59,000 Prev 1 of 1 !!! Next > f3 15 0 f6 17 18 19 f10 B # $ 8 9 3 % 5 4 & 7 6 8 9 0 W E R. T Y 5 Excel 10 10. 13 1,200 250 30 10,000 11 12 NSE 35,000 350 20 22 26 27 29 30 15,160 24,910 23,990 49,190 48,840 44,240 60,540 59,570 15 16 17,000 50 17 30 600 Serv. Charge Interest Earned 30 59,000 Sk 18 19 20 Carsh 21 22 June 1 Bal June 13 deposit June 22 deposit June 29 deposit Sheet1 18,500 10,000 35,000 17.000 440 Check 0100 1,200 Check 101 500 Check 102 READY Attempt AVERAGE 2628333333 SUM 16970 100% Prev 1 of 1 Next 13 14 15 go 16 CD f7 00 f8 19 f10 112 # $ % 5 3 4 & 7 6 8 9 0