D R U 2 Reus Renu 30 Deportes 202 211 1225 017 Region RCI RO 2009 00% 1.000 1200 BITS AD 400 1.200 11 000 1.00 VE 17500 WWE W TER Du US 1255 100 CB SIMIT DO NOT DELETE DO NOT DELETE DO MOT DELETE Gold 1 4 Arte L Enter Function below according to test instruction TET 210 30 1374 RE JUD TH CS 140 1421 5 19 TIRS 1201 SIE GE DI 50 07 21 . 100 D TO TU CHEE 20 ARE HER TNS WIE LE TEST DATA PIVOT Owner B G . N Bonus Bonus 1 Taslima Patel 2 Student Name 3 18.00 D E Rating Management Comment 1 Review Needed 2 Monitor 3 Fair 4 Good 5. Excellent 100 200 500 750 1,000 H Annual Units Sold 0 16,500 18,000 19,500 22,000 270 950 1,400 1,800 2.500 Award? No Award Certificate Bronze Gold Platinum Bonus Rate 0 75% 1 50% 3 25% 4.50% 6.00% $ 3,950 $ $ 4.650 $ 5,100 $ 3,500 10 11 12 13 Year of Hire Gender RG2 1998 1989 1990 1997 1991 1988 1992 1987 *XXX BUNNY aos of 14 15 16 17 19 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Employee ID 10014766 11134120 10062555 10752656 10000446 11064518 12371307 11681945 10966149 10763212 11922536 10952776 11235308 11646365 12103860 10891724 12075206 11019095 12602917 12006620 110RRRT Last Name Miller Lee Morgan Ralls Matey Young Alouca Tratt Matthews Dunn Gronco Hohman Vernhes Bradley Tiano Henshaw Poland Pardi Philips Coleman IRANI Department 1225 1237 1237 1211 1211 1249 1211 1202 1225 1225 1249 1202 1265 1255 1237 First Name Region Geol RG3 Mark Louise RG3 Kim RG1 Michael RG1 Jonathan RG1 Steve RG3 Adam RG3 Joseph RG3 Micheal RG2 Douglas RG4 Bob RG1 Laurent RG4 David M RG2 Mike RG3 Jet RGA Carole RGA William RG3 Carol RO3 Pat RG1 ish RO Job Title Rating Junior Sales Red 2 Manager 4 Adnsor 4 Sales Rep 5 Junior Sales Red 1 Manager 5 Junior Sales Red 1 Manager 3 Junior Sales Red 3 Junior Sales Red 1 Junior Sales Red 1 Junior Sales Red 3 Sales Rep 6 Sales Rep 3 Sales Rep 4 Junior Sales Rep 2 Junior Sales Red 4 Sales Rep 3 Junior Sales Red 2 Manager 4 Man 4 1990 1999 1986 1993 1985 1984 1986 1999 1996 1981 2000 1909 1977 Age 61 5 595 655 525 53 5 50 $ 50 $ 665 46 $ 625 55 5 665 535 635 595 655 435 66 S 535 495 R21 Salary 32.118 136,465 86,624 50,657 34,672 97 983 34,706 126.164 37.294 35 401 36,323 33,816 44.760 74.578 54 040 37 745 34,211 44.256 36.395 120.975 117 572 M M F F M M M M M M M M M M M M F M F F M Units Sold Units Sold Units Sold U Qtr 1 Qt2 Otr3 3.229 3,499 3.884 5,683 6,693 5,113 4,011 4.109 4.491 5,460 5,495 4,854 3,601 3,643 3,450 5,140 5.194 4,469 3,940 4.213 4.557 3,852 3.864 6.052 5,786 5.987 5,865 5,851 6,059 4,261 5,370 5,535 4.785 4 124 4,145 5,856 3668 3,682 5,651 4,546 4,662 5,704 6,311 5,311 5,794 4,711 4.095 6,060 4,077 4,933 5.848 4.427 4,427 4.397 3.789 3.789 5.885 4,034 4,067 5.676 7641 370 111 1237 1237 1265 1211 1202 1211 In R15 Use the appropriate function that will return TRUJE if the Region is RG2. OR the Department in 1225 OR the Gender is Male of the Units Sold Qtr 2 is less than 5,000. Copy the function down to the other cells in the column In coll R10 use the appropriate function to calculate how many are TRUE
