14 Use the Format Painter to apply the formatting from the cell A3 to the range A28:B28. N 15 Use Advanced Filtering to restrict the data to only display FT employees based on the criteria W in the range K10:K11. Place the results in cell A29. 16 Enter a database function in cell K18 to determine the total number of FT employees. To N complete the function use the range A5:H25 as the database argument, cell E5 for the field, and the range K10:K11 for the criteria. 17 Enter a database function in cell K19 to determine the total value of FT employee salaries. To N complete the function use the range A5:H25 as the database argument, cell H5 for the field, and the range K10:K11 for the criteria. 18 Enter a database function in cell K20 to determine the average FT employee salary. To 3 complete the function use the range A5:H25 as the database argument, cell H5 for the field, and the range K10:K11 for the criteria. 19 Enter a database function in cell K21 to determine the highest FT salary. To complete the function use the range A5:H25 as the database argument, cell H5 for the field, and the range K10:K11 for the criteria. 20 Format the range K19:K21 with Currency Number Format. N 21 Ensure that the New_Construction worksheet is active. Use Goal Seek to reduce the monthly payment in cell B6 to the optimal value of $8000. Complete this task by changing the Loan amount in cell E6. 22 Create the following three scenarios using Scenario Manager. The scenarios should change 7.4 the cells B7, B8, and E6. Good B7 = .0312 B8 = 5 Most Likely B7 = .0575 B8 = 5 Bad B7 = .0625 B8 = 3 Create a Scenario Summary Report based on the value in cell B6. Format the new report appropriately and reorder the worksheets so the Scenario Summary worksheet appears as the last worksheet in the workbook. 23 Ensure that the New_Construction worksheet is active. Enter a reference in cell B12 to the 4 beginning loan balance and enter a reference in cell C12 to the payment amount. 24 Use the IPMT function in cell D12 to calculate the interest paid for the first payment of the 4 loan. Use the information in the loan details section (E6:E9) of the worksheet to locate the required inputs for the function. Be sure to use the appropriate absolute, relative, or mixed cell references. All results should be formatted as positive numbers. 25 Enter a formula in cell E12 based on the payment and loan details that calculates the amount 4 of principal paid on the first payment. The principal is the payment - interest. Be sure to use the appropriate absolute, relative, or mixed cell references