ple ble able cable T stable stable stable PivotTable Instructions: 1) Create a PivotTable that diplays the number (Count) and sum of loan amounts. Include Type as a Column and City as a Row. Place the PivotTable in a new worksheet and then rename the PivotTable worksheet as "Loan Types" (10) 2. Format the PivotTable appropriately. Use a dark style. (3) 3. Answer the questions in the box below. (15) POINTS: 28 Step Pts Avail Pt 1 10 2 13 3 S 50 3 4 5 6 5 Total 28 28 0 EXAM QUESTIONS 4) What is the total number of loans in Sacramento and San Mateo? 5) What is the sum total of Adjustable loans in Concord? 6) What is the average Adjustable loan amount in San Mateo (nearest dollar)?