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 trans-action 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 sum-marize of these transactions that would be clear and meaningful to the bank's president. Use PivotTables (that are well-designed and properly formatted) to pro-vide a summary of the key information that the presi-dent and his direct reports would want to know. Justify and explain your reasoning.