need help solving. Make sure you label each part please and provide steps for excel

Answer these questions. You must use PIVOT TABLES for questions 2-8 (A SEPARATE SHEET AND PIVOT TABLE PER QUESTION). 1 Complete columns G, J, and K with functions or formulas to obtain the result (Type DONE when complete) 2 What is the average selling price in Alpine? 3 Which city has the highest average % of asking price? 4 Which city has the least number of average days on market? 5 What is the average days on market for all cities? 6 Which city had the lowest average selling price? Assume each agent receives 3% of the selling price in commission. 7 Who made the most money overall? 8 How much did this agent make in commission? A C D E F G H % of Asking Price Listing Date Sale Date Days on Market Sales Agent Commission Amt. 290,000 1 Number 2 1 3 2 4 3 3 5 4 6 5 7 6 8 8 7 9 8 10 9 11 10 12 11 13 12 14 13 15 14 16 15 17 16 18 17 19 18 20 19 21 20 22 21 23 22 24 23 25 24 26 25 27 26 28 27 29 28 30 29 31 30 32 31 33 32 34 33 35 34 36 35 37 36 38 37 39 38 40 39 41 40 42 41 43 42 44 43 45 44 46 45 47 46 48 47 49 48 50 49 51 50 52 51 53 52 54 53 55 54 56 55 57 56 58 57 59 58 60 59 61 60 62 61 63 62 64 63 65 64 66 65 67 66 68 67 69 68 70 69 71 70 72 71 73 72 74 73 75 74 76 75 77 76 78 77 79 78 80 79 81 82 81 Address City Selling Agent Asking Price Selling Price 8687 Kenwood Road Cedar Hills Hemandez $ 725,000 $ 645,250 11 West Oak Circle American Fork Carey $ 350,000 $ 340,000 314 Timp View Drive American Fork Goodrich $ 418,000 $ 400,000 614 West Cedar Drive Lehi Lugo $ 215,800 $ 200,000 750 South Apple Way American Fork Goodrich $ 385,900 $ 385,900 7 Kingston Court Alpine Carey $ 500,000 $ 465,000 618 West Cedar Drive Lehi Lugo $ 300,000 $ 321 North Choctaw American Fork Minkus $ 565,000 $ 535,000 1370 Pinellas Road Alpine Lugo $ 219,000 $ 215,000 1971 Glenview Road Lehi Minkus $ 165,000 $ 156,750 15 West Oak Circle American Fork Hemandez $ 325,000 $ 320,000 575 South Choctaw Alpine Goodrich $ 750 250 S 700,000 10995 SW 88 Court Lehi Goodrich $ 110,000 $ 106,000 143 North Mountain View American Fork Carey $ 314 250 S 304,000 29 East Oak Circle American Fork Merkin $ 555,000 $ 500,000 8030 Steeplechase Drive Alpine Merkin $ 450,000 $ 382,500 2006 Cutwater Court Alpine Minkus $ 345,000 $ 339,999 9876 South Sunset Avenue Eagle Mountain Hemandez $ 300,000 $ 300,000 321 West Walnut Grove American Fork Goodrich $ 425,000 $ 415,000 4081 Lybyer Avenue Alpine Minkus $ 325,000 $ 308,750 1900 Glenview Road Lehi Hemandez $ 325,000 $ 302,250 9000 South Sunset Avenue Eagle Mountain Lugo $ 325,000 $ 320,000 8432 South Sunset Avenue Eagle Mountain Minkus $ 285,750 $ 300,000 831 South Weber American Fork Lugo $ 425,815 S 400,000 714 Timp View Lane American Fork Goodrich $ 250,000 $ 232,000 240 East Jefferson Way Eagle Mountain Lugo $ 515,000 $ 485,750 224 Rockaway Street Alpine Pijuan $ 400,000 $ 375,000 260 East Jefferson Way Eagle Mountain Hemandez $ 450,000 $ 400,000 290 East Jefferson Way Eagle Mountain Pijuan $ S 310,000 $ 300,000 8307 S Indian River Drive Lehi Hemandez $ 250,000 $ 255,000 123 Ivy Lane Eagle Mountain Pijuan $ $ 375,500 $ 375,500 9408 Forest Hills Circle Cedar Hills Reuter $ 185,500 $ 179,000 245 Ivy Lane Eagle Mountain Goodrich $ 395,000 $ 375,000 11971 SW 269 Terrace Cedar Hills Carey $ 410,000 $ 397,700 1857 Pine Drive Cedar Hills Hemandez $ 560,700 S 550,000 3461 East Lindon Way American Fork Reuter $ 450,000 $ 400,000 16235 Orange Boulevard Cedar Hills Lugo $ 395,000 $ 380,000 614 Lincoln Drive Eagle Mountain Reuter $ 475,000 $ 425,250 2448 Woodacres Road Lehi Hemandez $ 450,000 $ 382,500 401 Pinecone Circle Alpine Goodrich $ 1,500,120 $ 1,400,000 421 Ivy Lane Eagle Mountain Pijuan $ 500,000 $ 425,000 765 East Sheridan Lane Eagle Mountain Minkus $ 460,750 $ 435,500 61 East Walnut Grove American Fork Goodrich $ 375,000 $ 376,000 1414 N Sheridan Road Alpine Pijuan $ 1,250,000 $ 1,225,000 487 Blue Skies Drive American Fork Goodrich $ 365,750 $ 355,000 10700 Lake Shore Lane Cedar Hills Carey $ 650,000 $ 598,000 73 East Oak Street Eagle Mountain Merkin $ 325,000 $ 325,000 81 Island Drive South Alpine Bethune $ 147,800 $ 150,000 3412 Kilmer Street Lehi Carey $ 180,000 $ 175,000 605 Reservoir Drive Alpine Reuter $ 310,000 $ 291,400 77 East Oak Street Eagle Mountain Bethune $ 345,000 $ 335,000 400 Ivy Lane Eagle Mountain Bethune $ 375,000 S 330,000 1 Southampton Place Lehi Goodrich $ 215,000 $ 195,000 3418 North Sunset Lane Eagle Mountain Bethune $ 450,000 $ 400,000 1892 North 250 West American Fork Carey $ 315,250 $ 300,000 1629 NW 43rd Street Cedar Hills Carey $ 475,000 $ 450,000 3400 North Sunset Lane Eagle Mountain Merkin $ 400,000 $ 375,000 876 South California Way American Fork Hen $ 316,000 $ 316,000 21 Compass Road Cedar Hills Merkin $ 289,900 $ 279,000 34 West Oakley Drive American Fork Carey $ 345,000 $ 330,000 30 Kent Road Lehi Bethune $ 259,900 $ 246,905 140 East 3rd Street Eagle Mountain Hen $ 399,000 $ 350,000 160 West 5th Street Eagle Mountain Carey $ 410,000 $ 350,750 240 West 5th Street Eagle Mountain Reuter $ 285,750 $ 300,000 520 E Spring Street Alpine Minkus $ 189,900 S 186,102 678 Mountain Circle American Fork Goodrich $ 335,000 $ 330,000 3490 North Sunset Lane Eagle Mountain Minkus $ 250,000 $ 275,000 4916 Rock Spring Road Cedar Hills Lugo $ 275,000 $ 264,000 8923 Harris Drive Alpine Minkus $ 589,000 $ 575,000 876 West Hadley Way American Fork Hemandez $ 345,670 $ 345,000 1132 SW 52nd Street Cedar Hills Hemandez $ 254,500 $ 236,685 416 East Oak Eagle Mountain Merkin $ 300,000 $ 250,000 10 Vestal Drive Cedar Hills Carey $ 555,000 $ 565,000 425 East Oak Eagle Mountain Bethune $ 275,900 $ 250,000 876 West Holiday Alpine Goodrich $ 475,000 $ 455,000 103 Jasper Drive Lehi Bethune $ 165,900 $ 159,264 516 East Oak Eagle Mountain Pijuan $ 299,999 $ 280,000 123 Oak Avenue American Fork Carey $ 400,000 $ 400,000 600 Ivy Lane Eagle Mountain Pijuan $ 339,999 $ 310,000 144 Oak Avenue American Fork Goodrich $ 380,500 $ 365,000 1600 Reeves Street Cedar Hills Reuter $ 245,900 $ 233,605 4/1/18 4/1/18 4/1/18 4/1/18 4/1/18 4/3/18 4/3/18 4/6/18 4/8/18 4/12/18 4/12/18 4/12/18 4/12/18 4/13/18 4/13/18 4/15/18 4/18/18 4/18/18 4/18/18 4/19/18 4/28/18 4/28/18 4/28/18 4/28/18 4/29/18 4/29/18 4/30/18 4/30/18 4/30/18 5/1/18 5/1/18 5/1/18 5/1/18 5/1/18 5/1/18 5/2/18 5/5/18 5/5/18 5/5/18 5/5/18 5/5/18 5/5/18 5/6/18 5/12/18 5/13/18 5/15/18 5/18/18 5/22/18 5/23/18 5/22/18 5/23/18 5/26/18 5/28/18 5/28/18 5/28/18 5/31/18 5/31/18 5/31/18 5/31/18 6/1/18 6/2/18 6/2/18 6/3/18 6/5/18 6/6/18 6/10/18 6/12/18 6/13/18 6/18/18 6/20/18 6/23/18 6/23/18 6/24/18 6/24/18 6/24/18 6/29/18 6/29/18 6/30/18 6/30/18 6/30/18 6/30/18 6/16/18 5/15/18 6/1/18 5/25/18 4/30/18 6/10/18 6/1/18 9/30/18 6/2/18 6/12/18 5/30/18 11/1/18 7/3/18 8/5/18 10/15/18 6/30/18 6/23/18 4/30/18 6/30/18 7/2/18 6/1/18 5/28/18 6/3/18 9/15/18 9/1/18 8/25/18 6/19/18 10/1/18 7/1/18 6/18/18 5/5/18 6/6/18 7/16/18 6/26/18 5/30/18 9/30/18 7/16/18 9/23/18 6/16/18 9/30/18 11/15/18 11/1/18 5/15/18 6/6/18 8/15/18 6/9/18 5/31/18 6/16/18 7/15/18 6/29/18 6/23/18 8/30/18 6/18/18 8/15/18 8/1/18 8/19/18 7/15/18 6/30/18 6/1/18 8/15/18 9/2/18 11/30/18 10/15/18 7/1/18 7/26/18 9/15/18 6/25/18 7/21/18 7/8/18 9/30/18 9/21/18 11/2/18 6/30/18 8/15/18 9/18/18 9/6/18 9/30/18 7/15/18 10/1/18 9/1/18 8/16/18 Answer these questions. You must use PIVOT TABLES for questions 2-8 (A SEPARATE SHEET AND PIVOT TABLE PER QUESTION). 1 Complete columns G, J, and K with functions or formulas to obtain the result (Type DONE when complete) 2 What is the average selling price in Alpine? 3 Which city has the highest average % of asking price? 4 Which city has the least number of average days on market? 5 What is the average days on market for all cities? 6 Which city had the lowest average selling price? Assume each agent receives 3% of the selling price in commission. 7 Who made the most money overall? 8 How much did this agent make in commission? A C D E F G H % of Asking Price Listing Date Sale Date Days on Market Sales Agent Commission Amt. 290,000 1 Number 2 1 3 2 4 3 3 5 4 6 5 7 6 8 8 7 9 8 10 9 11 10 12 11 13 12 14 13 15 14 16 15 17 16 18 17 19 18 20 19 21 20 22 21 23 22 24 23 25 24 26 25 27 26 28 27 29 28 30 29 31 30 32 31 33 32 34 33 35 34 36 35 37 36 38 37 39 38 40 39 41 40 42 41 43 42 44 43 45 44 46 45 47 46 48 47 49 48 50 49 51 50 52 51 53 52 54 53 55 54 56 55 57 56 58 57 59 58 60 59 61 60 62 61 63 62 64 63 65 64 66 65 67 66 68 67 69 68 70 69 71 70 72 71 73 72 74 73 75 74 76 75 77 76 78 77 79 78 80 79 81 82 81 Address City Selling Agent Asking Price Selling Price 8687 Kenwood Road Cedar Hills Hemandez $ 725,000 $ 645,250 11 West Oak Circle American Fork Carey $ 350,000 $ 340,000 314 Timp View Drive American Fork Goodrich $ 418,000 $ 400,000 614 West Cedar Drive Lehi Lugo $ 215,800 $ 200,000 750 South Apple Way American Fork Goodrich $ 385,900 $ 385,900 7 Kingston Court Alpine Carey $ 500,000 $ 465,000 618 West Cedar Drive Lehi Lugo $ 300,000 $ 321 North Choctaw American Fork Minkus $ 565,000 $ 535,000 1370 Pinellas Road Alpine Lugo $ 219,000 $ 215,000 1971 Glenview Road Lehi Minkus $ 165,000 $ 156,750 15 West Oak Circle American Fork Hemandez $ 325,000 $ 320,000 575 South Choctaw Alpine Goodrich $ 750 250 S 700,000 10995 SW 88 Court Lehi Goodrich $ 110,000 $ 106,000 143 North Mountain View American Fork Carey $ 314 250 S 304,000 29 East Oak Circle American Fork Merkin $ 555,000 $ 500,000 8030 Steeplechase Drive Alpine Merkin $ 450,000 $ 382,500 2006 Cutwater Court Alpine Minkus $ 345,000 $ 339,999 9876 South Sunset Avenue Eagle Mountain Hemandez $ 300,000 $ 300,000 321 West Walnut Grove American Fork Goodrich $ 425,000 $ 415,000 4081 Lybyer Avenue Alpine Minkus $ 325,000 $ 308,750 1900 Glenview Road Lehi Hemandez $ 325,000 $ 302,250 9000 South Sunset Avenue Eagle Mountain Lugo $ 325,000 $ 320,000 8432 South Sunset Avenue Eagle Mountain Minkus $ 285,750 $ 300,000 831 South Weber American Fork Lugo $ 425,815 S 400,000 714 Timp View Lane American Fork Goodrich $ 250,000 $ 232,000 240 East Jefferson Way Eagle Mountain Lugo $ 515,000 $ 485,750 224 Rockaway Street Alpine Pijuan $ 400,000 $ 375,000 260 East Jefferson Way Eagle Mountain Hemandez $ 450,000 $ 400,000 290 East Jefferson Way Eagle Mountain Pijuan $ S 310,000 $ 300,000 8307 S Indian River Drive Lehi Hemandez $ 250,000 $ 255,000 123 Ivy Lane Eagle Mountain Pijuan $ $ 375,500 $ 375,500 9408 Forest Hills Circle Cedar Hills Reuter $ 185,500 $ 179,000 245 Ivy Lane Eagle Mountain Goodrich $ 395,000 $ 375,000 11971 SW 269 Terrace Cedar Hills Carey $ 410,000 $ 397,700 1857 Pine Drive Cedar Hills Hemandez $ 560,700 S 550,000 3461 East Lindon Way American Fork Reuter $ 450,000 $ 400,000 16235 Orange Boulevard Cedar Hills Lugo $ 395,000 $ 380,000 614 Lincoln Drive Eagle Mountain Reuter $ 475,000 $ 425,250 2448 Woodacres Road Lehi Hemandez $ 450,000 $ 382,500 401 Pinecone Circle Alpine Goodrich $ 1,500,120 $ 1,400,000 421 Ivy Lane Eagle Mountain Pijuan $ 500,000 $ 425,000 765 East Sheridan Lane Eagle Mountain Minkus $ 460,750 $ 435,500 61 East Walnut Grove American Fork Goodrich $ 375,000 $ 376,000 1414 N Sheridan Road Alpine Pijuan $ 1,250,000 $ 1,225,000 487 Blue Skies Drive American Fork Goodrich $ 365,750 $ 355,000 10700 Lake Shore Lane Cedar Hills Carey $ 650,000 $ 598,000 73 East Oak Street Eagle Mountain Merkin $ 325,000 $ 325,000 81 Island Drive South Alpine Bethune $ 147,800 $ 150,000 3412 Kilmer Street Lehi Carey $ 180,000 $ 175,000 605 Reservoir Drive Alpine Reuter $ 310,000 $ 291,400 77 East Oak Street Eagle Mountain Bethune $ 345,000 $ 335,000 400 Ivy Lane Eagle Mountain Bethune $ 375,000 S 330,000 1 Southampton Place Lehi Goodrich $ 215,000 $ 195,000 3418 North Sunset Lane Eagle Mountain Bethune $ 450,000 $ 400,000 1892 North 250 West American Fork Carey $ 315,250 $ 300,000 1629 NW 43rd Street Cedar Hills Carey $ 475,000 $ 450,000 3400 North Sunset Lane Eagle Mountain Merkin $ 400,000 $ 375,000 876 South California Way American Fork Hen $ 316,000 $ 316,000 21 Compass Road Cedar Hills Merkin $ 289,900 $ 279,000 34 West Oakley Drive American Fork Carey $ 345,000 $ 330,000 30 Kent Road Lehi Bethune $ 259,900 $ 246,905 140 East 3rd Street Eagle Mountain Hen $ 399,000 $ 350,000 160 West 5th Street Eagle Mountain Carey $ 410,000 $ 350,750 240 West 5th Street Eagle Mountain Reuter $ 285,750 $ 300,000 520 E Spring Street Alpine Minkus $ 189,900 S 186,102 678 Mountain Circle American Fork Goodrich $ 335,000 $ 330,000 3490 North Sunset Lane Eagle Mountain Minkus $ 250,000 $ 275,000 4916 Rock Spring Road Cedar Hills Lugo $ 275,000 $ 264,000 8923 Harris Drive Alpine Minkus $ 589,000 $ 575,000 876 West Hadley Way American Fork Hemandez $ 345,670 $ 345,000 1132 SW 52nd Street Cedar Hills Hemandez $ 254,500 $ 236,685 416 East Oak Eagle Mountain Merkin $ 300,000 $ 250,000 10 Vestal Drive Cedar Hills Carey $ 555,000 $ 565,000 425 East Oak Eagle Mountain Bethune $ 275,900 $ 250,000 876 West Holiday Alpine Goodrich $ 475,000 $ 455,000 103 Jasper Drive Lehi Bethune $ 165,900 $ 159,264 516 East Oak Eagle Mountain Pijuan $ 299,999 $ 280,000 123 Oak Avenue American Fork Carey $ 400,000 $ 400,000 600 Ivy Lane Eagle Mountain Pijuan $ 339,999 $ 310,000 144 Oak Avenue American Fork Goodrich $ 380,500 $ 365,000 1600 Reeves Street Cedar Hills Reuter $ 245,900 $ 233,605 4/1/18 4/1/18 4/1/18 4/1/18 4/1/18 4/3/18 4/3/18 4/6/18 4/8/18 4/12/18 4/12/18 4/12/18 4/12/18 4/13/18 4/13/18 4/15/18 4/18/18 4/18/18 4/18/18 4/19/18 4/28/18 4/28/18 4/28/18 4/28/18 4/29/18 4/29/18 4/30/18 4/30/18 4/30/18 5/1/18 5/1/18 5/1/18 5/1/18 5/1/18 5/1/18 5/2/18 5/5/18 5/5/18 5/5/18 5/5/18 5/5/18 5/5/18 5/6/18 5/12/18 5/13/18 5/15/18 5/18/18 5/22/18 5/23/18 5/22/18 5/23/18 5/26/18 5/28/18 5/28/18 5/28/18 5/31/18 5/31/18 5/31/18 5/31/18 6/1/18 6/2/18 6/2/18 6/3/18 6/5/18 6/6/18 6/10/18 6/12/18 6/13/18 6/18/18 6/20/18 6/23/18 6/23/18 6/24/18 6/24/18 6/24/18 6/29/18 6/29/18 6/30/18 6/30/18 6/30/18 6/30/18 6/16/18 5/15/18 6/1/18 5/25/18 4/30/18 6/10/18 6/1/18 9/30/18 6/2/18 6/12/18 5/30/18 11/1/18 7/3/18 8/5/18 10/15/18 6/30/18 6/23/18 4/30/18 6/30/18 7/2/18 6/1/18 5/28/18 6/3/18 9/15/18 9/1/18 8/25/18 6/19/18 10/1/18 7/1/18 6/18/18 5/5/18 6/6/18 7/16/18 6/26/18 5/30/18 9/30/18 7/16/18 9/23/18 6/16/18 9/30/18 11/15/18 11/1/18 5/15/18 6/6/18 8/15/18 6/9/18 5/31/18 6/16/18 7/15/18 6/29/18 6/23/18 8/30/18 6/18/18 8/15/18 8/1/18 8/19/18 7/15/18 6/30/18 6/1/18 8/15/18 9/2/18 11/30/18 10/15/18 7/1/18 7/26/18 9/15/18 6/25/18 7/21/18 7/8/18 9/30/18 9/21/18 11/2/18 6/30/18 8/15/18 9/18/18 9/6/18 9/30/18 7/15/18 10/1/18 9/1/18 8/16/18