There is no missing columns

F G E 1 H6 D B Tiger Woods Golf Supplies 2 Cash Transactions 3 August 31, 2022 4 General Ledger Company Books Bank Statement 5 6 Transaction Type Transaction Type 7 Check 437 1,852.37 Check 437 8 Check 438 1,658.22 Check 438 9 Check 439 2,930.78 Deposit 124 10 Check 440 1,471.36 Deposit 128 11 Check 441 778.50 NSF Check 115 12 Check 442 217.82 NSF Check 118 13 Check 443 192.75 NSF Check 119 14 Check 444 2,664.18 NSF Fees 1 15 Check 445 479.91 NSF Fees 2 16 Check 446 255.41 Deposit 127 17 Check 447 239.52 Deposit 129 18 Check 448 669.14 Deposit 125 19 Check 449 906.97 Deposit 126 20 Deposit 122 232.24 Check 440 21 Deposit 123 436.76 Check 441 22 Deposit 124 260.13 Check 442 23 Deposit 125 2,173.54 Check 443 24 Deposit 126 742.57 Check 444 25 Deposit 127 851.13 Check 445 26 Deposit 128 799.09 Deposit 130 27 Deposit 129 908.65 Deposit 131 28 Deposit 130 174.59 Note Collect 1 29 Deposit 131 249.97 Interest Earned 30 Deposit 132 379.02 31 32 33 34 1,852.37 1,658.22 260.13 799.09 645.05 624.17 818.95 28.00 22.00 851.13 908.65 2,173.54 742.57 1,471.36 778.50 217.82 192.75 2,664.18 579.91 174.59 249.97 2,000.00 32.00 25 Required: 1. In cell F27, a "23" appears. What does the number -23" refer to? The difference between matching items in the two columns is 23, There is a match in the 23rd item in column C. There is a match in the 23rd item in the array appearing in cells C7.C30. 2. Given the results of the match) function analysis, does Deposit 127" in the Bank Statement column need to be reconciled? Yes No 3. The #N/A in cell C30 suggests what type of reconciling item? Outstanding deposit Bank fees Outstanding check NSF (returned) check 4. The match for Check 444 showing in cell C14 appears in what number row of the F7 F29 array? Outstanding deposit Bank fees Outstanding check NSF (returned) check 4. The match for Check 444 showing in cell C14 appears in what number row of the F7.529 array? 17 19 18 16 5. The match for Deposit 128 showing in cell F10 appears in what number row of the C7C30 array? 21 20 Cannot be determined 16 F G E 1 H6 D B Tiger Woods Golf Supplies 2 Cash Transactions 3 August 31, 2022 4 General Ledger Company Books Bank Statement 5 6 Transaction Type Transaction Type 7 Check 437 1,852.37 Check 437 8 Check 438 1,658.22 Check 438 9 Check 439 2,930.78 Deposit 124 10 Check 440 1,471.36 Deposit 128 11 Check 441 778.50 NSF Check 115 12 Check 442 217.82 NSF Check 118 13 Check 443 192.75 NSF Check 119 14 Check 444 2,664.18 NSF Fees 1 15 Check 445 479.91 NSF Fees 2 16 Check 446 255.41 Deposit 127 17 Check 447 239.52 Deposit 129 18 Check 448 669.14 Deposit 125 19 Check 449 906.97 Deposit 126 20 Deposit 122 232.24 Check 440 21 Deposit 123 436.76 Check 441 22 Deposit 124 260.13 Check 442 23 Deposit 125 2,173.54 Check 443 24 Deposit 126 742.57 Check 444 25 Deposit 127 851.13 Check 445 26 Deposit 128 799.09 Deposit 130 27 Deposit 129 908.65 Deposit 131 28 Deposit 130 174.59 Note Collect 1 29 Deposit 131 249.97 Interest Earned 30 Deposit 132 379.02 31 32 33 34 1,852.37 1,658.22 260.13 799.09 645.05 624.17 818.95 28.00 22.00 851.13 908.65 2,173.54 742.57 1,471.36 778.50 217.82 192.75 2,664.18 579.91 174.59 249.97 2,000.00 32.00 25 Required: 1. In cell F27, a "23" appears. What does the number -23" refer to? The difference between matching items in the two columns is 23, There is a match in the 23rd item in column C. There is a match in the 23rd item in the array appearing in cells C7.C30. 2. Given the results of the match) function analysis, does Deposit 127" in the Bank Statement column need to be reconciled? Yes No 3. The #N/A in cell C30 suggests what type of reconciling item? Outstanding deposit Bank fees Outstanding check NSF (returned) check 4. The match for Check 444 showing in cell C14 appears in what number row of the F7 F29 array? Outstanding deposit Bank fees Outstanding check NSF (returned) check 4. The match for Check 444 showing in cell C14 appears in what number row of the F7.529 array? 17 19 18 16 5. The match for Deposit 128 showing in cell F10 appears in what number row of the C7C30 array? 21 20 Cannot be determined 16