For jahguy

For jahguy

Apply ALL of the following Excel skills in this spreadsheet:

(0) use proper references;

(1) AVG, MAX, MIN, StDev, Median;

(2) COUNTIF, IF with threshold;

(3) VLOOKUP, + IF to determine the lookup table and column - "DWP"-type of question; 

(4) IF (for comparison), with VLOOKUP to find the right values to compare - "LA Health Dept"-type of question;

(5) Pivot table

If you feel some parts difficult, you can leave those parts off, but with point deductions. PLEASE TRY YOUR BEST. 

Part (3) has a little bit extra thinking, when the search is done with student's name, since the 2nd half of the spreadsheet only has ID but no name - so tolookup the math-science group pf subjects you have to first lookup the corresponding ID using the name entered.