Question: 12. In T14: Use the appropriate function to answer the question: If the Department is 4302 , enter 1000, if the Department is 4308 ,

12. In T14: Use the appropriate function to answer the question:

If the Department is 4302, enter 1000, if the Department is 4308, enter 800, if the Department is 4312, enter 600, otherwise enter 400. Copy the function down for the employees.

In T10: Use the appropriate function to calculate the Total Department Bonus. Format as comma style, 0 decimals

13. In U14: Based on the Days Absent use the VLOOKUP function, along with the VLOOKUP table, to enter the bonus for the employee. Copy the function down for the other employees.

In U10: Use the appropriate function to calculate the Total Days Absent Bonus. Format as comma style, 0 decimals

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

12. In T14: Use the appropriate function to answer the question: If the Department is 4302 , enter 1000, if the Department is 4308 , enter 800, if the Department is 4312 , enter 600, otherwise enter...

If the Department is 4302, enter 1000, if the Department is 4308, enter 800, if the Department is 4312, enter 600, otherwise enter 400. Copy the function down for the employees. In T10: Use the...

1 . Name cell C 7 as Rejection _ Rate. 2 . In M 1 4 : Create a formula to calculate the Units Rejected ( multiply Units Made by the Rejection Rate in C 7 ) . Copy the function down for the employees....

In W10: Use the appropriate function to calculate the average Salary for female employees from Department 5894 who have an E rating? In X10: Calculate how many employees have a Salary of Less than...

everything is clear and complete information provided 29 MUR BE 15 PUBEE MC Monty duty ADING O Po hop 11 PLOTEE OBCODE TIE DEPARTMENT LAST NAME CITY FIRST NAME PROV RATING EDUCATION BILINGUAL POSTAL...

1 Name cell C7 as Rejection_Rate . Check the TRUE box once this has been done. 2 In M14 :use formula to calculate the Units Rejected (multiply Units Made by the Rejection Rate in C7).Copy the...

E F G Gross Monthly Deduction Salary Rate 1 90.00 200% $ 5000 250% S 7,500 300% $ 9.000 $ 11,000 37.5% $ 15.000 42.5% 5 20.000 475% Deduction Rate 2 150% 200% 250% 30.096 35.0% 400% Deduction Rate 3...

Lego Vulwadon Description Multiple Attempts Not allowed. This test can only be taken once Force Completion This test can be saved and resumed later Your answers are ved automatically Question...

In V15 : Using the appropriate nested functions to complete the following: If the seventh character in the employee ID is 0 or 2 or 3 or 4 or 5 , insert the employee's Region , otherwise the cell...

A person takes a multiple-choice exam in which each question has five possible answers. Suppose that the person has no idea about the answers to three of the questions and simply chooses randomly for...

Prove that a cyclic device that violates the KelvinPlanck statement of the second law also violates the Clausius statement of the second law.

5. As the owner of a small business, you have decided to apply for a loan to expand your locations. Information that you most likely will need to provide to the lender include all but: a. current...

If the following join statement is used to join two tables in a query, which of the following tables would all of the tuples in the relation appear in results? left join university.students on...