Excel Workbook - Balance The Ledger - Class: Spreadsheets SHOW YOUR WORK USING THE EXCEL FORMULA TO GET THE ANSWER PLEASE.. STEP 1: BELOW____

N18 X V fx A B C D E F G Date Check # Description Deposits / Withdrawals / Ending daily Additions Subtractions balance Recurring Payment authorized on 03/09 12.98 2 3/11 516.13 Google*Youtubeprem 326.65 3 3/15 Purchase authorized on 03/11 TXU*Bill Payment 800- 189.48 242-9113 3/15 Save As You Go Transfer Debit to Xxxxxxxxxxx0478 1.00 188.48 3/16 Card Claim Reversal of Final Credit 50120210046 40.00 148.48 3/17 IRS Treas 310 Taxeip3 031721 XXXXXxxxxx00918 1,400.00 1,548.48 6 Ross, Denise 3/18 Mobile Deposit : Ref Number : 117180510934 1,324.00 2,872.48 Purchase authorized on 03/17 Kelley's Country C Alvin 3/19 TX 28.00 8 $461077035521195 Card 2121 3/19 Recurring Payment authorized on 03/17 Hp *Instant Ink 855-785-2777 CA $301077080997880 Card 2121 67. 10 9 Purchase authorized on 03/19 Wal-Mart #0462 Alvin 3/19 TX 334. 11 10 P00000000484656101 Card 2121 Capital One Phone Pymt 210318 3Fk6Mnl1L6Ryw80 40.00 11 3/19 Michael P 3/19 Genesisfs Card 8669469545 210318 50.40 12 000001296166460 Denise L 3/19 Dish Network Dish Ntwrk 031921 9845832051 Spa 164.02 13 Howes, Michael 3/19 Vz Wireless Ve E Check 210318 3038062 Denise 212.39 14 *Ross 15 3/19 1061 Check 6.50 3/19 Save As You Go Transfer Debit to XXxxxxxxxxx0478 2.00 1,967.96B D E F Deposits / Withdrawals / Ending daily Check # Description Additions Subtractions balance 16 3/19 Save As You Go Transfer Debit to Xxxxxxxxxxx0478 2.00 1,967.96 3/22 Purchase authorized on 03/18 Geico *Auto Macon DC 106.68 S381077831897045 Card 212 17 Purchase authorized on 03/18 TXU*Bill Payment 800- 3/22 242-9113 280.78 18 TX S301077834636462 Card 2121 Purchase authorized on 03/19 Premier Bankcard 605- 3/22 3573440 SD 49.00 19 $301078511874246 Card 2121 Purchase authorized on 03/19 Von*Scarolinavital 866- 3/22 255-1857 46.00 20 SC S301078707587539 Card 2121 Purchase authorized on 03/19 Chili's Alvin Alvin TX 3/22 22.08 21 $461078772498177 Card 2121 Purchase authorized on 03/20 Ww Int'L-Digital 800- 3/22 221-2112 NY 19.96 22 $581079698760740 Card 2121 23 3/22 1064 Check 76.04 24 3/22 Homesite Ins Prem 031921 36767540 Howes, Michae 25.75 36767540 25 3/22 Credit One Bank Payment 210312 36705873 Michael 30.00 Howes 3/22 26 Kohl's Chg Pymt 210319 99942796 Howes Michael 32.00 3/22 1063 Check 176.44 27 Credit First NA Cfna Pymt C xxxxx6659 28 3/22 33.00 Howes, Michael P 3/22 Save As You Go Transfer Debit to Xxxxxxxxxxx0478 6.00 29 1,064.23 3/23 Purchase authorized on 03/22 Tophattbatch-47243 120.25 30 888-502-5501 CA $461081324627151 Card 2121 Genesisfs Card 8669469545 210322 3/23 000001296982329 Denise L 40.00 31 Ross 32 3/23 Save As You Go Transfer Debit to Xxxxxxxxxxx0478 1.00 902.98B C D E F Withdrawals / Check # Description Deposits / Ending daily Additions Subtractions balance 3/29 Save As You Go Transfer Debit to Xxxxxxxxxxx0478 5.00 99.22 47 Online Transfer From Ross D Way2Save Savings 3/30 Xxxxxx0478 Ref 100.00 48 db on 03/30/21 Purchase authorized on 03/28 Busy Bee Cafe #3 3/30 Alvin TX 27.51 49 $581087778339348 Card 2121 50 3/30 Save As You Go Transfer Debit to Xxxxxxxxxxx0478 1.00 170.71 Purchase authorized on 03/30 3/31 WWW.Coursehero.Com 39.95 51 888-634-9397 CA S381090034485020 Card 2121 52 3/31 Save As You Go Transfer Debit to XXxxxxxxxxx0478 1.00 129.76 5 4/2 Mobile Deposit : Ref Number :810020808262 1,000.00 1, 129.76 Purchase authorized on 04/02 0000Security-Finan 4/5 800-3958195 158.00 54 SC $461092627451031 Card 2121 Purchase authorized on 04/02 Ameriwaste Inc 281- 4/5 1-8400 TX 44.32 55 $461092629253933 Card 2121 Purchase authorized on 04/03 WM Superc Wal-Mart 4/5 Sup Alvin TX 53.65 P00000000777434765 Card 2121 Purchase authorized on 04/04 WM Superc Wal-Mart 4/5 Sup Alvin TX 22.73 57 P00000000670804756 Card 2121 58 4/5 Save As You Go Transfer Debit to XXxxxxxxxxx0478 4.00 847.06 Purchase authorized on 04/05 Spdpy*American Cre 4/6 Spartanburg 232.64 SC S301095619926260 Card 2121 4/6 Save As You Go Transfer Debit to Xxxxxxxxxxx0478 1.00 613.42 4/7 1066 Check 100.00 513.42 61 Ending on 4/8 513.42 62 balance Totals $3,824.00 $3,839.69 63 64