Download the Excel file attached and perform the following steps: (Note: This wo

Question

Download the Excel file attached and perform the following steps: (Note: This worksheet is protected only type your data in the yellow cells). so 1. Type the ending bank balance as of July 29 in cell B5 2. Type the checkbook balance as of June 30 in cell E5. 3. Using cells G5 through G24, type the deposit amounts that Jarod made in July. You will not need all the cells provided. 4. Using cells H5 through H58, type the check numbers of the checks that Jarod wrote in July You will not need all the cells provided. 5. Using cells I5 through 158, type the check amounts that relate to the check numbers you typed in cells H5 through H58. You will not need all the cells provided. in cells D10 through E14, type in the adjustments needed to make the amount in cell 15 equal the ending balance in Jarod's checkbook as of July 29. The description of the adjustments should be in cells D10 through D14; the amounts should be in cells E10 through E14. (Note: When you are done, the amount in cell E15 should exactly equal the the final balance on page 163). These adjustments would include any errors that Jarod made in his checkbook and any amounts that were deducted from his checkbook that were not written with a check. 7. In cell B18, type the amount of the cumulative errors (positive or negative) that Jarod made in 8. In cell B21, type the amount of any bank fees and charges not recorded in Jarod's checkboo 9. In cells 824 and B25, type the amounts of any other charges that appeared on the bank his checkbook. In cell D18 type the words Checkbook errors" Enter the amount as a negative number. In cell D21 type the words "Bank charges statement that Jarod did not enter in his checkbook register. Enter the amoun uri IhcelS 24 and D25 type the descriptions of the adjustments

Explanation / Answer

As this is not able to open in excel i am writing the answers to the above questions directly.Please,regret me.

1. Ending bank balance as of July 29 in cell B5 is 1797.39.

2. Checkbook balance as of June 30 in cell E5 is 1884.17.

3. On 23rd a deposit of $500 has been made by Jarod.

4. 1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086. These are the check numbers which Jarod wrote in July.

5. $100, $45.20, $147.11, $69.75, $27.81, $302.20, $37.87, $350, $20.50, $1599.11, $125, $28.56, $47.25, $9.16. These are amounts of the check numbers given above respectively.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.