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