This preview shows page 1. Sign up to view the full content.
Unformatted text preview: 21.00 8.99 Directions: a. Enter formulas to calculate Social Security in Column E. b. Enter formulas to calculate Medicare in Column F. c. Use the wage bracket method (weekly) and enter Federal Income Tax withheld in Column G. d. Enter formulas to calculate State Income Tax at 2% of Gross Earnings in Column H. e. Format Columns E through H for Currency. Set Decimal places to 2. Set Currency symbol to None. f. Save the file as ch05qz02a.xls. A B C D E F G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19...
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