excell refiatery
4-10A
4-8A
4-5A
Excel Instructions
OASDI
HI
FICA
FIT
SIT
( c )
( a )
( b )
CIT
( d )
( e )
DEDUCTIONS
PAYROLL REGISTER
M
S
EMPLOYEE NAME
MARITAL STATUS
NO. OF W/H ALLOW.
TOTAL
EARNINGS
NET
PAY
Totals
HI Taxes
HI taxable earnings
HI taxes
OASDI taxable earnings
OASDI taxes
COX SECURITY SYSTEMS
REGULAR
SUPP’L.
( a)
(M)
(M) indicates monthly pay.
HOGAN THRIFT SHOP
Name:
4-5A
4-8A
John, Matthew
Bullen, Catherine
Matthews, Mary
Hadt, Bonnie
Camp, Sean
Wilson, Helen
Gleason, Jose
Smith, Jennifer
Hall, Michael
Short, Joy T.
Abbott, Linda
Smith, Joseph
Gillespie, Michelle
Smart, Jennifer
Tols, Sean M.
White, Matthew J.
Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear
to the right of an incorrect answer.
HI Taxes
OASDI Taxes
FOR PERIOD ENDING
HI taxable earnings
HI taxes
OASDI Taxes
December 21, 20 – –
Compute the employer’s FICA taxes for the pay period ending December 21.
1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer.
2. A formula begins with an equals sign (=) and can consist of any of the following elements:
Operators such as + (for addition), – (for subtraction), * (for multiplication), and / (for division).
Cell references, including cell addresses such as B52, as well as named cells and ranges
Values and text
Worksheet functions (such as SUM)
3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells.
To enter a formula manually, follow these steps:
Move the cell pointer to the cell that you want to hold the formula.
Type an equals sign (=) to signal the fact that the cell contains a formula.
Type the formula, then press Enter.
You can save the file to the current name, or you may want to keep multiple versions of your work by saving each…





