need help on the spread sheet and the right option to choose

In Column E (General Opinion) something was done to ensure that the cell values make sense. What was done to these cells? A) Data Validation was used to limit the values to a list, containing only G and B B) Bob the gremlin was hired to ever-so-slightly annoy, by a precise application of "wet willies", anyone who tries to change these cells. C) Worksheet Protection was applied to keep users from changing these cells. D) Data Validation was used to ensure that the user types in a single letter (text length of 1 character) Fle Home Insert Draw Page Layout Fas Data Review View Heln Calibri 110 A A La Cony - at Paimer H. BIU -- 27 O $ - % 9841 Insert Dalt & char font Algement Formatting Table Styles E17 > for B C D E F G H 2 3 5 Targets Probation (in years) Performance General Opinion 6. G 4 5 6 7 8 9 10 Bonus Do not edit this cell! "Bonus Multi Employee Years Worked 5 Performance (0 to 10) 6 7. General Opinion (G or B) G Probation Years Remaining Bonus Bonus Bob Carol Ted Alice G 3 7 4 4 B 6 B 12 13 14 15 16 17 18 19 20 21 What if Vlookup IF Muntinle Worksheets North South East West Bonus Question Type here to search O RE E DAD