My tasks were

1) Populate column D to return "PASS" if the score in column C is greater than 60, otherwise return "FAIL"

 

2) Populate column E to return a letter grade based on the score in column C, using the logic below:

 

A = >=90

B = 80-89

C = 70-79

D = 60-69

F = <60

 

3) Populate column F to return "OUTLIER" if the score in column C is either <60 or >90, otherwise return "AVG"

 

4) Populate column G to return "Male Achiever" if Gender = M and the score in column C is >95, "Female Achiever" if Gender = F and the score in column C is >95, otherwise "None"