Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Note: First, Solve the questions in Excel. Then copy and paste the functions below each question in this word document. You just need to submit
Note: First, Solve the questions in Excel. Then copy and paste the functions below each question in this word document. You just need to submit the word document.
Write a function in cell to return the first name of Employees. points
Write a function is cell to return the last name of Employees. points
Write a function in cell E to return the total sales of Employees. points
Write a function in cell to return average salary of Employees. points
Write a function in cell to return the Experience level of Employees. If an Employee has more than years of Experience, cell must show "High", otherwise the cell must be left blank. points
Write a function in Cell to return "Eligible" or "not Eligible" based on the following criteria:
An employee is eligible for a promotion if HisHer sale is greater than $ or hisher years of experience is greater than points
Write a function in cell to return the new salary of Employees. If the title of Employee is Associate and his sales is less than $ his her new salary is of hisher initial salary ie column F Otherwise, cell J must be left blank. points
Write a function in cell to return High and Low based on the following criteria. Your function must return "High" if the difference between the salary of an employee and the average salary of all employees is greater than $ otherwise your function must return "Low". points
The table in the VLOOKUP worksheet shows that average salary of the employees in the same industry based on their title in three different states. You're going to compare the salary of your employees with those in Texas. To do so you need to write a function in cell to return the average salary of employees in TX based on their title points
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started