correct answers
Chapter 6 Excel Save 1 QIB FILE Preparing a bank reconciliation - Excel FORMULAS DATA REVIEW HOME INSERT PAGE LAYOUT VIEW Sign in Calibri -11 %6 , X 19 - Paste AN HA- BTU. 90 - Cells Editing 100 points Alignment Number Conditional Formats Cell Formatting Table Styles Styles Clipboard Font eBook References A1 The June bank statement and the cash T-account for Superior Printing Company is. A B C 0 E F The June bank statement and the cash account for Superior Printing Company is shown below. 2 3 BANK STATEMENT 4 Date checks Deposits Other Balance 5 June 1 18,500 6 440 18,060 7 1,200 16,860 8 8 500 16,360 10 1,200 15,160 10 13 250 10,000 24.910 11 20 80 NSF 840 23,990 12 22 9,800 35,000 49,190 26 350 48,840 14 27 4,600 44,240 29 700 17,000 60,540 16 30 920 Serv. Charge 50 59,570 Interest 17 30 600 30 Earned 59,000 18 19 Cash ALE Prey 1 of 1 Next Q 1 Preparing a bank reconciliation - Excel FORMULAS DATA REVIEW FILE VIEW HOME INSERT PAGE LAYOUT X Calibri 11 AA % Cells Editing Paste B TV- BH- . A- Alignment Number Conditional Format as Cel Formatting Table Styles 100 point Fent 18 Styles Clipboard A1 > A The June bank statement and the cash T-account for Superior Printing Company is Book F A E B C References D Interest Earned 30 17 600 30 59,000 18 19 20 21 22 23 June 1 Bal June 13 deposit June 22 deposit June 29 deposit June 30 deposit Cash 18,500 10,000 35,000 17,000 28,000 24 25 26 27 28 29 30 31 440 Check 8100 1,200 Check #101 500 Check #102 1,200 Check #103 250 Check #104 80 Check #105 9,800 Check #106 350 Check #107 4,600 Check #108 770 Check #109 4,900 Check #110 700 Check #111 920 Check #112 600 Check #113 32 33 34 36 AN one Prey 1 of 1 Next ? 1 Preparing bank reconciliation Excel FORMULAS DATA REVIEW INSERT HOME PAGE LAYOUT VIEW Sitonin X Citi 11 %6 - AA A- Paste Cells BIU- EB- Editing 100 ports Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font TO A1 The June bank statement and the cash T-account for Superior Printing Company is. ebook References B D E F 920 Check #112 34 600 Check #113 35 June 30 Bal 82.190 36 37 Required: 38 Prepare a bank reconciliation for June using the bank statement and T-account above and the information below. 39 Additional information: 40 There were no deposits in transit or outstanding checks at May 31 41 Note: Columns Cond F must be entered as positive values. In columns 8 & E, use cell references 42 to the appropriate items from the list below. List "Deductions in chronological order (earliest Item first). 43 Bank Error NSF Check 44 Deposits in Transit Outstanding Checks 45 EFT from Customer Recording Error 46 Interest Earned Service Charge 47 48 SUPERIOR PRINTING COMPANY 49 Bank Reconciliation 50 At June 30 51 Updates to Bank Statement Updates to Company's Books Inzell B Prey 1 of 1 Next Colibri 11 A A 1 Paste BIU- Cells Editing Alignment Number Conditional Format as Cel Formatting Table Styles Styles Clipboard Font A1 X The June bank statement and the cash T-account for Superior Printing Company is. 100 points F ebook References B D E 41 Note: Columns Cand F must be entered as positive values. In columns 8 & E, use cell references 42 to the appropriate items from the list below. List "Deductions" in chronological order (earliest item first). 43 Bank Error NSF Check 44 Deposits in Transit Outstanding Checks 45 EFT from Customer Recording Error 46 Interest Earned Service Charge 47 48 SUPERIOR PRINTING COMPANY 49 Bank Reconciliation 50 At June 30 51 Updates to Bank Statement Updates to Company's Books 52 Bank statement balance Book balance 53 Additions: Additions: 54 55 Deductions: Deductions: 56 57 58 Adjusted bank balance Adjusted book balance 59 60 61 62 Prey 1 of 1 Nex
