Solve 1 to 6 please thank you

1. On Insurance worksheet, Click cell I5 and enter a function that determines the number of full-time employees, (FT).
2. Enter a function in cell I6 that determines the average salary of all full-time employees. Format the results in Accounting Number Format.
3. Enter a lookup function in cell E5 that returns the tax deduction amount for the number of dependents listed in the cell C5. Use the table in range H13:I17 to complete the function. The maximum deduction is $500.00; therefore, employees with more than four dependents will receive no additional deductions.
4. Use Flash Fill to copy the function down, completing column E. Be sure to use the appropriate cell referencing. Format the data in column E with the Accounting Number Format. Save the workbook
5. Enter a logical function in cell F5 that calculates employee FICA withholding. If the employee is full-time and has at least one dependent, then he or she pays 7% of the annual salary minus any deductions. All other employees pay 5% of the annual salary minus any deductions. Copy the function down through column F. Format the data in column F with Accounting Number Format.
6. Apply conditional formatting to the range C4:C34 that highlights any dependents that are greater than 3 with Red.

Power Pivot Tell me what you want to do Calibri 11A A Genera Copy Format Painter Blu- ! Merge & Center $ . % , conditio Formattin Clipboard Font Alignment Number H19 X-/ f. || FICA withholdings Beta Manufacturing Employee Withholdings 4 Employee ID Status Dependents Salary Deduction Withholding Statistics $90,212 2 S 18,984 $ 42,906 5 s 37,191 1 S 52,528 S17,126 0 94,101 3 12,471 $ 67,132 $ 88,604 S 55,630 $ 98,869 S 11,994 0 17,957 S66,693 $84,432 S 18,994 65 648 Number of FT Employees Average Salary Full Time 7276 FT 9858 PT 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 Additional Information Average Salary of FT>1 Dependent 10 Dependents 12 13 14 15 16 Deduction S 50.00 $ 125.00 250.00 s325.00 500.00 18 FICA Withholdings FT at least 1 Dependent PT or FT No Dependents 5% 5833 PT 6060 FT 22. Insurance Facilities Sales Inventory