Using the template for this assignment, create PivotTables that answer the following questions. Name the sheet that contains the PivotTable for the first question Q1, the sheet that contains the PivotTable for the second question Q2, and the sheet that contains the PivotTable for the third question on Q3.

In newer versions of Excel, PivotTables become linked together if they have the same source data, and changes made to one PivotTable may make changes to another PivotTable. It is recommended that you make a copy of the source data for each of the problems below. You can do this by right-clicking on the worksheet name at the bottom of the Excel window, choosing Move or Copy..., and choosing where in order it falls in the list of tabs. To be able to keep track of which worksheet of data belongs to which PivotTable, you should double-click the name of the worksheet to rename it.

1. Create a PivotTable that shows how much money is deposited each day of the week. Apply data bars through conditional formatting to make the total for each day appear to be similar to a bar on a bar chart.
2. Create a PivotChart showing the number of accounts opened by branch in a pie chart. (Alternatively, create a PivotTable showing the number of accounts opened by branch, and then create a pie chart from this table.)
3. Create a PivotTable showing the number of transactions in increments of $10,000 by account type.