Chapter 6: Homework Saved 1. Prepare a bank reconciliation using a company's bank statement and cash account O 5 . . FILE HOME Preparing a bank reconciliation. - Excel PAGE LAYOUT FORMULAS DATA REVIEW 25 INSERT VIEW points Calibri Skipped Paste B I V A Alignment Number Cells Editing Conditional Formatas Cell Formatting Table Styles Styles Clipboard Font oBook C52 References The June bank statement and the cash T-account for Superior Printing, Inc., is shown below. BANK STATEMENT Deposits Other Date Checks June 1 10,000 440 1,200 500 1.200 250 80 9,800 350 4,600 700 18,500 18,060 16,860 16,360 15,160 24,910 23,990 49,190 48,840 44,240 60,540 840 35,000 17,000 Chapter 6: Homework Saved 1. Prepare a bank reconciliation using a company's bank statement and cash account O 5 . . FILE HOME Preparing a bank reconciliation. - Excel PAGE LAYOUT FORMULAS DATA REVIEW 25 INSERT VIEW points Calibri Skipped Paste B I V A Alignment Number Cells Editing Conditional Formatas Cell Formatting Table Styles Styles Clipboard Font oBook C52 References The June bank statement and the cash T-account for Superior Printing, Inc., is shown below. BANK STATEMENT Deposits Other Date Checks June 1 10,000 440 1,200 500 1.200 250 80 9,800 350 4,600 700 18,500 18,060 16,860 16,360 15,160 24,910 23,990 49,190 48,840 44,240 60,540 840 35,000 17,000