Question: In cell O 1 7 : Use the VLOOKUP function to return the Deduction Rate 3 from the appropriate table at the top of the

In cell O17: Use the VLOOKUP function to return the Deduction Rate 3 from the appropriate table at the top of the worksheet. Multiply this Deduction Rate 3 by the Gross Monthly Salary to calculate the Monthly Deduction. Copy the function down to the other cells in the column.
In cell O14 use the appropriate function to answer: How many employees have a Monthly Deduction less than 1500?Blank 1 Format answer as comma style, 0 decimal.
In cell P17: Calculate the Net Monthly Salary by subtracting the Monthly Deduction from the Gross Monthly Salary. Copy the formula to all cells in the column.
In cell P14: use the appropriate function to answer: How many employees have a Net Monthly Salary greater than 7500?Blank 2

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 Accounting Questions!