EA$7-$A$1$ CREATE A PAYROLL REGISTER FOR ATHLETICS SUPPLY HOUSE PG

In this exercise, you will create a payroll register for Athletics Supply House using ROUND, IF$,$ and WOOKUP functions. You will also modify the worksheet's layout and highlight key elements.

Access the proper file.

Using Project Grader: Download EA$7-$A$1-$Payroll$-$eStart.

Not using Project Grader: Open EA$7-$A$1-$Payroll.

This table shows the needed payroll information:

$\backslash$table$[[$Employee$,$FWT$,$SWT$,$Check #$],[$Thomas$,$ T$,$$$15,$$$10,118],[$Kirkpatrick$,$ I,$$23,$$$16,119],[$Fitzgerald$,$ R$,$$$20,$$$14,120],[$Marshall$,$ N$,$$$9,$$$6,121],[$Abbott$,$ P$,$$$27,$$$9,122]]$

Calculate Earnings, Deductions, and Net Pay