The people 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 with 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 banks president. Use pivot tables (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.