Answered step by step
Verified Expert Solution
Question
1 Approved Answer
help please and show work for the worksheet it would realky help The People's Choice Bank is a small community bank that has three local
help please and show work for the worksheet it would realky help
The People's Choice Bank is a small community bank that has three local branches, in Blue Ash, Delhi, and Anderson Hills. The Excel file Peoples Choice Bank is a database of major account transactions for the month of August. 1. Note that it is difficult to determine whether each transaction in the Amount column represents a positive cash inflow or a negative cash outflow without information in other columns. Modify the database as appropriate to more easily analyze the data, 2. Suppose that you have been asked to prepare a summary of these transactions that would be clear and meaningful to the bank's president. Use PivotTables (that are well-designed and properly formatted) to provide a summary of the key information that the president and his direct reports would want to know. Justify and explain your reasoning. \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & C & D & E & G \\ \hline 83 7-Aug & Thursday & Checking & Deposit & $2,830,00 Current & Delhi \\ \hline 4. 7-Aug & Thursday & Checking & Withdrawal & $3,010.00 Current & Anderson Hills \\ \hline 35/7-Aug & Thursday & Checking & Deposit & $3,110.00 Current & Blue Ash \\ \hline 86 7-Aug & Thursday & Checking & Withdrawal & $930.00 Current & Anderson Hills \\ \hline 87 7-Aug & Thursday & Checking & Deposit & $3,680.00 Current & Delhi \\ \hline 188 7-Aug & Thursday & Checking & Deposit & $3,810.00 Current & Delhi \\ \hline 89 7-Aug & Thursday & Checking & Withdrawal & $2,780.00 Current & Anderson Hills \\ \hline 90 8-Aug & Friday & Savings & New Account & $500.00New & Blue Ash \\ \hline 91 8-Aug & Friday & Checking & New Account & $220.00New & Delhi \\ \hline 192 8-Aug & Friday & Checking & New Account & $430.00New & Anderson Hills \\ \hline 93 8-Aug & Friday & Checking & New Account & $990.00New & Anderson Hills \\ \hline 94 8-Aug & Friday & Certificate of Deposit & New Account & $26,600.00New & Anderson Hills \\ \hline 95 8-Aug & Friday & Certificate of Deposit & New Account & $36,900.00New & Anderson Hills \\ \hline 968 -Aug & Friday & Certificate of Deposit & New Account & $15,100.00New & Blue Ash \\ \hline 78-Aug & Friday & Savings & Withdrawal & $1,100.00 Current & Anderson Hills \\ \hline 98 8-Aug & Friday & Savings & Deposit & $1,900,00 Current & Anderson Hills \\ \hline 99 8-Aug & Friday & Savings & Withdrawal & $2,000.00 Current & Anderson Hills \\ \hline 8-Aug & Friday & Savings & Deposit & $1,200,00 Current & Anderson Hills \\ \hline 18-Aug & Friday & Savings & Deposit & $2,200.00 Current & Delhi \\ \hline 2 8-Aug & Friday & Savings & Deposit & $1,200.00 Current & Blue Ash \\ \hline 3 8-Aug & Friday & IRA & Current Contributiol & $2,000.00 Current & Anderson Hills \\ \hline 4 8-Aug & Friday & Checking & Deposit & $150.00 Current & Blue Ash \\ \hline 15 8-Aug & Friday & Checking & Withdrawal & $2,860.00 Current & Anderson Hills \\ \hline 6 8-Aug & Friday & Checking & Deposit & $500.00 Current & Anderson Hills \\ \hline 8-Aug & Friday & Checking & Withdrawal & $700.00 Current & Anderson Hills \\ \hline 8-Aug & Friday & Checking & Deposit & $680.00 Current & Anderson Hills \\ \hline 9-Aug & Saturday & Savings & New Account & $300.00New & Anderson Hills \\ \hline 109-Aug & Saturday & Savings & New Account & $2,200,00New & Anderson Hills \\ \hline 11 9-Aug & Saturday & Checking & New Account & $90.00NeW & Anderson Hills \\ \hline 129-Aug139-Aug & Saturday & Checking & New Account & $150.00New & Anderson Hills \\ \hline 9-Aug & Saturday & Checking & New Account & $230.00New & Blue Ash \\ \hline & Data & + & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & C & D & E & G \\ \hline 4411 -Aug & Monday & Checking & Deposit & $2,940.00 Current & Blue Ash \\ \hline 11-Aug & Monday & Checking & Deposit & $2,810.00 Current & Anderson Hills \\ \hline 611 -Aug & Monday & Checking & Deposit & $630.00 Current & Blue Ash \\ \hline 11-Aug & Monday & Checking & Withdrawal & $570.00 Current & Delhi \\ \hline 11-Aug & Monday & Checking & Deposit & $1,020.00 Current & Anderson Hills \\ \hline 11-Aug & Monday & Checking & Withdrawal & $940.00 Current & Anderson Hills \\ \hline 11-Aug & Monday & Checking & Deposit & $90.00 Current & Anderson Hills \\ \hline 12-Aug & Tuesday & Savings & New Account & $1,600.00New & Blue Ash \\ \hline 12-Aug & Tuesday & Checking & New Account & $770.00New & Anderson Hills \\ \hline 12-Aug & Tuesday & Checking & New Account & $3,670.00New & Anderson Hills \\ \hline A 12-Aug & Tuesday & Checking & New Account & $960.00New & Blue Ash \\ \hline 12 -Aug & Tuesday & Certificate of Deposit & New Account & $29,000.00New & Anderson Hills \\ \hline 12-Aug & Tuesday & Savings & Deposit & $1,100.00 Current & Delhi \\ \hline 12-Aug & Tuesday & Savings & Deposit & $1,800.00 Current & Anderson Hills \\ \hline 8 12-Aug & Tuesday & Savings & Deposit & $1,100.00 Current & Anderson Hills \\ \hline 9. 12-Aug & Tuesday & Savings & Withdrawal & $1,400.00 Current & Blue Ash \\ \hline 10. 12-Aug & Tuesday & Savings & Deposit & $1,700.00 Current & Delhi \\ \hline 61 12-Aug & Tuesday & Checking & Deposit & $50.00 Current & Blue Ash \\ \hline 6. 12-Aug & Tuesday & Checking & Withdrawal & $850.00 Current & Delhi \\ \hline 63 12-Aug & Tuesday & Checking & Deposit & $2,660.00 Current & Blue Ash \\ \hline 6412 -Aug & Tuesday & Checking & Withdrawal & $520.00 Current & Anderson Hills \\ \hline 65 12-Aug & Tuesday & Checking & Withdrawal & $980.00 Current & Delhi \\ \hline 6612-Aug6712-Aug & Tuesday & Checking & Withdrawal & $220.00 Current & Anderson Hills \\ \hline 6)12-Aug6812-Aug & Tuesday & Checking & Withdrawal & $580.00 Current & Blue Ash \\ \hline 12-Aug6912-Aug & TuesdayTuesday & Certificate of Deposit & New & $7,100.00 Current & Delhi \\ \hline 70. 13-Aug & TuesdayWednesday & CertificateofDepositSavings & New & $18,100.00 Current & Anderson Hills \\ \hline 1) 13-Aug & Wednesday & & New Account & $700.00New & Anderson Hills \\ \hline 72 13-Aug & Wednesday & SavingsSavings & New Account & $800.00New & Anderson Hills \\ \hline 273 13-Aug & Wednesday & SavingsChecking & New Account & $2,700.00New & Blue Ash \\ \hline 274 13-Aug & Wednesday & Checking & NewAccountNewAccount & $300.00New & Blue Ash \\ \hline & Data & & & $270.00 New & Anderson Hills \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline A & A & e & D & 1 & G \\ \hline 15-Aug & Friday & IRA & Current Contributior & 23,900 00 eurent & Andersen Hiils \\ \hline 15-Aug & Friday & Checking & Withdrawal & q280 00 Curreni & Andersen Hillis \\ \hline 8 15-Aug & Friday & Cheoking & Deposit & 93,30000 eurrent & Alue Ash \\ \hline 19. 15-Aug & Friday & Cheoking & Depesit & $2,74000 cument & Delhi \\ \hline 40 15-Aug & Friday & Checking & Withdrawal & 83000 Eurreni & Andersen Hills \\ \hline 41 15-Aug & Friday & Cheoking & Deposil & 9840.00 emrent & Andersen tiils \\ \hline 12 15-Aug & Friday & Cheoking & Withdrawal & 29500 00 Current & Dellit \\ \hline 43 15-Aug & Friday & Checking & Withdrawal & soto 00 Current & Hilue Ash \\ \hline 44 15-Aug & Friday & Cheeking & Withdrawal & 9310.00 Curient & Blue Ash \\ \hline 45 15-Aug & Friday & Cheoking & Deposit & $1,010.00 Current & Andersen Hiils \\ \hline 46 15-Aug & Friday & Checking & Withdrawal & 8500.00 Curtent & Blue Ash \\ \hline 47 15-Aug & Friday & Certifieate of Deposit & New & $10,000,00 Current & Blue Ash \\ \hline 48 16-Aug & Saturday & Savings & New Aeeount & $2,00000New & Andersen Hills \\ \hline 149 16-Aug & Saturday & Savings & New Apeount & $90000 New & Andersen Hilis \\ \hline 50 16-Aug & Saturday & Cheoking & New Aecount & 83,170,00NeW & Delhi \\ \hline 151 16-Aug & Saturday & Savings & Withdrawal & $900.00 Current & Alue Ash \\ \hline 152 16-Aug & Saturday & Savings & Deposit & $200.00 Current & Andersen Hills \\ \hline 153 16-Aug & Saturday & Checking & Deposit & $2,800,00 Current & Dellai \\ \hline 354 16-Aug & Saturday & Cheoking & Deposit & $640.00 eurrent & Andersen Hills \\ \hline 355 16-Aug & Saturday & Checking & Withdrawal & $590.00 Current & Andersen Hiils \\ \hline 156 16-Aug & Saturday & Checking & Deposit & $020.00 Current & Andersen Hiils \\ \hline 57 18-Aug & Monday & Savings & New Aceount & $1,700.00New & Blue Ash \\ \hline 8 18-Aug & Monday & Savings & New Aceount & $1,000,00New & Alue Ash \\ \hline 59 18-Aug & Monday & Cheeking & New Acoount & $490.00 New & Delhi \\ \hline 60 18-Aug & Monday & Certificate of Deposit & New Acoount & 355,400,00 New & Andersen Hills \\ \hline 6) 18-Aug & Monday & Certifieate of Deposit & New Aceount & $47,200,00 New & Alue Ash \\ \hline 362 18-Aug & Monday & Certifieate of Deposit & New Account & $10,200,00 New & Andersen Hills \\ \hline 63 18-Aug & Monday & Certificate of Deposit & New Aepeunt & $29,600,00 New & Delhi \\ \hline 64 18-Aug & Monday & Savings & Deposit & $1,100.00 Current & Andersen Hiils \\ \hline 65 18-Aug & Monday & Savings & Deposit & $800.00 eurtent & Andersen Hills \\ \hline 66 18-Aug & Monday & Savings & Deposit & $500.00 Current & Delhi \\ \hline & Data & + & & & \\ \hline \end{tabular} coss File Home Insert Draw Page Layout Formulas Data Review View Automate Help Q185 fx 82F Sunny. Q185 fx \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & c & D & f & 6 \\ \hline 50 21-Aug & Thursday & Checking & Deposit & $3,250,00 Current & Anderson Hills \\ \hline 21-Aug & Thursday & Checking & Deposit & $3,650,00 Current & Delhi \\ \hline 21-Aug & Thursday & Checking & Deposit & $920.00 Current & Anderson Hills \\ \hline 21-Aug & Thursday & Checking & Withdrawal & $760.00 Current & Anderson Hills \\ \hline 21-Aug & Thursday & Checking & Deposit & $760.00 Current & Anderson Hills \\ \hline 21-Aug & Thursday & Checking & Deposit & $240.00 Current & Anderson Hills \\ \hline 21-Aug & Thursday & Certificate of Deposit & New & $28,000,00 Current & Anderson Hills \\ \hline 21-Aug & Thursday & Certificate of Deposit & New & $15,100.00 Current & Anderson Hills \\ \hline 21-Aug & Thursday & Certificate of Deposit & New & $59,600.00 Current & Blue Ash \\ \hline 22-Aug & Friday & Savings & New Account & $100.00 New & Anderson Hills \\ \hline 22-Aug & Friday & Checking & New Account & $830.00 New & Blue Ash \\ \hline 22-Aug & Friday & Certificate of Deposit & New Account & $58,600.00New & Delhi \\ \hline 22-Aug & Friday & Certificate of Deposit & New Account & $49,900.00New & Anderson Hills \\ \hline 22-Aug & Friday & Certificate of Deposit & New Account & $55,000,00New & Anderson Hills \\ \hline 4 22-Aug & Friday & Certificate of Deposit & New Account & $15,000,00New & Anderson Hills \\ \hline 22-Aug & Friday & Certificate of Deposit & New Account & $35,900,00New & Anderson Hills \\ \hline 22-Aug & Friday & Savings & Deposit & $400.00 Current & Blue Ash \\ \hline 77 22-Aug & Friday & Savings & Withdrawal & $2,700.00 Current & Anderson Hills \\ \hline 78 22-Aug & Friday & Savings & Deposit & $900.00 Current & Blue Ash \\ \hline 179 22-Aug & Friday & IRA & Current Contributiol & $1,700.00 Current & Delhi \\ \hline 80 22-Aug & Friday & Checking & Deposit & $3,900,00 Current & Anderson Hills \\ \hline 181 22-Aug & Friday & Checking & Deposit & $3,690.00 Current & Delhi \\ \hline 182 22-Aug & Friday & Checking & Deposit & $840.00 Current & Blue Ash \\ \hline 183 22-Aug & Friday & Checking & Withdrawal & $760.00 Current & Blue Ash \\ \hline 184 22-Aug & Friday & Checking & Deposit & $810.00 Current & Anderson Hills \\ \hline 485 22-Aug & Friday & Checking & Deposit & $790.00 Current & Anderson Hills \\ \hline 6 22-Aug & Friday & Checking & Deposit & $300.00 Current & Blue Ash \\ \hline 22-Aug & Friday & Checking & Withdrawal & $1,000,00 Current & Anderson Hills \\ \hline 8 22-Aug & Friday & Checking & Withdrawal & $970.00 Current & Anderson Hills \\ \hline 489 22-Aug & Friday & Checking & Withdrawal & $460.00 Current & Blue Ash \\ \hline 90 23-Aug & Saturday & Savings & New Account & $2,400,00 New & Delhi \\ \hline> & Data & & & & \\ \hline \end{tabular} Ready ir Accessibility; investigate 01851fx \begin{tabular}{|c|c|c|c|c|c|c|} \hline A & B & C & D & F & G & H \\ \hline 19. Aug & Tuesday & Certificate of Deposit & New Account & $37,300.00New & Blue Ash & \\ \hline 19. Aug & Tuesday & Savings & Withdrawal & $1,700.00 Current & Anderson Hills & \\ \hline 00 19-Aug & Tuesday & Savings & Deposit & $600.00 Current & Anderson Hills & \\ \hline 91 19-Aug & Tuesday & Savings & Deposit & $500.00 Current & Delhi & \\ \hline 02 19-Aug & Tuesday & Savings & Withdrawal & $2,800,00 Current & Anderson Hills & \\ \hline 103 19-Aug & Tuesday & Savings & Deposit & $2,400,00 Current & Delhi & \\ \hline 101 19-Aug & Tuesday & Savings & Deposit & $400.00 Current & Anderson Hills & \\ \hline 405 19-Aug & Tuesday & Savings & Deposit & $2,700.00 Current & Anderson Hills & \\ \hline 106 19-Aug & Tuesday & Savings & Deposit & $1,200.00 Current & Anderson Hills & \\ \hline 407 19-Aug & Tuesday & Savings & Withdrawal & $2,300.00 Current & Blue Ash & \\ \hline 108 19-Aug & Tuesday & Savings & Deposit & $2,500.00 Current & Anderson Hills & \\ \hline A09 19-Aug & Tuesday & Savings & Deposit & $300.00 Current & Anderson Hills & \\ \hline 110 19-Aug & Tuesday & Savings & Deposit & $1,200.00 Current & Delhi & \\ \hline 411 19-Aug & Tuesday & IRA & Current Contributiol & $1,700.00 Current & Blue Ash & \\ \hline 412 19-Aug & Tuesday & Checking & Deposit & $990.00 Current & Anderson Hills & \\ \hline 413 19-Aug & Tuesday & Checking & Withdrawal & $120.00 Current & Blue Ash & \\ \hline 414 19-Aug & Tuesday & Checking & Withdrawal & $160.00 Current & Anderson Hills & \\ \hline 115 19-Aug & Tuesday & Checking & Withdrawal & $3,530.00 Current & Delhi & \\ \hline 416 19-Aug & Tuesday & Checking & Withdrawal & $980.00 Current & Anderson Hills & \\ \hline 117 19-Aug & Tuesday & Checking & Deposit & $3,250.00 Current & Blue Ash & \\ \hline 118 19-Aug & Tuesday & Checking & Withdrawal & $30.00 Current & Anderson Hills & \\ \hline 419 19-Aug & Tuesday & Checking & Deposit & $60.00 Current & Anderson Hills & \\ \hline 420 19-Aug & Tuesday & Checking & Withdrawal & $310.00 Current & Anderson Hills & \\ \hline 421 19-Aug & Tuesday & Checking & Deposit & $670.00 Current & Delhi & \\ \hline 42) 19-Aug & Tuesday & Checking & Withdrawal & $230.00 Current & Anderson Hills & \\ \hline 423 19-Aug & Tuesday & Certificate of Deposit & New & $15,300.00 Current & Anderson Hills & \\ \hline 424 19-Aug & Tuesday & Certificate of Deposit & New & $18,700.00 Current & Delhi & \\ \hline 125 19-Aug & Tuesday & Certificate of Deposit & New & $40,800.00 Current & Anderson Hills & \\ \hline 426 20-Aug & Wednesday & Savings & New Account & $400.00New & Delhi & \\ \hline 42120 -Aug & Wednesday & Savings & New Account & $500.00New & Anderson Hills & \\ \hline 428 20-Aug & Wednesday & Checking & New Account & $2,510.00New & Anderson Hills & \\ \hline & Data & + & & & & \\ \hline \end{tabular} Q185 \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & c & D & E & 6 \\ \hline 9-Aug & Saturday & Checking & New Account & $230.00 New & Bive Ash \\ \hline 9-Aug & Saturday & Savings & Withdrawal & $1,300.00 Current & Anderson Hillis \\ \hline 9-Aug & Saturday & IRA & Current Contributiol & $1.500.00 Current & Anderson Hills \\ \hline 9-Aug & Saturday & IRA & Current Contributiol & $3,400,00 Current & Dehi \\ \hline 9-Aug & Saturday & Checking & Deposit & $3.530.00 Current & Anderson Hills \\ \hline 9-Aug & Saturday & Checking & Deposit & $710.00 Current & Delhi \\ \hline 9-Aug & Saturday & Checking & Withdrawal & $200,00 Current & Anderson Hills \\ \hline 9.Aug & Saturday & Checking & Deposit & $120.00 Current & Anderson hills \\ \hline 9-Aug & Saturday & Certificate of Deposit & New & $44,90000 Current & Delh \\ \hline 11-Aug & Monday & Savings & New Account & $100.00 New & Anderson Hills \\ \hline 11-Aug & Monday & Savings & New Account & $2.000.00New & Delhi \\ \hline 11-Aug & Monday & Savings & New Account & $2,100,00New & Anderson Hills \\ \hline 11 -Aug & Monday & Savings & New Account & $70000 New & Bive Ast \\ \hline 11-Aug & Monday & Checking & New Account & $2,820,00New & Delhi \\ \hline 711 -Aug & Monday & Checking & New Account & $3.29000 New & Delhi \\ \hline 11-Aug & Monday & Certificate of Deposit & New Account & $51,300,00 New & Anderson Hills \\ \hline 11-Aug & Monday & Certificate of Deposit & New Account & $6,600.00New & Blue Ash \\ \hline 11-Aug & Monday & Certificate of Deposit & New Account & $29,000,00 New & Blue Ast \\ \hline 31 11-Aug & Monday & Certificate of Deposit & New Account & $20,400 00 New & Bive Ash \\ \hline 211 -Aug & Monday & Savings & Deposit & $2,700,00 Current & Delh \\ \hline 11-Aug & Monday & Savings & Deposit & $2.200.00 Current & Anderson Hills \\ \hline 34 11-Aug & Monday & Savings & Deposit & $900.00 Current & Blue Ash \\ \hline 5 11-Aug & Monday & Savings & Deposit & $300 00 Current & Anderson Hills \\ \hline 6. 11-Aug & Monday & Savings & Deposit & $2.700.00 Current & Delhi \\ \hline 17 11-Aug & Monday & Savings & Deposit & $70000 Current & Delhi \\ \hline 11-Aug & Monday & Savings & Deposit & $1,50000 Current & Dehi \\ \hline 9 11-Aug & Monday & Savings & Withdrawal & $1,100,00 Current & Blue Ash \\ \hline 11-Aug & Monday & Savings & Deposit & $300 00 Current & Blue Ast \\ \hline 11-Aug11-Aug & Monday & Savings & Deposit & $600,00 Current & Delin \\ \hline 11-Aug4)11-Aug & MondayMonday & IRAIRA & Current Contributior & $1,100.00 Current & Blue Ash \\ \hline ... & Data & ++IRA & Current Contributioi & $3,100,00 Cument & Anderson Hills \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & c & D & E & \\ \hline 18-Aug & Monday & IRA & Current Contributio & $1,300.00 Current & Anderson Hills \\ \hline 18-Aug & Monday & IRA & New Account & $6,400.00 Current & Blue Ash \\ \hline 18-Aug & Monday & Checking & Withdrawal & $430.00 Current & Anderson Hills \\ \hline 18-Aug & Monday & Checking & Deposit & $280.00 Current & Anderson Hills \\ \hline 18 Aug & Monday & Checking & Deposit & $800.00 Current & Blue Ash \\ \hline 18 Aug & Monday & Cheoking & Deposit & $140.00 Current & Anderson Hills \\ \hline 73 18-Aug & Monday & Checking & Deposit & $130.00 Current & Blue Ash \\ \hline 14. 18-Aug & Monday & Checking & Withdrawal & $810.00 Current & Anderson Hills \\ \hline 5 18-Aug & Monday & Checking & Deposit & $510.00 Current & Delhi \\ \hline to 18 -Aug & Monday & Checking & Deposit & $650.00 Current & Anderson Hills \\ \hline 7) 18-Aug & Monday & Checking & Deposit & $420.00 Current & Anderson Hills \\ \hline 13 19-Aug & Tuesday & Savings & New Account & $2,700,00 New & Blue Ash \\ \hline 9 19-Aug & Tuesday & Savings & New Account & $900.00 New & Blue Ash \\ \hline 10 19-Aug & Tuesday & Savings & New Account & $700.00 New & Blue Ash \\ \hline 19-Aug & Tuesday & Savings & New Account & $1,200,00New & Anderson Hills \\ \hline 32 19-Aug & Tuesday & Checking & New Account & $2,590,00 New & Blue Ash \\ \hline 283 19-Aug & Tuesday & Cheoking & New Account & $910,00New & Anderson Hills \\ \hline 784 19-Aug & Tuesday & Checking & New Account & $2,920,00New & Anderson Hills \\ \hline 385 19-Aug & Tuesday & Checking & New Account & $260.00 New & Anderson Hills \\ \hline 86 19-Aug & Tuesday & Checking & New Account & $120.00New & Blue Ash \\ \hline 87 19-Aug & Tuesday & Checking & New Account & $2,900,00 New & Anderson Hills \\ \hline 88 19-Aug & Tuesday & Checking & New Account & $330.00New & Anderson Hills \\ \hline 189 19-Aug & Tuesday & Checking & New Account & $530.00New & Anderson Hills \\ \hline 990 19-Aug & Tuesday & Certificate of Deposit & New Account & $21,100,00New & Anderson Hills \\ \hline 391 19-Aug & Tuesday & Certificate of Deposit & New Account & $43,300,00New & Anderson Hills \\ \hline 392 19-Aug & Tuesday & Certificate of Deposit & New Account & $35,600,00New & Anderson Hills \\ \hline 93 19-Aug & Tuesday & Certificate of Deposit & New Account & $54,700.00New & Blue Ash \\ \hline 194 19-Aug & Tuesday & Certificate of Deposit & New Account & $17,900,00 New & Delhi \\ \hline 95 19-Aug & Tuesday & Certificate of Deposit & New Account & $28,900,00New & Anderson Hills \\ \hline 396 19-Aug & Tuesday & Certificate of Deposit & New Account & $59,400,00 New & Blue Ash \\ \hline 397 19-Aug & Tuesday & Certificate of Deposit & New Account & $24,500,00 New & Delhi \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & c & D & E & 6 \\ \hline 1. Aug & Friday & Certificate of Deposit & New & $58,800,00 Current & Anderson fills \\ \hline 1. Aug & Friday & Certificate of Deposit & New & 358,400,00 Current & Anderson Hills \\ \hline 1. Aug & Friday & Certificate of Deposit & New & $25,200,00 Current & Anderson Hills \\ \hline 2Aug & Saturday & Savings & New Account & $2,200.00New & Anderson Hills \\ \hline 2-Aug & Saturday & Savings & New Account & $1,100,00New & Dehi \\ \hline 2-Aug & Saturday & Checking & New Account & $130.00New & Delhi \\ \hline 2-Aug & Saturday & Checking & New Ascount & $840.00Nen & Anderson Hills \\ \hline 2-Aug & Saturday & Certificate of Deposit & New Account & $16,300,00New & Dekhi \\ \hline 2-Aug & Saturday & Certificate of Deposit & New Account & 38,400.00New & Bue Ash \\ \hline 2-Aug & Saturday & Savings & Withdrawal & $1,150.00 Current & Anderson Hills \\ \hline 2.Aug & Saturday & Savings & Withdrawal & $250.00 Current & Delhi \\ \hline 2. Aug & Saturday & Savings & Deposit & $1,300,00 Current & Anderson Hills \\ \hline 2-Aug & Saturday & Savings & Deposit & $800.00 Current & Delhi \\ \hline 1 2.Aug & Saturday & Checking & Deposit & $3,880.00 Current & Anderson Hills \\ \hline 52 Aug & Saturday & Checking & Deposit & $810.00 Current & Anderson Hills \\ \hline 2-Aug & Saturday & Checking & Withdrawal & $775.00 Current & Bive Ash \\ \hline 4. Aug & Monday & Savings & New Account & $1,900.00New & Anderson Hls \\ \hline 4. Aug & Monday & Savings & New Account & $1,400.00New & Delhi \\ \hline 4.Aug & Monday & IRA & New Account & $4,000.00New & Blue Ash \\ \hline 4.Aug & Monday & Checking & New Account & $320.00New & Anderson fills \\ \hline 4. Aug & Monday & Checking & New Account & $3,030,00New & Bue Ash \\ \hline 4. Aug & Monday & Checking & New Account & $150.00New & Blue Ash \\ \hline 4.Aug & Monday & Checking & New Account & $850.00New & Dehi \\ \hline S4 Aug & Monday & Checking & New Account & 3850.00New & Delhi \\ \hline 4-Aug & Monday & Checking & New Account & $670.00New & Anderson Hl 's \\ \hline 6. Aug & Monday & Checking & New Account & 33,780.00New & Anderson tills \\ \hline 4. Aug & Monday & Checking & New Account & $250.00New & Anderson Hills \\ \hline 4.Aug & Monday & Certificate of Deposit & New Account & $18,100.00New & Anderson Hills \\ \hline 4.Aug4.Aun & Monday & Certificate of Deposit & New Account & $47,200.00New & Delhi \\ \hline 4.Augis-Aug & MondayMonday & CertificateofDepositCertificateofDasosit & New Account & $28,900,00 New & Anderson Hills \\ \hline oney & Dats & Centificate of Deposit & New Account & $45,200.00New & Anderson Hils \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & c & D & F & G \\ \hline 234ug & Saturday & Savings & New Account & $700.00New & Blue Ash \\ \hline 23-Aug & Saturday & Savings & New Account & $2,800.00New & Anderson Hills \\ \hline 23-Aug & Saturday & Checking & New Account & $110.00NeW & Anderson Hills \\ \hline 23 -4ug & Saturday & Checking & New Account & $270.00New & Anderson Hills \\ \hline 23-Aug & Saturday & Certificate of Deposit & New Account & $47,300.00New & Anderson Hills \\ \hline 23406 & Saturday & Savings & Withdrawal & $3,000,00 Current & Anderson Hills \\ \hline 23-Aug & Saturday & Savings & Deposit & $1,000.00 Current & Blue Ash \\ \hline 234ug & Saturday & Savings & Deposit & $1,900.00 Current & Delhi \\ \hline 23 Aug & Saturday & IRA & Current Contributiol & $3,100,00 Current & Delhi \\ \hline 23-Aug & Saturday & Checking & Deposit & $790.00 Current & Delhi \\ \hline & Saturday & Checking & Withdrawal & $3,770.00 Current & Blue Ash \\ \hline 23.Aug & Saturday & Checking & Deposit & $3,460.00 Current & Anderson Hills \\ \hline 23409 & Saturday & Checking & Withdrawal & $40.00 Current & Delhi \\ \hline 234 Aug & Saturday & Checking & Withdrawal & $2,670,00 Current & Anderson Hills \\ \hline 23-Aug & Saturday & Checking & Deposit & $800.00 Current & Anderson Hills \\ \hline 25Aug & Monday & Savings & New Account & $500.00New & Anderson Hills \\ \hline 25-Avg & Monday & Savings & New Account & $2,900.00New & Blue Ash \\ \hline 25-Aug & Monday & Savings & New Account & $1,600.00New & Blue Ash \\ \hline 25-Aug & Monday & Savings & New Account & $500.00New & Blue Ash \\ \hline 254ug & Monday & Savings & New Account & $1,000,00New & Anderson Hills \\ \hline 25 Aug & Monday & Savings & New Account & $1,100.00New & Anderson Hills \\ \hline 2254ug & Monday & IRA & New Account & $3,400,00New & Blue Ash \\ \hline 4325 -4ug & Monday & Checking & New Account & $710.00New & Anderson Hills \\ \hline 1425Aug & Monday & Checking & New Account & $740.00New & Blue Ash \\ \hline 15 25-Aug & Monday & Checking & New Account & $430,00New & Delhi \\ \hline - 25-Aug & Monday & Checking & New Account & $890.00New & Anderson Hills \\ \hline 25-Aug & Monday & Certificate of Deposit & it New Account & $35,900.00New & Anderson Hills \\ \hline \& 25-Aug & Monday & Certificate of Deposit & it New Account & $55,100.00 New & Delhi \\ \hline 19 25-Aug & Monday & Certificate of Deposit & it New Account & $22,500,00New & Anderson Hills \\ \hline 25 Aug & Monday & Certificate of Deposit & it New Account & $23,600.00New & Blue Ash \\ \hline 25-Aug & Monday & Savings & Deposit & $2,900,00 Current & Anderson Hills \\ \hline+8 & Data & + & & & \\ \hline \end{tabular} File Home Insert Draw Page Layout Formulas Data Review View Automate Help Q185 :xfx \begin{tabular}{|c|c|c|c|c|c|} \hline A & B & C & D & F & G \\ \hline 92 5-Aug & Tuesday & Savings & Deposit & $1,500,00 Current & Anderson Hills \\ \hline 93 5-Aug & Tuesday & Savings & Withdrawal & $2,300,00 Current & Blue Ash \\ \hline 94 5-Aug & Tuesday & Savings & Deposit & $1,100,00 Current & Anderson Hills \\ \hline 95 5-Aug & Tuesday & Savings & Deposit & $800.00 Current & Delhi \\ \hline 5-Aug & Tuesday & Savings & Withdrawal & $800.00 Current & Blue Ash \\ \hline 97 5-Aug & Tuesday & IRA & New Account & $3,500.00 Current & Blue Ash \\ \hline 98 5-Aug & Tuesday & IRA & Current Contributiol & $1,300.00 Current & Anderson Hills \\ \hline 99 5-Aug & Tuesday & IRA & New Account & $2,700,00 Current & Blue Ash \\ \hline 100 5-Aug & Tuesday & Checking & Deposit & $3,840.00 Current & Anderson Hills \\ \hline 101 5-Aug & Tuesday & Checking & Withdrawal & $810.00 Current & Anderson Hills \\ \hline 102 5-Aug & Tuesday & Checking & Deposit & $190.00 Current & Anderson Hills \\ \hline 103 5-Aug & Tuesday & Checking & Deposit & $2,610.00 Current & Anderson Hills \\ \hline 104 5-Aug & Tuesday & Checking & Withdrawal & $410.00 Current & Anderson Hills \\ \hline 5 5-Aug & Tuesday & Checking & Deposit & $210.00 Current & Delhi \\ \hline 66 -Aug & Tuesday & Checking & Deposit & $2,820,00 Current & Anderson Hills \\ \hline 07 5-Aug & Tuesday & Checking & Withdrawal & $380.00 Current & Delhi \\ \hline 108 5-Aug & Tuesday & Checking & Deposit & $890.00 Current & Anderson Hills \\ \hline 109 5-Aug & Tuesday & Checking & Deposit & $150.00 Current & Delhi \\ \hline 110 5-Aug & Tuesday & Checking & Withdrawal & $210.00 Current & Anderson Hills \\ \hline 111 5-Aug & Tuesday & Checking & Withdrawal & $360.00 Current & Anderson Hills \\ \hline 112 5-Aug & Tuesday & Certificate of Deposit & New & $16,400.00 Current & Blue Ash \\ \hline 113 6-Aug & Wednesday & Savings & New Account & $200.00NeW & Anderson Hills \\ \hline 114 6-Aug & Wednesday & Checking & New Account & $750.00New & Delhi \\ \hline 115 6-Aug & Wednesday & Checking & New Account & $660.00New & Anderson Hills \\ \hline 116 6-Aug & Wednesday & Checking & New Account & $3,700.00New & Delhi \\ \hline 117 6-Aug & Wednesday & Checking & New Account & $950.00New & Anderson Hills \\ \hline 118 6-Aug & Wednesday & Checking & New Account & $790.00New & Anderson Hills \\ \hline 119 6-Aug & Wednesday & Certificate of Deposit & it New Account & $3,200.00New & Anderson Hills \\ \hline 120 6-Aug & Wednesday & Certificate of Deposit & it New Account & $12,500.00New & Delhi \\ \hline 121 6-Aug & Wednesday & Certificate of Deposit & it New Account & $19,000.00New & Delhi \\ \hline 122 6-Aug & Wednesday & Certificate of Deposit & it New Account & $10,200.00NeW & Delhi \\ \hline & Data & & & & \\ \hline \end{tabular} Ready 2x Accessibility, Investigate
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started