hillpa_PivotAns

hillpa_PivotAns - be seen in worksheet Q3 in...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Patrick Hill Mr. Cruez MIS 235 18 October 2010 Pivot Table Exercises 1. The daily total new deposit amount can be seen in worksheet Q1 in hillpa_PivotExc.xlsx file. The grand total for all the deposits is $6,535,772.00. 2. Friday is the day of the week which has the highest deposit amount with $1,645,649.00 deposit amount. 3. To view the breakdown of the number of accounts opened in each region by account type can
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: be seen in worksheet Q3 in hillpa_PivotExc.xlsx file. The central region opened 362 accounts, the North County opened 197 accounts, and the Westside opened 153 accounts. 4. The accounts that tellers most often open are checking accounts, tellers have opened 99 checking accounts. 5. The central branch tellers open the most checking accounts for new customers by opening 23 checking accounts....
View Full Document

This document was uploaded on 11/01/2011 for the course MIS 235 at Miami University.

Ask a homework question - tutors are online