Create the worksheet shown below.

$\backslash$table$[[,$A$,$B$,$C$,$D$,$E$,$F$,$G$,$H$],[1,$Ortiz Martine Service Payroll,,,,,,$],[2,$Week Ending,,,,,,,$],[3,$Employee,Hours,$\backslash$table$[[$Pay$],[$Rate$]],\backslash$table$[[$Gross$],[$Pay$]],\backslash$table$[[$Federal$],[$Withholding$]],\backslash$table$[[$State$],[$Withholding$]],\backslash$table$[[$Total$],[$Deductions$]],$Net Pay$],[4,$Bramble,$16,6,,,,,],[5,$Juarez,$25,6\mathrm{.}25,,,,,],[6,$Smith,$30,8,,,,,],[7,$Di Orio,$25,7\mathrm{.}75,,,,,],[8,$Smiken,$10,5\mathrm{.}90,,,,,],[9,$Cortez,$30,7,,,,,],[10,$Fulton,$20,6,,,,,],[11,$Total,,,,,,,$]]$

Use the following formulas in your spreadsheet to calculate total hours, gross pay, federal withholding, state withholding, total deductions and net pay for the company.

a$.$ Gross pay is hours times pay rate. $.$

b$.$ Federal withholding is $15\%$ of gross pay.

c$.$ State withholding is $4\%$ of gross pay.

d$.$ Total deductions is the sum of federal and state withholding.

e$.$ Net pay is the difference between gross pay and total deductions.

f$.$ Total columns $D$ to $H$

Format Row $4$ Columns D $-$ H and Row $11($the total row$)$ as Accounting format with $2$ decimal places.

Cells $C4$:$C10$ and D$5$:H$10$ should be comma style with $2$ decimal places.

Merge and centre the title and subtitle $($Row $1$ and Row $2)$ across the width of the spreadsheet and apply the following formats. Apply a Heading $1$ style to the title of the spreadsheet and a Heading $2$ style to the subtitle. Apply a Total style to the Total row.

Center and Bold row $3.$ Ensure the information fits within the cells, you may need to change the column width of each.

Switch to Landscape orientation. Add a custom footer with your name at the left and Payroll at the right.

Save the spreadsheet as Ortiz Payroll $-$ Student Name.

Submit.