Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please see the example below on where I currently am stuck. 9 Online students require tutors with Academic Technology training. Academic Technology training is offered
Please see the example below on where I currently am stuck.
9 Online students require tutors with Academic Technology training. Academic Technology training is offered to staff with more than 2 years of service at the academic support center. Luke wants to identify the staff members eligible for Academic Technology training in the table In cell M2, enter a formula using a nested IF function and structured references to determine first if a staff member already has completed Academic Technology training, and if not, whether that staff member is eligible for Academic Technology training If the value of the Academic Technology Training column is equal to "Yes", the formula should return the text Completed. Remember to use a structured reference to the Academic Technology Training column a. b. If the value of the Academic Technology Training column is equal to No, the formula should determine if the value in the Service Years column is greater than 2 The formula should return the text Yes if the staff member's Service Years value is greater than 2 c. d. The formula should return the text No if the staff member's Service Years value is not greater than2 Staff members with over 1 year of service are eligible for tuition remission at the college. Luke wishes to create a new calculated column in the table to identify staff members eligible for tuition remission 10. In cell N1, enter the text Tuition Remission as the calculated column heading (Hint: If a filter arrow appears in cell N1, ignore it.)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started