Term 3- Excell
My class did three projects this term: Teen Payroll spreadsheet, Formula Functions speadsheeet Problem #22, and Raises spreadsheet Activity #48.Teen pay roll taugh me how to use formulas to calculate gross and net pay, Formula functions taugh me how to creat a grade book to calculate student grades, and raises spreadsheet to use function to calculate employee pay raises.
Teen Payroll spreadsheet
For Teen payroll, I used formulas to calculate the pay for net and gross and that formula was =SUM(F13:F32). I basically used this formula for most of my excel spreadsheets.
Formula Functions Spreadsheet
For this spread sheet, I created a list of names like a grade book would have and I calculated the row with the grades and recorded who had the higest and lowest grade.
Raises spreadsheet Activity #48
In the spread sheet raises, you had to use the IF function to calculate employee pay raises. It calculated how much the emplyee made.