PLEASE NOTE THAT THESE QUESTIONS ARE RELATED TO ADVANCE EXCEL AND YOU NEED TO USE EMPLOYEE ID AND REFER TO THE TABLE ABOVE BY USING VLOOK UP(If necessary) TO ANSWER THE QUESTIONS

Rating Management Revansh Paniwani Comment Bonus Units Sold Bonus Award ? Bonus Student Name Rate Department Supervisor Bonus Region Bonus Rate Bonus Review Needed 100 Manager Monitor 270 No Award 0.75% 3,950 $ 18.00 Job Title Bonus 1202 Bonus Rate Laing 16,500 1,200 950 Certificate $ 4,650 RG1 2.00% 1, 100 Suzanne 500 18,000 1,400 Bronze $ 5,100 1225 2.25% 1.280 Jillian Advisor 1,000 3.00% Good 750 19, 500 Cold Ahmed RG3 Junior Sales Rep 400 4.50% 3,500 Arjun 2.00% 1237 2.35% 1, 175 Excellent 1,000 22,000 2.500 Platinum Enkomo 6.00% RGA 1.95% 1.200 Jian Manager 1,500 3.25% 1249 Da Silva 950 Sales Rep 600 2.50% 1255 Borrow 1,050 Column AA is not Answers Column X and Y are not used this Term used this Term DO NOT DELETE DONOT DELETE DO NOT DELETE Employee ID Last Name First Name Region Department Column AA is not Job Title Rating Year of Hire Age Salary Gender Units Sold Units Sold Units Sold Units Sold Qtr 1 Qtr 2 Qtr 3 Annual Units Sold Column X and Y are not used this Term used this Term Miller Geof RG3 1225 Junior Sales Rep 1998 Mark 61 $ 32,118 Enter Functions below according to Test instructions 11134120 Lee 1237 Manager M 1989 M 3.229 15,585 10062565 Morgan 59 $ 36,465 Louise RG3 1237 Advisor 5.683 10752656 Ralls 1990 65 $ 86,624 5.113 4,011 20.395 Kim RG 1 1211 4.109 4,491 Sales Rep 10008446 1997 Michael RG1 50,657 18.252 1211 5,460 Junior Sales Rep 4.804 1991 53 $ 34.572 19.774 Jonathan 1249 Manager 3.601 3,643 3,450 58 $ 97,983 16,091 Steve 1211 5. 140 5, 194 4,469 Junior Sales Re 11681945 Tratt 50 $ 1202 34.706 Manager B.940 1987 66 $ 5,781 18,491 10966149 Matthews 126, 164 Joseph 3,852 3,864 1225 Junior Sales Rep 37.294 6,052 M 6,534 20,302 10763212 1990 Micheal RG2 1225 5,786 5,984 Junior Sales Rep 1999 M 5,865 5,315 2.950 62 $ Groncki Douglas 5,851 6,059 Junior Sales Rep 4,261 6.554 22.125 0952776 Hohman Bob 1202 36.323 Junior Sales Rep 5.370 5,535 19,870 11235308 Laurent 1255 66 $ 33,816 Sales Rep 4.124 20,688 Bradley David M RG2 44,760 1255 Sales Rep 3,668 3,682 1984 5.551 74,578 5,641 18,542 Mike Sales Rep 4.546 4.582 5,704 5,897 Henshaw 1986 20,729 10891/24 Jeff 54,040 RG4 5,311 1237 Junior Sales Re 5.311 5,794 5,924 22,340 120/5206 Poland Carole Pardi 1237 4.711 Junior Sales Rep 11019095 Wiliam RG3 4.877 4,933 12602917 1255 Sales Rep Philips Carol RG3 1211 66 $ 4.427 20.601 1202 53 $ 6,459 19 710 12086520 Junior Sales Rep Coleman RG 1 3,789 Manager 49 5 3,789 4,374 17,837 11036832 Barnhill 28,975 Josh 4.034 5,406 19, 183 11814480 Manager Samarawickran Prasanna RG3 1202 3.541 Advisor 4.501 67 $ 17,923 10759665 Sutton Brad RG4 1202 66,283 5,243 Manager 1999 5,975 59 $ 22,159 torice Bill RG2 05.511 1225 4.652 Junior Sales Rep 4.393 5,684 Jeff 53 $ Manager 5, 120 19,426 5,260 Anderson Amy Sales Rep 40 3 3.761 5,876 21,826 11539409 Corets Eva RG3 1225 12257506 RG3 Advisor 1978 Goodhand David 1225 Manager 3,391 3,439 11654831 Jose RG3 1255 7.721 4.473 4,245 Manager 4.653 6,242 5,044 20.412 11984094 Salman 60 $ 3.486 12143803 Junior Sales Rep 3,504 5,585 18,435 Sax Jenny 1225 42 5 10818004 Manager 31,207 3.275 Richard RG3 1255 39 $ 17.547 Junior Sales Rep 82,035 5,506 33,822 4,731 6,678 22.357 12086931 Michelle RGA 1225 3,727 4,237 17.679 11198601 Manager 1991 RG4 1211 122,214 3,995 4.050 4.145 6,447 Advisor 18,637 10633393 Flood Kathie 1255 73.537 Sales Rep 4.174 4,256 5,074 18, 176 12324725 Beck Bradley RG2 4.992 1255 Advisor 4.037 12027369 Kaarin 59 $ RG2 3,957 3,993 18.014 12811230 1255 Sales Rep 63,702 5,656 19,092 Porzuczek Peter RG4 1249 11057057 Sales Rep 3,520 3,541 5,484 3,825 16,370 Doris 1237 5,370 5,517 Junior Sales Rep 1997 5,006 5,786 100/5295 COX 1237 5.623 21.679 Arlette 5,968 5,229 4,717 Advisor 21,537 11642396 Bonifaz Luis 4,717 1202 Advisor 4,992 5,375 20,834 1488704 Tiedt RG4 1996 5,750 49 $ 3,913 Danielle 1225 $4,589 Sales Rep 51 5 4.023 6,044 6,798 20.778 10453501 Sandberg 10,281 3. 306 Mikael RG3 1211 Junior Sales Rep 1977 5.677 3,391 5,729 5, 121 17,547 1. 146 4,246 4,068 5.923 18,383Bonus Units Sold Bonus Award ? Bonus Department Supervisor Bonus Region Bonus Rate Bonus Manag Job Title Bonus Bonus Rate Revansh Paniwani Advisor E Junior Sales Rep 400 8 8 8 8