Unformatted text preview: e. Enter formulas in Column I to calculate Social Security. f. Enter formulas in Column J to calculate Medicare. g. Enter $12.50 per week in Column K for Medical Insurance for each person. h. Enter formulas in Column L to calculate Total Deductions. i. Enter formulas in Column M to calculate Net Pay. Format all answers to Currency. Set Decimal places to 2. Set Currency symbol to None. Gross Earnings Federal Income Tax Social Security Medical Insurance Total Deducted Net Pay j. Save the file as ch05qz01a.xls. A B C D E F G H I J K L M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23...
View Full Document
This note was uploaded on 02/19/2012 for the course BUS bus 130 taught by Professor Munoz during the Winter '10 term at Everett CC.
- Winter '10