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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!