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