Required information The following information applies to the questions displayed below.) In this Applying Excel exercise you will practice using cell referencing and formulas to create a bank reconciliation Watch the tutorial video and then complete Parts 1 and 2 to practice and apply the skills demonstrated in the video. Revise your worksheet to reflect the following transactions and updated values at the end of the accounting period, then answer the questions that follow. (Note: You do not need to upload your revised worksheet for Part 2.) 1 Cash on hand at the company and not yet deposited at the bank. 2 EFT for monthly utility bill not yet recorded by the company. 3 Note collected by the bank and not yet recorded by the company. 4 Interest collected by the bank fron note in #3 not yet recorded by the company. 5 A check witten for insurance expense for $110 was cashed. The check was recorded on the books for $170. 6 Checks written by the company but not yet processed by the bank. 7 Service fee charged by bank but not yet recorded by the company. R Customer checks determined by the bank to have nonsufficient funds. Thank balance at the end of the period. Company balance at the end of the period. 3,800 1,300 9,800 1,100 2 3,600 200 2,500 22,250 15,390 Required: 1-a. What is the revised Cash balance at the end of the period? a Cash 1-b. Is the bank reconciliation in balance? Yes O No 2-a. What is the balance in Cash if the entry to correct the insurance payment hasn't been made? Cash 2-b. Would the bank reconciliation still be in balance? O Yes O No 3. Which statement below is true regarding the effect of the company incorrectly recording a customer deposit at $150,000 rather than $15,000? O No effect on the bank reconciliation . The difference of $135,000 will be subtracted from the book balance. . The difference of $135,000 will be added to the book balance. The bank balance will be increased by $150,000