Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

Please see the example below on where I currently am stuck.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Robert Libby, Patricia Libby, Daniel Short

5th Edition

0073208140, 978-0073208145

More Books

Students also viewed these Accounting questions