Assume you work for the payroll department and your boss asks you to create a spreadsheet that
will compute the total weekly salary for his employees. Employees are paid on a regular basis if
they work 40 hours or less per week and as follow if they work over-time:
1. If the job status of an employee is Full Time then the employee is paid at an overtime rate of
Example 1: If an employee is Full Time and the regular hourly rate is $10, then the over-time
rate is $20 dollars.
1. If the job status of an employee is Part Time then the employee is paid at an over-time rate
of Time and a half.
Example: If an employee is Part-Time and the regular hourly rate is $10, then the over-time
rate is $15 dollars.
Create a spreadsheet that allows a user to enter the hours worked per day.
The spreadsheet should display and calculate:
1. The Total Hours worked
2. The Total Salary (Regular + Over-Time wages earned if any)
3. Note that changing the value in cell B9, causes the Total Salary to recalculate
You must use the
To calculate the