I need help with the OVERTIME SECTION -- I need the Hours Worked, Rate Per Hour, Amount, Total Earnings Column... FICA SECTION - OASDI, HI, FIT, SIT Column and I have to have the excel formula to be able to put it into excel.

instructions

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.

4. Rounding:These templates have been formatted to round numbers to either the nearest whole number or the nearest cent.For example,

17.65 x 1.5=26.475. The template will display and hold 26.48, not 26.475. There is no need to use Excel's rounding function.

EXCEPTION: Continuing Payroll Problems A & B: CHAPTER 2

When calculating over-time rate for weekly salary, round regular rate to TWO decimals BEFORE calculating overtime rate.

Rounding can be accomplished by using Number function (using arrows) on Excel Home menu or by entering the formula

=(Round(Weekly/40,2))*1.5 (where "Weekly" entered as either the weekly pay or cell reference.)

Failure to use the ROUND function will cause the OT rate to be incorrect.

C D Name: Cautions See "round" rules in Excel Instructions before calculating OT for employees. inter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (") will appear to the right of an incorrect answer, Continuing Payroll Problem-A KIPLEY COMPANY, INC. PAYROLL REGISTER FOR PERIOD ENDING January 8, 20 - REGULAR EARNINGS OVERTIME EARNINGS NO. OF VH RATE RATE STATUS WORKE ALLOW. PER WORKE PER TOTAL FICA EMPLOYEE HOUR AMOUNT HOUR AMOUNT EARNINGS DASDI HI FIT SIT 11 Carson, Fran M. S 40 $17.50 700.00 12 Wilson, William A. 5 0 40 $17.25 690.00 13 Utley, Harry T. 2 37.5 $18.10 678.75 21 Fife, Lawrence R. 40 $17.90 716.00 22 Smith, Lucy K. S 2 40 $19.75 790.00 31 Fay, Gretchen R. M 3 40 515.00 32 Robey, Glenda B. 6 40 623.08 33 Schork, Thomas K. S 40 773.08 51 Hardy, Barbara T. 5 40 579.23 99 Kipley, Carson C. M 40 1,000.00 Totals 7,065.14" Continuing Problem-A iter Type here to search 99+ VOC D Name: Cautions See "round" rules in Excel Instructions before calculating OT for employees. inter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (") will appear to the right of an incorrect answer, Continuing Payroll Problem-A KIPLEY COMPANY, INC. PAYROLL REGISTER FOR PERIOD ENDING January 8, 20 - REGULAR EARNINGS OVERTIME EARNINGS NO. OF VH RATE RATE STATUS WORKE ALLOW. PER WORKE PER TOTAL FICA EMPLOYEE HOUR AMOUNT HOUR AMOUNT EARNINGS DASDI HI FIT SIT 11 Carson, Fran M. S 40 $17.50 700.00 12 Wilson, William A. 5 0 40 $17.25 690.00 13 Utley, Harry T. 2 37.5 $18.10 678.75 21 Fife, Lawrence R. 40 $17.90 716.00 22 Smith, Lucy K. S 2 40 $19.75 790.00 31 Fay, Gretchen R. M 3 40 515.00 32 Robey, Glenda B. 6 40 623.08 33 Schork, Thomas K. S 40 773.08 51 Hardy, Barbara T. 5 40 579.23 99 Kipley, Carson C. M 40 1,000.00 Totals 7,065.14" Continuing Problem-A iter Type here to search 99+ VO