Spreadsheet1(1)

Spreadsheet1(1) - A 1 2 3 4 B C D E F G H I J K L M...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: A 1 2 3 4 B C D E F G H I J K L M 12/28/2011 Month January February March April May June July August Column Totals 5 6 7 8 9 10 11 12 13 14 15 Mortgage rate 0.18 16 17 18 19 20 21 22 23 24 25 26 27 28 29 CS170 - FALL 2006 Salary 62000 31000 58500 13500 123400 180000 73000 43000 584400 Commission Overtime 9300 3200 4650 3200 8775 3200 2025 3200 18510 3200 27000 3200 10950 3200 6450 3200 87660 25600 Mortgage Payment 13410 6993 12685.5 3370.5 26119.8 37836 15687 9477 125578.8 Pension Total Deductions Fund 16300 29710 8550 15543 15425 28110.5 4175 7545.5 31650 57769.8 45800 83636 19050 34737 11550 21027 152500 278078.8 Total Pay 65200 34200 61700 16700 126600 183200 76200 46200 610000 CLASS NOTES Mortgage Payment = Mortgage rate * (salary+commission+overtime) pension fund = rate*(salary+ commission) Total Deductions = mortgage payment + pension fund Total Payment = salary + overtime use the $ to keep information constant for auto fill…example: to keep A16 constant, write $A$16. Spreadsheet Assignment 1 1 RATE 0.25 Keith Spano Section 02 12/28/2011 Month January February March April May June July August Column Totals Salary 62000 31000 58500 13500 123400 180000 73000 43000 584400 Commission Overtime 9300 3200 4650 3200 8775 3200 2025 3200 18510 3200 27000 3200 10950 3200 6450 3200 87660 25600 Mortgage Payment 13410 6993 12685.5 3370.5 26119.8 37836 15687 9477 125578.8 Pension Fund 16300 8550 15425 4175 31650 45800 19050 11550 152500 Total Deductions 29710 15543 28110.5 7545.5 57769.8 83636 34737 21027 278078.8 Total Pay 65200 34200 61700 16700 126600 183200 76200 46200 610000 Mortgage rate 0.18 CLASS NOTES Mortgage Payment = Mortgage rate * (salary+commission+overtime) pension fund = rate*(salary+ commission) Total Deductions = mortgage payment + pension fund Total Payment = salary + overtime use the $ to keep information constant for auto fill…example: to keep A16 constant, write $A$16. For header go to Insert--> header footer ...
View Full Document

This note was uploaded on 12/28/2011 for the course 198 170 taught by Professor Kristianstout during the Spring '10 term at Rutgers.

Page1 / 3

Spreadsheet1(1) - A 1 2 3 4 B C D E F G H I J K L M...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online