7th+Grade+Spreadsheet+Final

Saxton Publishing Company - Payroll __**Saxton Publishing Company **__
 * 1) Prepare the following spreadsheet.
 * 2) Fill in the Gross Pay column by using a formula which multiplies the Hours Worked times the Hourly Wage.
 * 3) Fill in the Taxes column by using a formula which calculates 30% of the Gross Pay.
 * 4) Fill in the Net Pay column with a formula which subtracts the Taxes from the Gross Pay.
 * 5) Using the built in function 'sum', calculate the totals of the last three columns.
 * 6) Format the hour’s column to 1 decimal place and all other numbers to currency with 2 decimal places.
 * 7) Sort the employees into alphabetical order. Easy, 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?
 * 8) Format the table with a border, shading and a computer logo at the top.
 * 9) **GRAPH just the name and Net Pay. **
 * 10) Add your name using a header and the date.
 * 11) Save to your user u: drive. THEN UPLOAD it to GOOGLE DRIVE and share it with Mrs. Saxton


 * **Name ** || **Hours ** || **Wage ** || **Gross ** || **Taxes ** || **<span style="font-family: 'Times New Roman',serif; font-size: 10pt;">Net ** ||
 * <span style="font-family: 'Times New Roman',serif; font-size: 16px; text-align: center;">Grimm, Mason || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">40.5 || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">15.75 ||  ||   ||   ||
 * <span style="font-family: 'Times New Roman',serif; font-size: 16px; text-align: center;">Puckett, Ella || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">12 || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">13.60 ||  ||   ||   ||
 * <span style="font-family: 'Times New Roman',serif; font-size: 12pt;">Hoffman, Tatum || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">27.75 || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">15.85 ||  ||   ||   ||
 * <span style="font-family: 'Times New Roman',serif; font-size: 16px;">Peterman, McKenna || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">38 || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">15.60 ||  ||   ||   ||
 * <span style="font-family: 'Times New Roman',serif; font-size: 12pt;">Piper, Gabie || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">29 || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">17.25 ||  ||   ||   ||
 * <span style="font-family: 'Times New Roman',serif; font-size: 16px; text-align: center;">Deemer, Ethen || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">15 || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">18.54 ||  ||   ||   ||
 * <span style="font-family: 'Times New Roman',serif; font-size: 12pt;">Hartman, Gavin || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">14.75 || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">15.75 ||  ||   ||   ||
 * <span style="font-family: 'Times New Roman',serif; font-size: 16px;">Linebarger, Desiree || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">21.4 || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">16.45 ||  ||   ||   ||
 * <span style="font-family: 'Times New Roman',serif; font-size: 12pt;">Fichet, Mollie || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">23.5 || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">13.80 ||  ||   ||   ||
 * <span style="font-family: 'Times New Roman',serif; font-size: 12pt;">Blotzer, Becka || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">15.6 || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">16.40 ||  ||   ||   ||
 * <span style="font-family: 'Times New Roman',serif; font-size: 16px; text-align: center;">Fox, Derek || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">18.7 || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">24.40 ||  ||   ||   ||
 * <span style="font-family: 'Times New Roman',serif; font-size: 12pt;">Hobaugh, Nathan || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">40.0 || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">21.25 ||  ||   ||   ||
 * <span style="font-family: 'Times New Roman',serif; font-size: 16px; text-align: center;">Mack, Bryton || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">39.5 || <span style="font-family: 'Times New Roman',serif; font-size: 10pt; text-align: right;">22.5 ||  ||   ||   ||
 * ||  || **<span style="background-color: #ffffff; font-family: 'Times New Roman',serif; font-size: 13.3333px; text-align: right;">Totals: ** ||   ||   ||   ||
 * ||  || **<span style="background-color: #ffffff; font-family: 'Times New Roman',serif; font-size: 13.3333px; text-align: right;">Totals: ** ||   ||   ||   ||