1. Write the formula that will calculate the commission of each employee (e.i 10 % of sales) 10 pts
2. Count the number of cell that contains “Hong” from A2 to F7. (10 pts)
3. Create a formula for remarks that will determine the awards of every employee:
Rookie Award if the the sales is greater than 75 000 000 and the number of years service is 1 year.
Sales Representative Award if the sales is greater than 100 000 000 and the number of years service is greater than 1
None of the above qualification will win a Gift Certificate.( 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)
0 Comments