10,120 views
10 votes
10 votes
Use Advanced Filtering to restrict the data to only display full-time employees with at least one dependent. Place the results in cell A37. Use the criteria in the range H24:M25 to complete the function.

User Adam Ashwal
by
2.6k points

1 Answer

17 votes
17 votes

Answer:

Click cell H10, and enter an AVERAGEIFS function to determine the average salary of full-time employees with at least one dependent. Format the results in Accounting Number Format. Step 1: Open the excel and go to Insurance worksheet

User Jeff Widman
by
3.1k points