Apply ALL of the following Excel skills in this spreadsheet:

| November 17, 2015

 

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.

Get a 5 % discount on an order above $ 150
Use the following coupon code :
2018DISC
Week6-Disc
can you please help with my project on computer architecture ?

Category: Homework Help

Our Services:
Order a customized paper today!