154 Excel for Accounting Chapter 5: Bank Reconciliation Extend Your Skills EA5-E1 Complete a Bank Reconciliation for Jukebox Repair, Inc. In this exercise, you will complete a bank reconciliation as of 12/31/2016 for Jukebox Repair, Inc. One of your primary goals is to ensure that the file can be easily understood by the end user. Use this information to populate the reconciliation: Deposits in Transit: $400 and $700 NSF Check: $600 Notes Receivable: $1,500 Outstanding Checks: $1,000 and $500 Bank Charges: $300 When recording check #854 for $1,600, the company erroneously reduced the cash balance by $2,500. The bank statement reflects a 12/31/16 balance of $6,200, while the company's general ledger reflects a 12/31/16 cash balance of $4,300. Modify the appearance of the reconciliation using Format Painter and Quick Styles. Set a conditional formatting rule that will highlight the bank balance if it exceeds $5,000. Apply a header that displays the filename and a footer that displays the current date. Ensure that all column widths, row heights, and font sizes are appropriately adjusted