Luke now wants to determine how many members of his staff will be eligible to be subject leaders. In cell J2, enter a formula using the IF function and a structured reference to determine if Alison Simoneau can be a subject leader. a. The IF function should first determine if the staff member is a college graduate. Use a structured reference to the College Graduate column. b. The function should return the text Yes if the staff member's college graduate status is equal to Yes. C. The function should return the text No if the staff member is not a college graduate Home Insert Page Layout Data Formulas Review View Developer Help Design Define Name - 2 A S 0 * AutoSum Recently Financial Logical Text Date & Lookup & Math & Used Time Reference Trig Function Library X f x =F(H2="Yes","Yes","No") - More Functions 9 Name Manager Tell me what you want to do Trace Precedents Show Formulas Trace Dependents "Error Checking - Remove Arrows" Evaluate Formule Formu Auditing on Window Options Create from Selection Defined Names HR Training Years since Service Years Pay Rate Year HR Training College Graduate Academic Technology Training Subject Leader Supervisor Online Tutoring Supervisor Eligible for Academie Technology Training Tuition Remission 2015 2017 2016 2016 2017 2017 2016 Completed Completed Completed Completed Completed 52 2 2 2 Northg ble Egible Not big Note Eligible Eligible 2016 $ 25.00 $ 28.50 $ 25.00 $ 20.50 $ 25.00 $ 18.00 $ 28.50 $ 20.00 $ 20.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 20.00 $ 20.50 $ 22.50 $ 25.00 $ 22.50 Stall Listing Completed Completed Completed Completed Completed Eligible 2016 2016 2016 2016 2014 2014 2016 2015 2015 2017 2015 Completed Ergible Type here to search