Excel+-+Payroll

Saxton Publishing Payroll
 * 1) Everyone has been hired at Saxton Publishing. Now who should be the accountant?
 * 2) Prepare the following spreadsheet.
 * 3) Fill in the Gross Pay column by using a formula which multiplies the Hours Worked times the Hourly Wage.
 * 4) Fill in the Taxes column by using a formula which calculates 30% of the Gross Pay.
 * 5) Fill in the Net Pay column with a formula which subtracts the Taxes from the Gross Pay.
 * 6) Using the built in function 'sum', calculate the totals of the last three columns.
 * 7) Format the hour’s column to 1 decimal place and all other numbers to currency with 2 decimal places.
 * 8) Sort the employees into alphabetical order. **Don't alphabetize it yourself**, let the computer do it. Look at MENU bar and go to DATA. Can you find and use the SORT button?
 * 9) BONUS: Format the table with a border, shading, include a computer graphic.
 * 10) GRAPH just the name and Net Pay
 * 11) Add your name using a header and the date.
 * 12) Save to your user U: Name it: **last name_class salaries**
 * **Name** || **Hours** || **Wage** ||
 * Vaniel, Maverick || 36 || 14.5 ||
 * Drury, Khorter || 40 || 17.8 ||
 * Hay, Jacob || 38 || 18 ||
 * Miller, Mekenna || 25 || 15.8 ||
 * Bell, Shelby || 32 || 17.25 ||
 * Mills, Lucas || 29 || 19.5 ||
 * Sigurdsson, Bjorn || 35 || 21.21 ||
 * Fryer, Dillon || 37 || 20.5 ||
 * Queer, Hannah || 38 || 19.25 ||
 * Boring, Hope || 30 || 18.75 ||
 * Mundorff, Angel || 40 || 22 ||
 * Button, Megan || 37 || 21.50 ||
 * Smith, Shelby || 35 || 17.70 ||