1. Create the following spreadsheet 'Payroll' below. Add a new column Net Pay and calculate the net pay for each student. At bottom calculate Average, MAX, MIN (do not use these three items for...

Extracted text: 1. Create the following spreadsheet 'Payroll' below. Add a new column Net Pay and calculate the net pay for each student. At bottom calculate Average, MAX, MIN (do not use these three items for graph). PAYROLL FOR THE WEEK ENDING JUNE 30 ID ΕMPLOYEΕ NAME HOURLY RATE HOURS WORKED NUMBER 110 FORD 7.89 37.00 111 MINO 8.00 50.00 112 BELL 7.50 34.50 113 AARON $ 9.00 47.50 114 DAVIS 11.00 36.00 115 TURRO $ 10.50 45.00 2. Use the data on the payroll spreadsheet to create a column graph that shows the net pay for all employees. (Include employee names). 3. Insert the column chart onto your spreadsheet under your data. %24 %24 %24 %24