Open recovered workbooks? Your recent changes were saved. Do you A1 fx. Function: SUM; formula: Subtract; Cell Refe 1 Fun filions sUM; formula: 5ubtract; Cell Referencins 3 Using Excel to Prepare a Bank Reconciliation 4. Probut 3 On May 31, topet, Inc. received its bank statement from the East Coast 5avings 6. Bank A cheque from one of Lopet's customers that had been deposited during 7 the last week of May was retumed with the bank statement as NSF. The 8 company had written and malled out cheques that had not yet cleared the bank 9 Cheque #791, which was a payment for advertising expenses, was incorrectly 10 recorded in the general ledger. During the month, one of Ja's customers paid 11 their account using an electronic funds transfer. The cash receipts for May 31 12. had been deposited in the night drop slot at the bank on the evening of May 31 . 13 These were not reflected on the bank statement for May. The following 14 amounts were derived from comparing the bank statement and the accounting 15 records for May. 15 17 Student Wark Area Required: Provide inport into cells thaded in Yellow lin this template. Use mathematical formulas with cell references to the frobiom and work area as indicated. Use the stMM function with cell referencine to add amounts. a. Prepare the bank reconcilatien for lopet at Moy 31 5bow amounts that are subtracted as nezative amoorte. 317 Cath on ytatement of finardal potica prepared in part p. 2 c. Prepare the iournal entries necessarv as a result of the bank reconciliation