| Problem 11-3A |
| Name: | 0 |
| Section: | # N-box Incorrects due to blanks COUNTIF(B15:AT24," ") |
| 43 |
| Score: | 0% | # N-box +B-box corrects COUNTIF(B15:AT24," ") |
| 0 |
| Key Code: | [Key code here] | Total SUM(AD13:AD15) |
| Instructions | 43 |
| Answers are entered in the cells with gray backgrounds. | Percentage =(AD16-AD13-AD14)/AD16 |
| Cells with non-gray backgrounds are protected and cannot be edited. | 0% |
| An asterisk (*) will appear to the right of an incorrect entry. | Notes: |
| If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " " |
| If number-entry or blank-entry box is incorrect, returns "*" |
| 1. | If number-entry or blank-entry box is correct, returns single space, " " |
| Amounts to Be Reported on Wage and Tax Statements (Form W-2) | Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as correct. |
| Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color. |
| Gross | Federal Income | Social Security | Medicare |
| Employee | Earnings | Tax Withheld | Tax Withheld | Tax Withheld |
| Arnett | | | | |
| Cruz | | | | |
| Edwards | | | | |
| Harvin | | | | |
| Nicks | | | | |
| Shiancoe | | | | |
| Ward | | | | |
| Totals | | |
| 2. |
| Employer Payroll Taxes |
| a. | Social security tax paid by employer | |
| b. | Medicare tax paid by employer | |
| c. and d. |
| SUTA/FUTA |
| Employee | Earnings |
| Arnett | |
| Cruz | |
| Edwards | |
| Harvin | |
| Nicks | |
| Shiancoe | | State unemployment compensation tax | |
| Ward | |
| Total | | Federal unemployment compensation tax | |
| e. | Total employer payroll taxes | |
combs
WRD27e_PR11-3A.xlsx
