Question: a ) Make a table with cells A 1 to 1 2 1 with name EmpTable, a heading row, banding rows, no total row, and
a Make a table with cells A to with name EmpTable, a heading row, banding rows, no total row, and no filter buttons. Select an appropriate table style. pointsb Write a function in cell A to return the number of employees with VP title and greater than years of experience. Use structured references to refer to columns in the table. pointsc Write a function in cell B to return the average salary of employees with VP Title. Use structured references to refer to columns in the table. pointsd Write a function in cell C to return the average years of experience of employees whose salaries are greater than $ Use structured references to refer to columns in the table. pointse Write a function in cell D to return the number of employees with greater than and less than or equal years of experience Use structured references to refer to columns in the table. pointsQuestion write a nested If function in cell F to return "Low", "Average" or "High" based on Employees' Years of Experience. You can find the criteria in the following table. Use structured references to refer to columns in the table. points
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
