Please write down the function completely. Thank you.

12. Return to the Customers worksheet. In the range J2: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: a. In cell K3, use the GETPIVOTDATA function to display the total contract amount for Atlanta from the PivotTable on the Contracts by City worksheet. (Hint: Type an equal sign in cell K3 and then click the cell containing the value you want the GETPIVOTDATA function to get from the Pivottable.) In cell K4, use the GETPIVOTDATA function to display the total contract amount for College Park from the PivotTable on the Contracts by City worksheet. b. C. In cell K5, use the GETPIVOTDATA function to display the total contract amount for Dunwoody from the PivotTable on the Contracts by City worksheet. Save the workbook, making sure to save it as a macro-enabled workbook. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project. M8 fx B D E F G H 1 J L FN Home Security Systems 1 2 Contracts by City Atlanta College Park Dunwoody Cruz CustomerID First Last Phone Address City State Zip 3 C-001 Margaret Alexander 770-866-3901 211 N Paterson Newnan GA 30263 4 C-005 Jeff Jordan 770-392-0622 2611 S Sara Dr Peachtree City GA 30270 5 C-008 Chris Hackbart 404-985-1122 3478 Woodline Rd Atlanta GA 31107 6 C-012 Ramona Earley 770-454-9801 33 E Pine St Alpharetta GA 30004 7 C-014 Vernon Crowley 706-396-1972 566 Kent Rd Augusta GA 30917 8 C-015 Alberto 770-637-7783 456 Winchester St Canton GA 30114 9 C-020 Michelle McMurray 404-963-0808 815 Pulley Rd Decatur GA 30031 10 C-027 Karen Li 706-483-9244 402 S Melody Rd Augusta GA 30918 11 C-030 Stephen Rosner 770-393-1228 111 E 78th Ave Dunwoody GA 30346 12 C-031 Daniel Plummer 404-842-4603 29 Graham Blvd Atlanta GA 30347 13 C-032 Laquan Richardson 404-857-1276 80 Cedar St Atlanta GA 30350 14 C-038 Clint Schmitt 706-482-1400 2268 N Jackson Columbus GA 31998 15 C-040 Victor Ramirez 770-988-0777 144 E Tower Ave Holly Springs GA 30115 16 C-042 Michael Levander 404-337-9208 10 Lincoln Dr Atlanta GA 30336 17 C-043 Shana Liang 770-988-1320 40 Monroe St Alpharetta GA 30022 18 C-045 Jamal Kidd 404-343-7509 3047 Millbrook Ave Atlanta GA 31156 19 C-048 Joel Holtman 706-637-6591 7320 E Elmwood Augusta GA 20 C-049 Frances Heller 404-983-2255 828 Turner St College Park GA 21 C-053 Ahmad Greenwell 770-396-8401 614 Berman Rd Douglasville GA 30134 22 C-054 Jacquie Rollins 770-355-3989 258 Briar Ln Woolsey GA 30214 23 C-055 Steve Tomashek 404-979-2004 1440 Beadle Rd Decatur GA 30036 24 C-058 Andrea Vander 706-857-1771 77 Robin Rd Augusta GA 30907 25 C-059 Harry Fraser 770-392-0015 8045 Jefferson Ave Atlanta GA 30339 26 C-060 Anita Renteria 770-949-3862 75 Johnson St Atlanta GA 30341 27 C-064 Douglas Shoemaker 706-487-4700 5478 N Grove Baldwin GA 30511 28 C-065 Ravmond Rinadahl 770-293-0402 24 Samuel St Alpharetta GA 20009 Documentation Home Page Invoices by Month Contracts by City Customers 30919 30337 Contracts Invoices + B D E F H 1 J K L M 1 2. 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Sum of ContractAmt Column Labels - 2021 2022 Grand Total Row Labels Qtri Qtr2 Otr3 Otr4 Qtr1 atr2 Otr3 Alpharetta $1,250.00 $2,000.00 $11,000.00 $4,500.00 $6,000.00 524,750.00 Athens $5,500.00 $10,000.00 $15,500.00 Atlanta $18,500.00 $8,000.00 $13,000.00 $20,000.00 $10,500.00 $70,000.00 Augusta $9.990.00 $10,000.00 $13,250.00 $3,800.00 $3,500.00 $40,540.00 Baldwin $5,000.00 $5,000.00 Briarcliff $1,000.00 $1,000.00 Buford $1,000.00 $1,000.00 Canton $11,000.00 $750.00 $5,300.00 $17,050.00 Carrollton $8,500.00 $2,500.00 $11,000.00 College Park $1,375.00 $1,500.00 $12,000.00 $14,875.00 Columbus $5,000.00 $9,000.00 $14,000.00 Decatur $3,500.00 $3.750.00 57,250.00 Douglasville $2,000.00 $2,000.00 Dunwoody $4,500.00 55.750.00 $10,250.00 Holly Springs $8,000.00 $8,000.00 Marietta $2,500.00 $2,500.00 Newnan $2,000.00 $1,800.00 53,800.00 Peachtree City $2,500.00 $1,250.00 $2,000.00 $5.750.00 Sandy Springs $5,000.00 $5,000.00 Woolsey $10,250.00 $10,250.00 Grand Total $29,740.00 $47,500.00 $54,875.00 $13,800.00 $34,000.00 $42,050.00 $47,550.00 $269,515.00 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Documentation Home Page Invoices by Month Contracts by City Customers Contracts Invoices + 11 12. Return to the Customers worksheet. In the range J2: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: a. In cell K3, use the GETPIVOTDATA function to display the total contract amount for Atlanta from the PivotTable on the Contracts by City worksheet. (Hint: Type an equal sign in cell K3 and then click the cell containing the value you want the GETPIVOTDATA function to get from the Pivottable.) In cell K4, use the GETPIVOTDATA function to display the total contract amount for College Park from the PivotTable on the Contracts by City worksheet. b. C. In cell K5, use the GETPIVOTDATA function to display the total contract amount for Dunwoody from the PivotTable on the Contracts by City worksheet. Save the workbook, making sure to save it as a macro-enabled workbook. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project. M8 fx B D E F G H 1 J L FN Home Security Systems 1 2 Contracts by City Atlanta College Park Dunwoody Cruz CustomerID First Last Phone Address City State Zip 3 C-001 Margaret Alexander 770-866-3901 211 N Paterson Newnan GA 30263 4 C-005 Jeff Jordan 770-392-0622 2611 S Sara Dr Peachtree City GA 30270 5 C-008 Chris Hackbart 404-985-1122 3478 Woodline Rd Atlanta GA 31107 6 C-012 Ramona Earley 770-454-9801 33 E Pine St Alpharetta GA 30004 7 C-014 Vernon Crowley 706-396-1972 566 Kent Rd Augusta GA 30917 8 C-015 Alberto 770-637-7783 456 Winchester St Canton GA 30114 9 C-020 Michelle McMurray 404-963-0808 815 Pulley Rd Decatur GA 30031 10 C-027 Karen Li 706-483-9244 402 S Melody Rd Augusta GA 30918 11 C-030 Stephen Rosner 770-393-1228 111 E 78th Ave Dunwoody GA 30346 12 C-031 Daniel Plummer 404-842-4603 29 Graham Blvd Atlanta GA 30347 13 C-032 Laquan Richardson 404-857-1276 80 Cedar St Atlanta GA 30350 14 C-038 Clint Schmitt 706-482-1400 2268 N Jackson Columbus GA 31998 15 C-040 Victor Ramirez 770-988-0777 144 E Tower Ave Holly Springs GA 30115 16 C-042 Michael Levander 404-337-9208 10 Lincoln Dr Atlanta GA 30336 17 C-043 Shana Liang 770-988-1320 40 Monroe St Alpharetta GA 30022 18 C-045 Jamal Kidd 404-343-7509 3047 Millbrook Ave Atlanta GA 31156 19 C-048 Joel Holtman 706-637-6591 7320 E Elmwood Augusta GA 20 C-049 Frances Heller 404-983-2255 828 Turner St College Park GA 21 C-053 Ahmad Greenwell 770-396-8401 614 Berman Rd Douglasville GA 30134 22 C-054 Jacquie Rollins 770-355-3989 258 Briar Ln Woolsey GA 30214 23 C-055 Steve Tomashek 404-979-2004 1440 Beadle Rd Decatur GA 30036 24 C-058 Andrea Vander 706-857-1771 77 Robin Rd Augusta GA 30907 25 C-059 Harry Fraser 770-392-0015 8045 Jefferson Ave Atlanta GA 30339 26 C-060 Anita Renteria 770-949-3862 75 Johnson St Atlanta GA 30341 27 C-064 Douglas Shoemaker 706-487-4700 5478 N Grove Baldwin GA 30511 28 C-065 Ravmond Rinadahl 770-293-0402 24 Samuel St Alpharetta GA 20009 Documentation Home Page Invoices by Month Contracts by City Customers 30919 30337 Contracts Invoices + B D E F H 1 J K L M 1 2. 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Sum of ContractAmt Column Labels - 2021 2022 Grand Total Row Labels Qtri Qtr2 Otr3 Otr4 Qtr1 atr2 Otr3 Alpharetta $1,250.00 $2,000.00 $11,000.00 $4,500.00 $6,000.00 524,750.00 Athens $5,500.00 $10,000.00 $15,500.00 Atlanta $18,500.00 $8,000.00 $13,000.00 $20,000.00 $10,500.00 $70,000.00 Augusta $9.990.00 $10,000.00 $13,250.00 $3,800.00 $3,500.00 $40,540.00 Baldwin $5,000.00 $5,000.00 Briarcliff $1,000.00 $1,000.00 Buford $1,000.00 $1,000.00 Canton $11,000.00 $750.00 $5,300.00 $17,050.00 Carrollton $8,500.00 $2,500.00 $11,000.00 College Park $1,375.00 $1,500.00 $12,000.00 $14,875.00 Columbus $5,000.00 $9,000.00 $14,000.00 Decatur $3,500.00 $3.750.00 57,250.00 Douglasville $2,000.00 $2,000.00 Dunwoody $4,500.00 55.750.00 $10,250.00 Holly Springs $8,000.00 $8,000.00 Marietta $2,500.00 $2,500.00 Newnan $2,000.00 $1,800.00 53,800.00 Peachtree City $2,500.00 $1,250.00 $2,000.00 $5.750.00 Sandy Springs $5,000.00 $5,000.00 Woolsey $10,250.00 $10,250.00 Grand Total $29,740.00 $47,500.00 $54,875.00 $13,800.00 $34,000.00 $42,050.00 $47,550.00 $269,515.00 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Documentation Home Page Invoices by Month Contracts by City Customers Contracts Invoices + 11