8. Go to the Customers worksheet. Ravi wants to create PivotTables that include customer, contract, and invoice data. Ravi wants to list and total each contract amount by city and signing date. Create a PivotTable that displays this information as follows: a. Rename the Sheet4 worksheet, using Contracts by City as the name of the worksheet. b. Create a PivotTable based on the Contract table in cell B3 of the Contracts by City worksheet. C. Display the City field values as row headings. d. Display the Signing Date field values as column headings. e. Add the ContractAmt field to the Values area to sum the field values. f. Group the signing dates to display them as years and quarters only. (Hint: Expand the year headings to display the quarter headings, if necessary.) g. Remove all subtotals from the PivotTable. 9. h. Format the Sum of ContractAmt field using the Currency number format with 2 decimal places and the $ symbol. Ravi also wants to list the paid and unpaid invoices for each month and then filter them by contract type. Create a PivotTable that displays this information as follows: a. b. Rename the Sheet3 worksheet, using Invoices by Month as the name of the worksheet. Create a PivotTable based on the Invoice table in cell B3 of the Invoices by Month worksheet. C. Display the Signing Date field values as row headings. d. Display the InvoicePaid field values as column headings. e. Add the InvoiceAmt field values to the Values area to sum the field values. f. Use the ContractType field as a filter. g. Group the signing dates to display them as years and months only. h. Format the Sum of InvoiceAmt field using the Currency number format with 2 decimal places and the $ symbol. A B D E F G HI J K L 1 2 CustomerID| First Last Phone Address City State Zip Contracts by City 3 C-001 Margaret Alexander 4 C-005 Jeff Jordan 5 C-008 Chris Hackbart 11 C-030 6 C-012 7 C-014 8 C-015 9 C-020 10 C-027 Karen Stephen Ramona Vernon Earley Crowley Alberto Cruz Michelle McMurray 12 C-031 13 C-032 Daniel Laquan 14 C-038 Clint 770-866-3901 211 N Paterson 770-392-0622 2611 S Sara Dr 404-985-1122 3478 Woodline Rd 770-454-9801 33 E Pine St 706-396-1972 566 Kent Rd 770-637-7783 456 Winchester St 404-963-0808 815 Pulley Rd Li 706-483-9244 402 S Melody Rd Rosner 770-393-1228 111 E 78th Ave Plummer 404-842-4603 29 Graham Blvd Richardson 404-857-1276 80 Cedar St Schmitt Newnan GA 30263 Atlanta Peachtree City GA 30270 Atlanta Alpharetta GA Augusta Canton Decatur Augusta Dunwoody Atlanta Atlanta 15 C-040 Victor Ramirez 706-482-1400 2268 N Jackson 770-988-0777 144 E Tower Ave Columbus Holly Springs 16 C-042 Michael Levander 404-337-9208 10 Lincoln Dr Atlanta 17 C-043 Shana Liang 770-988-1320 40 Monroe St Alpharetta 18 C-045 Jamal Kidd 404-343-7509 3047 Millbrook Ave Atlanta 19 C-048 Joel Holtman 706-637-6591 7320 E Elmwood Augusta 20 C-049 Frances Heller 21 C-053 Ahmad Greenwell 22 C-054 Jacquie Rollins 404-983-2255 828 Turner St 770-396-8401 614 Berman Rd 770-355-3989 258 Briar Ln Woolsey College Park Douglasville 23 C-055 Steve 24 C-058 Andrea Vander 25 C-059 Harry Fraser 26 C-060 27 C-064 Anita Tomashek 404-979-2004 1440 Beadle Rd 706-857-1771 77 Robin Rd 770-392-0015 8045 Jefferson Ave Renteria 770-949-3862 75 Johnson St Decatur Augusta Atlanta Atlanta Douglas 28 C-065 Shoemaker 706-487-4700 Raymond Ringdahl 29 C-067 Beth Raferty 5478 N Grove 770-393-0403 24 Samuel St 404-985-1992 612 E Carolina Pl Baldwin Alpharetta GA Atlanta 30 C-068 Jason Grady 31 C-070 Gordon Griffin 770-454-4002 5230 Fulton St 706-456-7093 912 Market St Carrollton Augusta 32 C-071 Mia 33 C-072 Barbara Watanabe 404-857-4424 82 Cambridge St Callahan 404-337-8200 5049 Hwy 36 Briarcliff Sandy Springs GA 34 C-073 Randy Dixon 35 C-075 Jim Benning 770-983-1116 131 Pleasant St 706-482-9932 2167 S Macon St Marietta Augusta GA 36 C-079 Sarah Alvarez 770-940-3380 620 Pinewoody Alpharetta GA 37 C-080 Timothy Jones 404-392-4629 249 W 11th St Atlanta GA 38 C-083 Shanissa Hoffman 39 C-084 Cathy 40 C-085 41 C-087 42 C-088 43 Wilson Richard Phillips Nancy Wanson Mickey Kervin 706-337-0990 770-866-4882 78 Sandy Springs St 770-637-5408 39 Water St 404-963-0190 1752 S Main St 706-454-3327 348 N Oak St 1286 Jennifer Dr Athens Buford Canton GA College Park Columbus GA College Park GA 31107 Dunwoody 30004 GA 30917 GA 30114 GA 30031 GA 30918 GA 30346 GA 30347 GA GA 30350 31998 GA 30115 GA 30336 GA 30022 GA 1156 GA 30919 GA 30337 GA 30134 GA GA 30214 30036 GA 30907 GA 30339 GA 30341 GA 30511 30009 GA 30318 GA 30119 GA 30907 GA 30329 30342 GA 10090 30168 30412 30322 GA 30604 GA 30515 30114 GA 30337 31998 44