To complete the tasks mentioned:In cell O$17,$ you can use the VLOOKUP function to return the Deduction Rate $1$ from the appropriate table. The formula would be:$`=$VLOOKUP$($Gross Monthly Salary, Table range, Column index, False$)`$Replace "Gross Monthly Salary" with the cell reference of the Gross Monthly Salary, "Table range" with the range of the appropriate table, and "Column index" with the column number that contains the Deduction Rate $1.$To calculate the Monthly Deduction, multiply the Deduction Rate $1$ by the Gross Monthly Salary. The formula for cell O$17$ would be:$`=$O$17*$ Gross Monthly Salary$`$Copy this formula down to the other cells in the column.In cell O$14,$ you can use the COUNTIF function to count the number of employees with a Monthly Deduction less than $5000.$ The formula would be:$`=$COUNTIF$($Monthly Deduction range, $"<5000")`$Replace "Monthly Deduction range" with the range of the Monthly Deduction column.In cell P$17,$ you can calculate the Net Monthly Salary by subtracting the Monthly Deduction from the Gross Monthly Salary. The formula would be:$`=$Gross Monthly Salary $-$ Monthly Deduction$`$Copy this formula to all cells in the column.In cell P$14,$ you can use the SUM function to calculate the total for all the employees. The formula would be:$`=$SUM$($Net Monthly Salary range$)`$Replace "Net Monthly Salary range" with the range of the Net Monthly Salary column.Format the answer in cell P$14$ as comma style with $0$ decimal places.