Ch05qz02a - 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

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 05 - Quiz 02 Natalie’s Fish Market Employee Tax Report Marital Status/ Employee Weekly Gross Soc. Sec. Medicare Federal State Income Tax Employee Allowances Soc. Sec. No. Earnings 6.20% 1.45% Income Tax 2% Gomez, Phillipe Married/0 123-45-6655 510.33 31.64 7.40 47.00 10.21 Hamilton, John Single/0 234-45-7700 550.75 34.15 7.99 70.00 11.02 Washington, Latasha Single/1 987-22-4488 399.99 24.80 5.80 37.00 8.00 Williams, Bret Married/2 199-00-3003 449.49 27.87 6.52
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

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.

Ask a homework question - tutors are online