Assignment #$1$

Scenario: You have just landed a job at Acme Hat Corporation. Your manager has asked you to develop a spreadsheet for all the temporary employees that need to be compensated on the next payroll schedule. Using the figure below, create the spreadsheet and complete the following tasks. Please refer to the 'Getting to Know Excel'notes.

Acme Hat Corporation

Prepare the following spreadsheet.

Fill in the Gross Pay column by using a formula which multiplies the Hours Worked times the Hourly Wage.

Fill in the Taxes column by using a formula which calculates $35\%$ of the Gross Pay.

Fill in the Net Pay column with a formula which subtracts the Taxes from the Gross Pay.

Using the built in function 'sum', calculate the totals of the last three columns.

Format the hours column to $1$ decimal place and all other numbers to currency with $2$ decimal places.

Sort the employees into alphabetical order.$($Hint: Use the 'Data' Tab$)$

Format the table with a border, title shading, graphic of a hat, centered horizontally and vertically.

Add your name using a header and the date and time as a footer to the spreadsheet, save and submit your spreadsheet.

In a new tab on the spreadsheet, named Executives, add five additional employees: Include hours, wages, and all calculations.

Center all column hearings and freeze panes

When submitting the tssignment, use the Show Formulas so that the formulas used are displayed

$\backslash$table$[[$Acme Hat Corporation$],[$Name$,$Hours,Wage,Gross,Taxes,Net,$],[$Lachance$,40\mathrm{.}5,15\mathrm{.}75,,,,],[$Warner$,39\mathrm{.}5,35\mathrm{.}5,,,,],[$McKaig$,27\mathrm{.}75,29\mathrm{.}85,,,,],[$Shaw$,38,32,,,,],[$Brooksbank$,29,31,,,,],[$Darach$,15,18\mathrm{.}54,,,,],[$Buspers$,14\mathrm{.}75,15\mathrm{.}75,,,,],[,,$Totals:,,,,$]]$