Write a Hlookup function to assign an approximate commission rate to the employees based on their sales

SKU: Ques15 Category:

The CEO of the company has decided to promote some of his employees based on some eligibility criteria

 

Order Now

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)

OR

(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

 

 
 

Writing your homework and assignments all on your own is a difficult task. So, Assignments4u has made it easy for students by helping them in writing their assignments. Assignments4u will assist you in completing your tasks, and you can approach us with all your assignment, homework, and essay writing requirements.

We have over 4350+ experienced writers working as experts in different streams of study. Get all your academic doubts clarified and take pride in learning subjects like history, math’s or law. Our assignment help and essay help is available in countries like USA, Australia, New Zealand, Singapore and many more. Get accounting assignment help, corporate nursing assignment help, marketing assignment help or else statistics assignment help in exchange for a nominal price.

Reviews

There are no reviews yet.

Be the first to review “Write a Hlookup function to assign an approximate commission rate to the employees based on their sales”

Your email address will not be published. Required fields are marked *

Sorry no more offers available

When assignments gets tough, get tougher

Want a fresh solution like this one? 
We are available 24/7
ORDER NOW
+1
Share
Tweet
Pin
Call Back