1. Insert 2 columns in the table above. label it with no. of years service and Status accordingly. Input Sample data to the columns added. ( 5 pts)
2. Create a formula that will determine the award of the retired list of employee; such that: (15 pts)
Gold Award if the employee years of service is 50 and the status is regular.
Silver Award if the employee's years of service reach to 30 and the status is regular.
Bronze Award if the employee's years of service reach to 15 and the status is regular.
otherwise; empty cell will be display.
3. Count the number of cell that contains “Juan” from A2 to F7. (10 pts)
4. Write a formula that will determine the maximum value in retirement PAY column. (10 pts)
5. Write a formula that will determine the minimum value in salary and retirement column. (10 pts)
Total points=50
0 Comments