A payroll register has the employees' names in Column A, Social Security numbers in Column B, ...

A payroll register has the employees' names in Column A, Social Security numbers in Column B, hourly wages in Column C, regular hours in Column D, and overtime hours in Column E. If overtime is paid at time-and-a-half, what formula should be entered in Column F for regular pay, Column G for overtime pay, and Column H for gross pay? Use Row 1 in all formulas.

Q. 2

LeMonte earns 239.60 each week. He lives in a state with a state income tax. If LeMonte had 9.59 taken out of his check for state tax last week, what is the state income tax rate to the nearest hundredth percent?

Q. 3

Tracy works from home entering data into the computer. She is paid 2.75 for each page she enters. In the past two weeks she has entered the following number of pages: 135, 187, 110, 213, and 161. What are her gross earnings?

Q. 4

Nigay earns a biweekly salary of 830 plus 11 commission on net sales over 5,000. His total sales in the past two weeks were 16,390 with 2,560 in returned sales. What are Nigay's gross earnings for the two-week period?