In cell $017$: 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.n cell $014$ 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.n cell P$17$: 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 P$14$: use the appropriate function to answer: How many employees have a Net Monthly Salary greater than $7500?$Blank