Teen Payroll
This Excel Spreadsheet used formulas to calculate gross and net pay, showing how to effectively use and differentiate the times when gross pay and net pay, would be used, and how they would be used. Also reminding us to use the fill option to draw attention to those particular cells.
p5perruzzis11212teenusapayroll.xlsx | |
File Size: | 14 kb |
File Type: | xlsx |
Formula Functions
In this activity we used Excel's formulas to calculate a mock classes grades. We used new fuctions, AVERAGE and COUNT. Which, compared to having either averaged by hand or through a longer process with excel had saved me alot of time. COUNT also saved me the trouble of having to count up all the data, both of these I wished I had before as it would have helped me with large math problems.
p5perruzzis31212formulafeatures.xlsx | |
File Size: | 10 kb |
File Type: | xlsx |
Raises
This activity includes the usage of IF functions to calculate employee raises, and I have to say it was the one function I truly love in Excel. It also introduced me to simple logical computations which I would be interested in learning more about. Unfortunately I don't see what I could use it for now, as a highschool student as it seems to be used for problems I would encounter professionally.
p5perruzzis41012raise.xlsx | |
File Size: | 14 kb |
File Type: | xlsx |