EXERCISE 8: USING "LOOKUP" AND "COUNTIF" FUNCTIONS TO RANK EMPLOYEE PERFORMANCE Managers often like to rank employees performance. One scheme called "20-70-10," or more disparagingly as "Rank and Yank," categorizes the top 20 percent of employees as "Best," the middle 70 percent of employees "Near Best," and the bottom 10 percent as "Below Best." Go to the "Excel Student Spreadsheets BUS 2000" and click on the tab/worksheet labeled "Lookup". There you will find the performance ratings-on a ten-point scale-for 20 employees. Each employee has 3 performance ratings. ● ● Then, in the 6th Column, or Column F, use the LOOKUP function below to classify the employees. o=LOOKUP(E2,(0,4,9,10},{"Below Best", "Near Best", "Best"}) The Lookup formula is structured as follows: . E2 is the Cell containing the data for which the calculation should be made. 0 to 4 is the classification of "Below Best". 4 to 9 is the classification of "Near Best". 9 to 10 is the classification of "Best". The words "Below Best", "Near Best", and "Best" are placed for each of the three classifications according to an employee's average rating. Using the results, do the following: 1. List the names of the "Best" employees 2. List the names of the "Near Best" employees 3. List the names of the "Below Best" employees ● ● In the 5th Column, or Column E, calculate the average performance rating for each employee to one decimal place. ● ● Next, redefine the Lookup function to classify employees as "Above Average" and "Below Average" based on whether they scored above or below an average of 5 in their three performance scores. Place the results in the 7th Column, or Column G. Next, we're going to count how many employees were categorized as either "Above Average" or "Below Average". Place the following results in cells B23 and 824. 4. How many people scored "Above Average?" 5. How many people scored "Below Average?"

How would you as the technician go about finding the source of the problems?   If you were working at a Help Desk and someone called with these problems, could “you” resolve these problems over the phone? Or would it require a visit from the technician to that computer? Explain.

A Helping Hand is an Australian charity that helps people in Australia and overseas. Their work in Australia involves serving hot meals to the homeless, providing food packs to families in need and companionship to sick children and the elderly. Overseas, the charity employs a nurse to support the Naga Community in the Philippines and runs an Operational Therapy Centre to help children. The charity also runs a yearly mission where volunteers travel to various countries to deliver medical aid and support the vulnerable.  The charity has identified the inefficient way in which it currently operates. This inefficiency means the charity is unable to easily maintain compliance with regulatory requirements (e.g. WWC monitoring) nor easily fill available shifts and engage with current and prospective stakeholders.  To solve the issue, the charity wants to develop a website that facilitates administration (i.e.  Login Creations, Registration Requests and Password Resets), Donations and…

Explain whether you agree or disagree with the statement that a person needs to have a solid math foundation in order to properly use Microsoft Excel. What are the benefits, if any, for having a solid math foundation? Can a person who is not efficient in math become proficient in Excel? Why or why not?