Question: [3] Referencing [This question is designed to allow you to apply the referencing skills learned in class.] The worksheet Q3 contains the ranking each of
[3] Referencing [This question is designed to allow you to apply the referencing skills learned in class.] The worksheet Q3 contains the ranking each of 35 workers was given (on a 0-10 scale) to three different jobs. The file also gives the job to which each worker is currently assigned. (a) In the B column, use the Lookup function to compute each worker's ranking for the job to which they are currently assigned. (b) In the A column, use a formula to compute each worker's ranking for the job to which the worker is currently assigned by the INDEX function (in A column). (c) The worker with ranks in the top 30% will be regarded as a "Good Worker". Choose either the A or B column to highlight the top 30% of workers. (Use conditional formatting top/bottom rules
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
