Answer following questions:
Q1. The CEO of the company has decided to promote some of his employees based on some eligibility criteria. Using the Employee Worksheet write a function in cell K8 to return “eligible” and “not eligible” based on following conditions.(You just need to write the function for cell K8 and explain your answer).
An employee is eligible if:
(His/her years of experience is greater than 15)and(his/her age is greater than 50)
(He/she holds a Master degree)and(his/her salary is less than $65,000)
Q2. Write a Hlookup function to assign an approximate commission rate to the employees based on their sales. (You just need to write the function for cell J8 and explain your answer)
Q3. Your department is interested to know whether higher level of education would contribute to higher sales or not. For that purpose, your supervisor asked you to compare the average sales of analysts with Master and bachelor degree. If the average sales of analysts with master degree is greater than analysts with bachelor degree, Cell Q4 should show “master” otherwise it has to show “bachelor”. You need to explain your answer.
Q4.Write a function ( nested-if) to show each employee’s credit score rating ( ranging from Excellent to Bad)based on following criteria ( you need to write the function in Cell M8 and explain your answer)
- 750 and above: Excellent
- 700 – 749: Good
- 630 – 699: Medium
- 580 – 629: Low
- Less than 580:Bad