In this lab, you will: Required: 1. Find the items that need to be reconciled between the company's general ledger and the bank statement. Ask the Question: Can we use conditional formatting to highlight reconciling items for a bank reconciliation? Master the Data: Apply the same steps as Lab 5-2 to the Lab 5-2 Alt Data.xlsx dataset, with a completed formatted trial balance. Software needed Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) . Data: Excel File Lab 5-2 Alt Data.xlsx Perform the Analysis: Refer to Lab 5-2 Alternate in the text for instructions and Lab 5-2 steps for each the of lab parts. Share the Story: Bank reconciliations are a basic internal control used by companies to ensure that their cash transactions are properly recorded. By comparing the cash transactions to the independent records of a bank, the company and its auditors can be more certain that its cash transactions are properly recorded. The company may also use this to identify bank errors. A B G 1 Vern Richardson CPA 2 Cash Transactions 3 July 31, 2022 4 General Ledger/ Company Books Bank Statement 5 6 Transaction Type Transaction Type 7 Check 722 2,669.14 Check 722 8 Check 723 2,106.89 Check 723 9 Check 724 2,632.24 Deposit 224 10 Check 725 2,436.76 Deposit 228 11 Check 726 2,060.13 Deposit 227 12 Check 727 2,173.54 Deposit 225 13 Check 728 2,242.57 Deposit 226 14 Check 729 1,851.13 Deposit 223 15 Check 730 2,025.09 Deposit 229 16 Check 731 1,908.65 Deposit 230 17 Check 732 1,674.59 Check 725 18 Check 733 2,749.97 Check 726 19 Check 734 1,379.02 Check 727 20 Deposit 223 1,852.37 Check 728 21 Deposit 224 1,658.22 Check 729 22 Deposit 225 2,930.78 Check 730 23 Deposit 226 1,371.63 Note Collect 1 24 Deposit 227 2,778.50 Interest Earned 25 Deposit 228 2,417.82 NSF Check 213 26 Deposit 229 1,926.75 NSF Check 217 27 Deposit 230 1,664.18 NSF Fees 1 28 Deposit 231 1,479.91 NSF Fees 2 29 Deposit 232 2,255.74 Deposit 231 30 Deposit 233 2,329.55 31 2,669.14 2,106.89 1,658.22 2,417.82 2,778.50 2,930.78 1,371.63 1,852.37 1,926.75 1,664.18 2,436.76 2,060.13 2,173.54 2,242.57 1,851.13 2,025.09 1,500.00 11.05 2,645.05 924.17 18.00 19.00 1,479.91 Required: 1. Check 724 would be an example of a(n) O outstanding deposit O outstanding check O NSF check O bank fee 2. The conditional formatting rule we set up highlights values but not values. O duplicate; unique O unique; duplicate O unique; unusual O duplicate; unusual 3. Deposit 232 would be an example of a(n) O outstanding deposit O bank fee O NSF check O outstanding check 4. The $11.05 in interest earned still needs to be recorded by the: O bank in their transaction log O company in the general ledger 5. Deposit 225 as an exception, because it appear in both columns. is shown; does is shown; does not O is not shown; does not O is not shown; does