This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: • Keep 2 blank rows • Create the following column labels: Pay Period #, Hours Worked, Pay Rate, Gross Pay, Taxes, Net Pay o Make the font bold for these labels • Create the following formulas: o Gross Pay: = Hours Worked x Pay Rate o Taxes: = Gross Pay x Tax Rate o Net Pay: = Gross Pay – Taxes • Autosize the first 6 columns Use input boxes to obtain the necessary data • Have users provide data for the following fields: Last, First, Title, Pay Period, Hours Worked, Pay Rate • Update the worksheet name so that it reflects the current employee’s name • Provide the user a message that the program ran correctly Update taxes based on a condition • Use an If-Then construct to determine the appropriate tax rate • Use a Case construct to determine the appropriate tax rate...
View Full Document
- Fall '08
- appropriate tax rate, pay rate, following column labels