Extend Your EAT-E1 Complete a Payroll Register for Ashley's Auto Sales complete a palgister for Ashley's Auto Sales You will use the this chapter to enter earning, deduction, and net pay date. You will also register to ensure optimal layout and formatting EAT-E1-Payroll Use an IF function to populate the Overtime Earnings and Total com Eure that N/A is displayed in the Overtime Earnings column for who did not work overtime hours during the period. Populate the FWT and SWT sing these figures $16 $12 683 $33 685 $16 686 FWT Employee Name SWT Check Number $24 682 Campbell 518 512 58 684 Williams. N $22 McCann $10 Create a nested IF function to calculate Social Security tax and a separate formula to calculate Medicare tax for each employee. Use absolute formatting as appropriate Use the appropriate LOOKUP function to calculate the charitable contributions and medical plan payment amounts for each employee. Note that the percentages in the range C25:D29 represent the percent of total earnings contributed to the respective voluntary withholdings. Use these in your LOOKUP function. Complete the payroll register by entering the check numbers and creating a formula to calculate each employee's net pay. Adjust the worksheet layout by adding borders around distinct sets of data, adjusting column widths and/or row heights between sets of data, and minimizing blank sets. Last, use appropriate formatting to distinguish the headers in rows 6-8 from the data space between data below and conditional formatting to highlight the two largest Net Pay amounts Extend Your EAT-E1 Complete a Payroll Register for Ashley's Auto Sales complete a palgister for Ashley's Auto Sales You will use the this chapter to enter earning, deduction, and net pay date. You will also register to ensure optimal layout and formatting EAT-E1-Payroll Use an IF function to populate the Overtime Earnings and Total com Eure that N/A is displayed in the Overtime Earnings column for who did not work overtime hours during the period. Populate the FWT and SWT sing these figures $16 $12 683 $33 685 $16 686 FWT Employee Name SWT Check Number $24 682 Campbell 518 512 58 684 Williams. N $22 McCann $10 Create a nested IF function to calculate Social Security tax and a separate formula to calculate Medicare tax for each employee. Use absolute formatting as appropriate Use the appropriate LOOKUP function to calculate the charitable contributions and medical plan payment amounts for each employee. Note that the percentages in the range C25:D29 represent the percent of total earnings contributed to the respective voluntary withholdings. Use these in your LOOKUP function. Complete the payroll register by entering the check numbers and creating a formula to calculate each employee's net pay. Adjust the worksheet layout by adding borders around distinct sets of data, adjusting column widths and/or row heights between sets of data, and minimizing blank sets. Last, use appropriate formatting to distinguish the headers in rows 6-8 from the data space between data below and conditional formatting to highlight the two largest Net Pay amounts