Question
Superior Printing, Inc. has provided its June bank statement and Cash T-account. The Controller has asked you to prepare the Bank Reconciliation at June 30
Superior Printing, Inc. has provided its June bank statement and Cash T-account. The Controller has asked you to prepare the Bank Reconciliation at June 30 using the information from the bank statement and T-account. Use the information included in the Excel Simulation and the Excel functions described below to complete the task.
Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, =B6 was entered, the formula would output the result from cell B6, or 440 in this example.
Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), - (minus sign to subtract), * (asterisk sign to multiply), and / (forward slash to divide). From the Excel Simulation below, if in a blank cell =B6+B7 was entered, the formula would add the values from those cells and output the result, or 1640 in this example. If using the other math symbols the result would output an appropriate answer for its function.
!!!!please use excel formula such as =D1+D2 rather than give me a number 123456!!!
Preparing a bank reconciliation.-Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11A A Paste B 1 u.. Clipboard r E7 -. Alignment Number Conditional Format as. Cell Cells Editing Formatting Table Styles Styles Font 1 The June bank statement and the cash T-account for Superior Printing, Inc., is shown below. BANK STATEMENT Date Checks Deposits Other Balance 4 5 June 1 6 440 1,200 500 1,200 250 80 9,800 350 4,600 700 920 600 18,500 18,060 16,860 16,360 15,160 24,910 23,990 49,190 48,840 44,240 60,540 59,570 59,000 8 10 13 20 10 10,000 NSF 840 35,000 12 13 14 15 16 26 27 29 30 30 17,000 Serv. Charge Interest Earned 50 17 30 18 Preparing a bank reconciliation.-Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11A A Paste B 1 u.. Clipboard r E7 -. Alignment Number Conditional Format as. Cell Cells Editing Formatting Table Styles Styles Font 1 The June bank statement and the cash T-account for Superior Printing, Inc., is shown below. BANK STATEMENT Date Checks Deposits Other Balance 4 5 June 1 6 440 1,200 500 1,200 250 80 9,800 350 4,600 700 920 600 18,500 18,060 16,860 16,360 15,160 24,910 23,990 49,190 48,840 44,240 60,540 59,570 59,000 8 10 13 20 10 10,000 NSF 840 35,000 12 13 14 15 16 26 27 29 30 30 17,000 Serv. Charge Interest Earned 50 17 30 18
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started