![]() Notice the Refers To field box contains the cell addresses of the highlighted/selected range. Click the arrow beside the Scope field box and choose Sheet1 from the list to identify the range location. Select Formulas > Define Name > Define Name and enter the word Scores in the Name field box. Enter the skill points (scores) between 10 and 100 for each applicant in cells B2:B11 and then name the range. The solution: Give the applicants a skills test, and use Excel’s PERCENTRANK.EXC function to determine the ranking percentile of each applicant.Įnter 10 applicant names in cells A2:A11. However, they must meet some minimum qualifications that are not generally indicated on resumes, such as how to safely remove porcupine quills from a dog’s face and neck. From the resumes and the initial interviews, they all seem to be equally qualified. Imagine that you have dozens of people applying for national parks and forestry jobs. ![]() ![]() Calculate the percentage of a task/project completed How to do percent ranking
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |