could someone please explain the process?

e. a. 8. Go to the Customers worksheet. Ravi wants to create Pivot Tables 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 Sheeta worksheet, using Contracts by City as the name of the worksheet. b. Create a Pivot Table based on the Contract table in cell B4 of the Contracts by City worksheet. c. Display the City field values as row headings. d. Display the signingDate field values as column headings. 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.) 9. Remove all subtotals from the PivotTable. h. Format the Sum of ContractAmt field using the Currency number format with 2 decimal places and the $ symbol. 9. Ravi also wants to list the paid and unpaid invoices for each month and then filter than by contract type. Create a Pivottable that displays this information as follows: Rename the Sheet3 worksheet, using Invoices by Month as the name of the worksheet. b. Create a PivotTable based on the Invoice table in cell B3 of the Invoices by Month worksheet. Display the SigningDate field values as row headings. Display the InvoicePaid field values as column headings. Add the InvoiceAmt field values to the Values area to sum the field values. f. Use the ContractType field as a filter. 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. 10. Ravi wants to show invoices for security plans only and want to make the Pivot Table easier to interpret. Modify the PivotTable as follows to meet Ravi's requests: Use Unpaid as the column heading in cell C4 b. Use Paid as the column heading in cell 04. Filter the Pivottable to display invoices for the Security plan and Security plan for apartment building contract types. 11. Return to the Customers worksheet. In the range 12:K5, Ravi wants to list the total contract amounts for three cities. Extract this information from the PivotTable on the Contracts by City worksheet as follows: C. d. e. C. In cell K3, use the GETPIVOTDATA function to display the total contract amount for Atlanta from the PivotTable on the Contracts by City worksheet (cell 39). (Hint: age 3 of 8 Focus 94% F . FN Home Security Systems Contracts by Atlanta College Park Dunwoody 2 CustomerID First Last Phone Address | City State Zip 3 C-001 Margaret Alexander 770-866-3901 211 N Paterson Newnan GA 30263 4C-005 Jeff Jordan 770-392-0622 2611 S Sara Dr Peachtree City GA 5 C-008 Chris 30270 Hackbart 404-985-1122 3478 Woodline Rd Atlanta GA 31107 5 C-012 Ramona Earley 770-454-9801 33 E Pine St Alpharetta GA 7 C-014 30004 Vernon Crowley 706-396-1972 566 Kent Rd Augusta GA 30917 3 C-015 Alberto Cruz 770-637-7783 456 Winchester St Canton GA 30114 9 C-020 Michelle McMurray 404-963-0808 825 Pulley Rd Decatur GA 30031 o C-027 Karen Li 706-483-9244 402 S Melody Rd Augusta GA 30918 1 C-030 Stephen Rosner 770-393-1228 111 E 78th Ave Dunwoody GA 30346 2 C-031 Daniel Plummer 404-842-4603 29 Graham Blvd Atlanta GA 30347 3 C-032 Laquan Richardson 404-857-1276 80 Cedar St Atlanta GA 30350 4 C-038 Clint Schmitt 706-482-1400 2268 N Jackson Columbus GA 31998 5 C-040 Victor Ramirez 770-988-0777 144 E Tower Ave Holly Springs GA 30115 6 C-042 Michael Levander 404-337.9208 10 Lincoln Dr Atlanta GA 30336 7 C-043 Shana Liang 770-988-1320 40 Monroe St Alpharetta GA 30022 Jamal Kidd 404-343-7509 3047 Millbrook Ave Atlanta 31156 9 C-048 Joel Holtman 706-637-6591 7320 E Elmwood Augusta GA 30919 0 0.049 Frances Heller 404-983-2255 828 Turner St College Park GA 30337 1 C-053 Ahmad Greenwell 770-396-8,01 614 Berman Rd Douglasville GA 30134 2 C-054 Jacquie Rollins 770-355-3989258 Briaren Woolsey GA 30214 3 C-055 Steve Tomashek 404-979-2004 1440 Beadle Rd Decatur GA 30036 4 C-058 Andrea Vander 706-857-1771 77 Robin Rd Augusta GA 30907 5 C.059 Harry Fraser 770-392-0015 8045 Jefferson Ave Atlanta 30339 6 C-060 Anita Renteria 770-949-3862 75 Johnson St Atlanta GA 30341 7 C.064 Douglas Shoemaker 706-487-47005478 N Grove Baldwin GA 30511 8 C-065 Raymond Ringdahl 770-393-0403 24 Samuel St Alpharetta GA 30009 9 C-067 Beth Raferty 404-985-1992 612 E Carolina Pl Atlanta GA 30318 o C-068 Jason Grady 770-454-4002 5230 Fulton St Carrollton GA 30119 1 C-070 Gordon Griffin 706-456-7093 912 Market St Augusta GA 30907 2 C-071 Mia Watanabe 404-857-4424 82 Cambridge St Briarcliff 30329 Documentation Home Page Sheet3 Contracts by City Customers Contracts Ready 8 C-045 GA GA GA Invoices + U 120% Tables Illustrations Add-ins Data from Picture Recommended us Maps PivotChart Sel L1 Xv fx A C FN Home Security Systems Com West Cowe home 13 C-os Dec 30 ce C- y de ahh a odottam unders 14 ar 184 19 suas 20 2. Centre 2 werden cos : Rower sh Secara warna mo Co C www. yalan deye umewe y de em andere www foten De www www Ondere . Customers Contracts Documentation Home Page Contracts by City Sheets % Ready e. a. 8. Go to the Customers worksheet. Ravi wants to create Pivot Tables 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 Sheeta worksheet, using Contracts by City as the name of the worksheet. b. Create a Pivot Table based on the Contract table in cell B4 of the Contracts by City worksheet. c. Display the City field values as row headings. d. Display the signingDate field values as column headings. 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.) 9. Remove all subtotals from the PivotTable. h. Format the Sum of ContractAmt field using the Currency number format with 2 decimal places and the $ symbol. 9. Ravi also wants to list the paid and unpaid invoices for each month and then filter than by contract type. Create a Pivottable that displays this information as follows: Rename the Sheet3 worksheet, using Invoices by Month as the name of the worksheet. b. Create a PivotTable based on the Invoice table in cell B3 of the Invoices by Month worksheet. Display the SigningDate field values as row headings. Display the InvoicePaid field values as column headings. Add the InvoiceAmt field values to the Values area to sum the field values. f. Use the ContractType field as a filter. 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. 10. Ravi wants to show invoices for security plans only and want to make the Pivot Table easier to interpret. Modify the PivotTable as follows to meet Ravi's requests: Use Unpaid as the column heading in cell C4 b. Use Paid as the column heading in cell 04. Filter the Pivottable to display invoices for the Security plan and Security plan for apartment building contract types. 11. Return to the Customers worksheet. In the range 12:K5, Ravi wants to list the total contract amounts for three cities. Extract this information from the PivotTable on the Contracts by City worksheet as follows: C. d. e. C. In cell K3, use the GETPIVOTDATA function to display the total contract amount for Atlanta from the PivotTable on the Contracts by City worksheet (cell 39). (Hint: age 3 of 8 Focus 94% F . FN Home Security Systems Contracts by Atlanta College Park Dunwoody 2 CustomerID First Last Phone Address | City State Zip 3 C-001 Margaret Alexander 770-866-3901 211 N Paterson Newnan GA 30263 4C-005 Jeff Jordan 770-392-0622 2611 S Sara Dr Peachtree City GA 5 C-008 Chris 30270 Hackbart 404-985-1122 3478 Woodline Rd Atlanta GA 31107 5 C-012 Ramona Earley 770-454-9801 33 E Pine St Alpharetta GA 7 C-014 30004 Vernon Crowley 706-396-1972 566 Kent Rd Augusta GA 30917 3 C-015 Alberto Cruz 770-637-7783 456 Winchester St Canton GA 30114 9 C-020 Michelle McMurray 404-963-0808 825 Pulley Rd Decatur GA 30031 o C-027 Karen Li 706-483-9244 402 S Melody Rd Augusta GA 30918 1 C-030 Stephen Rosner 770-393-1228 111 E 78th Ave Dunwoody GA 30346 2 C-031 Daniel Plummer 404-842-4603 29 Graham Blvd Atlanta GA 30347 3 C-032 Laquan Richardson 404-857-1276 80 Cedar St Atlanta GA 30350 4 C-038 Clint Schmitt 706-482-1400 2268 N Jackson Columbus GA 31998 5 C-040 Victor Ramirez 770-988-0777 144 E Tower Ave Holly Springs GA 30115 6 C-042 Michael Levander 404-337.9208 10 Lincoln Dr Atlanta GA 30336 7 C-043 Shana Liang 770-988-1320 40 Monroe St Alpharetta GA 30022 Jamal Kidd 404-343-7509 3047 Millbrook Ave Atlanta 31156 9 C-048 Joel Holtman 706-637-6591 7320 E Elmwood Augusta GA 30919 0 0.049 Frances Heller 404-983-2255 828 Turner St College Park GA 30337 1 C-053 Ahmad Greenwell 770-396-8,01 614 Berman Rd Douglasville GA 30134 2 C-054 Jacquie Rollins 770-355-3989258 Briaren Woolsey GA 30214 3 C-055 Steve Tomashek 404-979-2004 1440 Beadle Rd Decatur GA 30036 4 C-058 Andrea Vander 706-857-1771 77 Robin Rd Augusta GA 30907 5 C.059 Harry Fraser 770-392-0015 8045 Jefferson Ave Atlanta 30339 6 C-060 Anita Renteria 770-949-3862 75 Johnson St Atlanta GA 30341 7 C.064 Douglas Shoemaker 706-487-47005478 N Grove Baldwin GA 30511 8 C-065 Raymond Ringdahl 770-393-0403 24 Samuel St Alpharetta GA 30009 9 C-067 Beth Raferty 404-985-1992 612 E Carolina Pl Atlanta GA 30318 o C-068 Jason Grady 770-454-4002 5230 Fulton St Carrollton GA 30119 1 C-070 Gordon Griffin 706-456-7093 912 Market St Augusta GA 30907 2 C-071 Mia Watanabe 404-857-4424 82 Cambridge St Briarcliff 30329 Documentation Home Page Sheet3 Contracts by City Customers Contracts Ready 8 C-045 GA GA GA Invoices + U 120% Tables Illustrations Add-ins Data from Picture Recommended us Maps PivotChart Sel L1 Xv fx A C FN Home Security Systems Com West Cowe home 13 C-os Dec 30 ce C- y de ahh a odottam unders 14 ar 184 19 suas 20 2. Centre 2 werden cos : Rower sh Secara warna mo Co C www. yalan deye umewe y de em andere www foten De www www Ondere . Customers Contracts Documentation Home Page Contracts by City Sheets % Ready