excel-+pay

Calculating Pay Assignment

After you have created your Excel spreadsheet that takes your GROSS PAY (amount before taxes) and calculates your NET PAY (Pay after taxes are taken out) COPY the following questions into Microsoft word, input the data into EXCEL and then answer the questions:


 * 1) What would a person that makes $25,000 a year pay in MONTHLY taxes?
 * 2) What is their NET PAY?
 * 3) What would a person that makes $50,000 a year pay in MONTHLY taxes?
 * 4) What is their NET PAY?
 * 5) What would a person that makes $75,000 a year pay in MONTHLY taxes?
 * 6) What is their NET PAY?
 * 7) What would a person that makes $100,000 a year pay in MONTHLY taxes?
 * 8) What is their NET PAY?
 * 9) Create a BAR or LINE GRAPH showing the amount paid for taxes for $25,000 - $100,000 annual salary. (ONE GRAPH SHOWING MONTHLY taxes paid from each category.....how can you do that??)