Question:

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.

Search Results Category Quantity Results 8 Status FLAG 4 5 Trans # 30038C 6 7 Date Trans # 8 3/1/2018 30038C 9 3/2/2018 50054F 10 3/3/2018 50051C 11 3/3/2018 500510F 12 3/5/2018 10016C 13 3/7/2018 50055C 14 3/9/2018 10015C 15 3/10/2018 50053C 16 3/10/2018 20021F 17 3/10/2018 40044F 18 3/11/2018 20029F 19 3/11/2018 30038C 20 3/12/2018 10019F 21 3/13/2018 20028F 22 3/13/2018 20029C 23 3/14/2018 30039C 24 3/18/2018 30031C 25 3/24/2018 40041C Item 3003 5005 5005 5005 1001 5005 1001 5005 2002 4004 2002 3003 1001 2002 2002 3003 3003 4004 Quantity Payment Type 8 Credit 4 Financed 1 Credit 10 Financed 6 Credit 5 Credit 5 Credit 3 Credit 1 Financed 4 Financed 9 Financed 8 Credit 9 Financed 8 Financed 9 Credit 9 Credit 1 Credit 1 Credit Amount $4,800 $2,800 $700 $7,000 $1,500 $3,500 $1,250 $2,100 $500 $2,600 $4,500 $4,800 $2,250 $4,000 $4,500 $5,400 $600 $650 FLAG 00 FLAG FLAG