please help by typing out steps to solve

10 Enter a conditional statistical function in cell K16 that calculates the average value of PT employee salaries Use the range E6 E25 to complete the function 2 11 Enter a conditional statistical function in cell K17 that calculates the highest PT employee salary Use the range E6 E25 to complete the function 1.6 12 Apply Currency Number Format to the range K15.K17 2 13 Click cell K11 and type FT. Click cell A28 and type Full Time Employees N 14 Use the Format Painter to apply the formatting from the cell A3 to the range A28:828 NI 15 Use Advanced Filtering to restrict the data to only display FT employees based on the criteria in the range K10 K11 Place the results in cell A29 3 16 2 Enter a database function in cell K18 to determine the total number of FT employees. To complete the function use the range A5.H25 as the database argument, cell ES for the field, and the range K10:K11 for the criteria 17 2 Enter a database function in cell K19 to determine the total value of FT employee salaries. To complete the function use the range AS:H25 as the database argument cell H5 for the field, and the range K10 K11 for the criteria 18 3 Enter a database function in cell K20 to determine the average FT employee salary. To complete the function use the range A5 H25 as the database argument, cell Hs for the field, and the range K10:K11 for the criteria 19 Enter a database function in cell K21 to ine the highest FTsalary. 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 2 3 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 7.4 22 Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7, B8 and E6 Good B7 = .0312 BS = 5 KI D G H 1 K M Tech Store Unlimited Employee Information 401K Cut OH 1/1/2019 Employee Lookup Employee ID IN Dependents #N/A Employee Lookup Filter Employee ID Type Dependents Salary Employee ID Start Date First Name Last Name Type Dependents 401k Eligible Salary 31461 2/1/2017 Nelson Gail FI $125,000.00 56768 8/19/2020 Lopez Vivian FT 4N $100,000.00 31428 1/8/2017 Ramsey Matthew FT ON $110,000.00 46274 2/2/2017 Stevenson Beverly FT 3 N $ 85,000.00 10 30261 4/29/2020 Smith Peter FT OY $ 95,000.00 31 43482 1/21/2019 Kelley Emily PT 2 N $ 18,864.00 38096 5/1/2021 Carroll Phyllis PT 3 N $ 23,722.00 65010 1/28/2018 Hunt Barbara PT ON $ 14,966.00 14 98674 12/29/2018 Austin Melanie PT 4 N $ 18,751.00 15 98065 10/14/2020 Snyder Jean PT 1N $ 18,875.00 16 3007 6/4/2020 Morris Susanne PT 3 N $ 11,513.00 17 79886 6/15/2018 Gibson Geraldine PT ON $ 20,044.00 18 64401 11/3/2021 Graham Vicki PT 3 N $ 10,354.00 19 72922 12/15/2021 Watson Marilyn PT 4N $ 11,049.00 20 90871 5/30/2019 Simpson Troy PT 3 N $ 24,010.00 21 39948 1/14/2020 Barber Aaron PT AN $ 11,156.00 22 40725 12/7/2020 Morales Brittany PT 3 N $ 23,142.00 23 42988 1/31/2019 Blair Cynthia PT 3 N $ 12,105.00 24 40499 4/13/2018 Jennings Dolores PT ON $ 24,905.00 25 28253 4/29/2018 Carroll Howard PT 3 N $ 10,663.00 26 27 Employee_Info New Construction Code Employee Statistics # PT 15 Total PT Salaries Average PT Salary $ 16,941.27 Highest PT Salary #FT Total FT Salaries Average FT Salary Highest FT Salary 10 Enter a conditional statistical function in cell K16 that calculates the average value of PT employee salaries Use the range E6 E25 to complete the function 2 11 Enter a conditional statistical function in cell K17 that calculates the highest PT employee salary Use the range E6 E25 to complete the function 1.6 12 Apply Currency Number Format to the range K15.K17 2 13 Click cell K11 and type FT. Click cell A28 and type Full Time Employees N 14 Use the Format Painter to apply the formatting from the cell A3 to the range A28:828 NI 15 Use Advanced Filtering to restrict the data to only display FT employees based on the criteria in the range K10 K11 Place the results in cell A29 3 16 2 Enter a database function in cell K18 to determine the total number of FT employees. To complete the function use the range A5.H25 as the database argument, cell ES for the field, and the range K10:K11 for the criteria 17 2 Enter a database function in cell K19 to determine the total value of FT employee salaries. To complete the function use the range AS:H25 as the database argument cell H5 for the field, and the range K10 K11 for the criteria 18 3 Enter a database function in cell K20 to determine the average FT employee salary. To complete the function use the range A5 H25 as the database argument, cell Hs for the field, and the range K10:K11 for the criteria 19 Enter a database function in cell K21 to ine the highest FTsalary. 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 2 3 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 7.4 22 Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7, B8 and E6 Good B7 = .0312 BS = 5 KI D G H 1 K M Tech Store Unlimited Employee Information 401K Cut OH 1/1/2019 Employee Lookup Employee ID IN Dependents #N/A Employee Lookup Filter Employee ID Type Dependents Salary Employee ID Start Date First Name Last Name Type Dependents 401k Eligible Salary 31461 2/1/2017 Nelson Gail FI $125,000.00 56768 8/19/2020 Lopez Vivian FT 4N $100,000.00 31428 1/8/2017 Ramsey Matthew FT ON $110,000.00 46274 2/2/2017 Stevenson Beverly FT 3 N $ 85,000.00 10 30261 4/29/2020 Smith Peter FT OY $ 95,000.00 31 43482 1/21/2019 Kelley Emily PT 2 N $ 18,864.00 38096 5/1/2021 Carroll Phyllis PT 3 N $ 23,722.00 65010 1/28/2018 Hunt Barbara PT ON $ 14,966.00 14 98674 12/29/2018 Austin Melanie PT 4 N $ 18,751.00 15 98065 10/14/2020 Snyder Jean PT 1N $ 18,875.00 16 3007 6/4/2020 Morris Susanne PT 3 N $ 11,513.00 17 79886 6/15/2018 Gibson Geraldine PT ON $ 20,044.00 18 64401 11/3/2021 Graham Vicki PT 3 N $ 10,354.00 19 72922 12/15/2021 Watson Marilyn PT 4N $ 11,049.00 20 90871 5/30/2019 Simpson Troy PT 3 N $ 24,010.00 21 39948 1/14/2020 Barber Aaron PT AN $ 11,156.00 22 40725 12/7/2020 Morales Brittany PT 3 N $ 23,142.00 23 42988 1/31/2019 Blair Cynthia PT 3 N $ 12,105.00 24 40499 4/13/2018 Jennings Dolores PT ON $ 24,905.00 25 28253 4/29/2018 Carroll Howard PT 3 N $ 10,663.00 26 27 Employee_Info New Construction Code Employee Statistics # PT 15 Total PT Salaries Average PT Salary $ 16,941.27 Highest PT Salary #FT Total FT Salaries Average FT Salary Highest FT Salary