You will complete a payroll register for Upholstery Designers. $($File attached$).$ You will use the techniques from this chapter to enter earnings, deductions, and net pay data. You will also modify the payroll register to ensure optimal layout and formatting.

Use an IF function to populate the Overtime Earnings and Total Earnings columns. Ensure that N$/$A is displayed in the Overtime Earnings column for employees who did not work overtime hours during the period. Populate the FWT and SWT columns using these figures:

$\backslash$table$[[$Employee Name,FWT$,$SWT$,$Check Number$],[$Forbath$,$ B$,$$$11,$$$8,43],[$Carpenter$,$ I,$$28,$$$18,44],[$Quinn$,$ L$,$$$15,$$$10,45],[$Chang$,$ H$,$$$16,$$$10,46],[$Carter$,$ M$,$$$20,$$$14,47]]$

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 provided in the range C$25$:D$29$ 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, creating a formula to calculate each employee's net pay, and creating formulas to total columns where necessary.

Adjust the worksheet layout by adding borders used around distinct sets of data, adjusting column widths and$/$or row heights between sets of data, and minimizing blank space between data sets. Last, use appropriate formatting to distinguish the headers in rows $6-8$ from the data below and conditional formatting to highlight the two largest Net Pay amounts.