70.2K

Verified Solution

Link Copied!

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.

H10 AVERAGEIFS(D5:D34,B5:834,"FT", C5:C34,"1" 4 Employee ID Status Dependents Salary Deduction Withholding Statistics $ 90,212 $ 500.00 $ 6,279.84 $18,984 $ 250.00$ 936.70 $ 42,906 500.00 $ 2,968.42 $ 37,191 500.00 $ 2,568.37 $52,528 125.00 3,668.21 $ 17,126 500.00$831.30 $ 94,10150.00 4,702.55 $ 12,471 325.00 $ 607.30 $ 67,132500.00 4,664.24 $88,604 $ 500.00 6,167.28 $ 55,680500.00 3,862.60 $ 98,869 125.00 6,912.08 $11,994 125.00 $ 593.45 $17,957 $ 50.00$ 895.35 $66,693 250.00 $4,651.01 84,432 125.00 $ 5,901.49 $ 18,994 500.00 $ 924.70 $65,648 $ 500.00 4,560.36 $18,835 500.00 $ 916.75 $15,525 500.00 $ 751.25 $15,861 125.00 $ 786.80 $16,173 $ 500.00$783.65 $9,893 125.00 488.40 $ 17,081 500.00$829.05 $39,364 125.00 2,746.73 $19,306 $ 500.00 $ 940.30 $9,93350.00 494.15 $ 16,707 500.00 $ 810.35 $ 13,665 500.00 $ 658.25 $7,68850.00$381.90 Number of FT Employees Average Salary Full Time $67,950.77 7276 FT 9858 8936 FT 6881 FT 3852 FT 6580 PT 4772 FT 4296 PT 8884 FT 9916 FT 5803 FT 8708 FT 5565 PT 6142 PT 8164 FT 4338 FT 5833 PT 6060 FT 2559 PT 5569 PT 3488 PT 7353 PT 4990 PT 4785 PT 3040 FT 8087 PT 4474 PT 4251 PT 5324 PT 3123 PT 13 Additional Information Average Salary of FT1 Dependent 10 65,771.58 Deduction $50.00 $125.00 $ 250.00 $ 325.00 $500.00 Dependents 13 18 FICA Withholding FT at least 1 Dependent PT or FT No De ents 23 24 25 Employee ID Status Dependents Salary Deduction Withholdings FT 27 28 29 30 0 32 35 36 37

Answer & Explanation Solved by verified expert

See Answer