EssayproSolutions

Using Template Assignment Create Pivottables Answer Following Questions Name Sheet Contain Q43790097

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

In newer versions of Excel, PivotTables become linked togetherif they have the same source data, and changes made to onePivotTable may make changes to another PivotTable. It isrecommended that you make a copy of the source data for each of theproblems below. You can do this by right-clicking on the worksheetname at the bottom of the Excel window, choosing Move orCopy…, and choosing where in order it falls in the list oftabs. To be able to keep track of which worksheet of data belongsto which PivotTable, you should double-click the name of theworksheet to rename it.

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

Expert Answer

Answer to Using the template for this assignment, create PivotTables that answer the following questions. Name the sheet that cont…