Dpen Fredmer. Click Enable content or Enable macros {if asked]. Click the button to start the test. Enter your name and student number then click OK Go to the Q2 sheet Display the average Years of Service and Salary by Perf within City (do not use a pivot table). (31 True (31 False Employee ID Last Name First Name City Age Yrs of Service Salary Job Title Perf Sales 1000337 Tobey Chris Toronto 55.0 13 $ 89,642 Manager IS 167,206 1000402 Zambroski Ray Toronto 39.8 1 $ 61,975 Sales Rep 1 5 176,563 1000549 Akhtar Sarah Ajax 46.9 16 $ 66,402 Sales Rep 2 5 232,280 1000602 Shapiro Molly Pickering 41.0 10 $ 58,655 Sales Rep 2 206,129 1000737 Raddatz Rick Pickering 54.5 5 $ 80,789 Advisor W 240,095 1000849 Fine Suzar Markham 48.8 17 $ 40,947 Sales Rep 314,214 1000902 Leste Linda Ajax 58.8 29 $ 100,674 Manager 163,346 John Toronto 47.7 9 $ 70,828 Advisor 199,349 1001011 Thorson Amy Toronto 39.8 199,020 1001125 Luehmann 10 $107,100 Manager 1001325 Bowen Kimberly Markham 45.2 9 $ 71,935 Advisor 187,927 1001455 White Bagheera Pickering 45.0 8 $ 58,655 Sales Rep 309,105 1001511 Fort Garth Pickering 39.1 6 $ 39,841 Sales Rep 181,272 1001625 Horton William Markham 56.7 14 $ 63,081 Sales Rep 193,016 1001825 Kunze Cornelia Ajax 44.0 g $ 79,682 Advisor 142,914 1001949 Atkinson Teresa Markham 56.2 17 $ 94,069 Manager 120,610 1002311 Kelly Robert Markham 39.1 5 $ 81,895 Advisor 177,934 W W 1002437 Mendlen David Toronto 44.6 6 $ 29,880 Sales Rep 258,346 1002549 Fluegel Jay Markham 52.4 16 $ 38,734 Sales Rep 269,121 1002625 Seidenspinner Peter Markham 48.9 19 $ 39,841 Sales Rep 200,032 1002737 Lysaker Jenny Toronto 53.7 20 $ 94,069 Manager 198,720 1002802 Harui Roger Toronto 44.7 10 $ 30,987 Sales Rep 166,077 Suki 335,558 1002955 White Pickering 41.1 10 $ 94,069 Manager 1003049 Grande Jon Pickering 66.6 27 $ 83,002 Advisor 258,294 Mikael Markham 64.9 28 $ 91,856 Manager 229,700 1003111 Sandberg 1003249 Yoshida Kim Ajax 19 8 $ 106,029 Manager 1 163,516 Mark Pickering 10 $ 48,694 Sales Rep 1 195,038 1003311 Hassall 64.4 1003437 Mccann Thom Pickering 68.0 16 $ 52,014 Sales Rep 1 253,206 1003655 Conroy Stephanie Pickering 46.8 12 $ 117,702 Manager 250,440 1003837 Fallon Scott Pickering 60.0 12 $ 70,828 Advisor 165,815 1004102 Funk Don Ajax 61.9 16 $ 100,674 Manager 311,865 1004425 Jones Beverly Ajax 58.2 19 $ 47,588 Sales Rep 138,388 1004555 Lugo Jose Markham 60.0 10 $ 98,532 Manager 202,342 1004637 Emanuel Michael Markham 45.2 10 $ 43,161 Sales Rep 216,431 1004755 Bacon Dan Ajax 67.9 31 $ 35,414 Sales Rep 316,996 1004837 Delaney Aidan Pickering 63.4 26 $ 63,081 Sales Rep 1 157,939 1004925 Wolfe-Hellene Marta Pickering 49.1 17 $ 43,161 Sales Rep 142,460