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 A1 to 121 with name EmpTable, a heading row, banding rows, no total row, and no filter buttons. Select an appropriate table style. (2 points)b) Write a function in cell A23 to return the number of employees with VP title and greater than 10 years of experience. Use structured references to refer to columns in the table. (5 points)c) Write a function in cell B23 to return the average salary of employees with VP Title. Use structured references to refer to columns in the table. (4 points)d) Write a function in cell C23 to return the average years of experience of employees whose salaries are greater than $100,000. Use structured references to refer to columns in the table. (4 points)e) Write a function in cell D23 to return the number of employees with greater than 5 and less than or equal 10 years of experience Use structured references to refer to columns in the table. (5 points)Question 2) write a nested If function in cell F2 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. (10 points)
a ) Make a table with cells A 1 to 1 2 1 with

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!