1. Go to the Customers worksheet, which contains customer details in a table named Customers. Marina wants to display the payments customers made in each of five states where Eastern Mobile does business. Insert a recommended PivotTable based on the Customers table as follows:
   1. Insert the Sum of Payment by State recommended PivotTable. [Mac Hint: Use the State field in the Rows area, the Payments field in the Values area, and show grand totals for rows and columns.]
   2. Use Payments by State Pivot as the name of the new worksheet.
   3. Apply the Light Orange, Pivot Style Medium 12 style to the PivotTable.
   4. Add a second copy of the Payment field to the Values area of the Field List, and then change its summary function to Average so that Marina can compare the average payments to the totals.
   5. Change the Number format of the two value fields to Currency with 0 decimal places and the $ symbol.
   6. Use Total Payments as the column heading in cell B3, and use Average Payment as the column heading in cell C3.

B D E F H K 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Customer 5010 5015 5019 5020 5023 5025 5027 5029 5031 5033 5037 5039 5102 5104 5106 5108 5110 5112 5114 5116 5118 5120 5122 5128 5201 5207 5208 Year! 4 2 1 3 5 6 4 7 2 3 1 1 3 2 4 6 6 5 4 3 2 5 5 6 2 1 4 State DC NC DE DC NC MD DC VA DE VA DE VA MD DC NC DC VA MD DC VA DC MD VA NC DE MD VA Mobile Phone Customers Plan ID Plan Type # of Lines BAZ Basic 2 FA2 Family 3 FA3 Family 6 UN2 Unlimited 2 FA1 Family 2 SI1 Single 1 UN2 Unlimited 2 FA3 Family 6 IN1 International 1 UN3 Unlimited 5 UN2 Unlimited 2 Basic 4 FA2 Family 3 SI1 Single 1 UN3 Unlimited 5 UN2 Unlimited 2 FA3 Family 6 FA2 Family 3 Basic 4 UN1 Unlimited 1 FA1 Family 2 FA2 Family 3 FA3 Family 6 IN2 International 2 FA2 Family 3 UN2 Unlimited 2 UN2 Unlimited 2 Order Location Online Online EM store Online Phone store Online Phone store Online EM store Online Online Online EM store Phone store Online Online EM store Phone store Phone store Online Online Online Online Phone store Online EM store Online Payment! $60.00 $120.00 $240.00 $130.00 $80.00 $45.00 $130.00 $240.00 $60.00 $325.00 $130.00 $120.00 $120.00 $45.00 $325.00 $130.00 $240.00 $120.00 $120.00 $65.00 $80.00 $120.00 $240.00 $120.00 $120.00 $130.00 $130.00 B D E F H K 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Customer 5010 5015 5019 5020 5023 5025 5027 5029 5031 5033 5037 5039 5102 5104 5106 5108 5110 5112 5114 5116 5118 5120 5122 5128 5201 5207 5208 Year! 4 2 1 3 5 6 4 7 2 3 1 1 3 2 4 6 6 5 4 3 2 5 5 6 2 1 4 State DC NC DE DC NC MD DC VA DE VA DE VA MD DC NC DC VA MD DC VA DC MD VA NC DE MD VA Mobile Phone Customers Plan ID Plan Type # of Lines BAZ Basic 2 FA2 Family 3 FA3 Family 6 UN2 Unlimited 2 FA1 Family 2 SI1 Single 1 UN2 Unlimited 2 FA3 Family 6 IN1 International 1 UN3 Unlimited 5 UN2 Unlimited 2 Basic 4 FA2 Family 3 SI1 Single 1 UN3 Unlimited 5 UN2 Unlimited 2 FA3 Family 6 FA2 Family 3 Basic 4 UN1 Unlimited 1 FA1 Family 2 FA2 Family 3 FA3 Family 6 IN2 International 2 FA2 Family 3 UN2 Unlimited 2 UN2 Unlimited 2 Order Location Online Online EM store Online Phone store Online Phone store Online EM store Online Online Online EM store Phone store Online Online EM store Phone store Phone store Online Online Online Online Phone store Online EM store Online Payment! $60.00 $120.00 $240.00 $130.00 $80.00 $45.00 $130.00 $240.00 $60.00 $325.00 $130.00 $120.00 $120.00 $45.00 $325.00 $130.00 $240.00 $120.00 $120.00 $65.00 $80.00 $120.00 $240.00 $120.00 $120.00 $130.00 $130.00