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.

Transcribed Image Text:

Formulas Review => 10 at AutoSum Recently Financial Logical Text Date & Lookup & Math & on Used- S s Service Years Pay Rate 6 7 B 9 10 SVOGAUNIO 11 Home 12 13 14 15 16 17 18 19 20 3 5 3 16 W 4 0 9 1 1 3 Insert Page Layout Data A A 3 4 1 17 2 4 2 $ 25.00 $ 28.50 $25.00 $28.50 $25.00 $18.00 $28.50 $ 20.00 $20.00 $ 25,00 $25.00 $25.00 $25.00 $ 25.00 $ 20.00 $28.50 $ 22.50 1 25.00 $ 22.50 Function Library HR Training Years since HR Training Year 2015 2017 2016 2016 2017 2017 2016 2016 2016 Staff Listing 2016 2016 2016 2014 2014 IF(H2="Yes", "Yes","No") G 2016 2015 2015 2017 2015 Type here to search 2 0 Define Name Usein Form More Name Time Reference Trig Functions Manager Create from Selection Defined Names 1 1 0 0 1 1 1 1 1 1 3 1 1 2 2 0 2 H College Graduate No Yes No Yes Yes No Yes No No No Yes Yes No Yes No Yes Yes No Yes View O Academic Technology Training Yes Yos Yes Yes Yes No No No No You Developer Yet You Yes Yes No Yes No No No 11 Subject Leader No Yet No Yes Yes No Yes No No No Yes Yes No Yes No Yes Yes No Yes Help E Design Supervisor No Yes No Yes Yes No You No No No Yes Yes Ne Yer No Yes Yes No Yor CH V Tell me what you want to do Trace Precedents Show Formula 6 race Dependents Emor Checking - Watch Remove Arrows-Evaluate formula Window I Online Tutoring Supervisor No You No Yes Yes No Yes No No No Yes You Ne Yes No You Yes No You . Auding M Eligible for Academic Technology Training Completed Completed Completed Completed Completed No You No No Completed Completed Completed Completed Completed No Completed No Yes Option Egile Figitale Highs Het Eligible Digh N Hote Engile thigible my Highte thyle Formulas Review => 10 at AutoSum Recently Financial Logical Text Date & Lookup & Math & on Used- S s Service Years Pay Rate 6 7 B 9 10 SVOGAUNIO 11 Home 12 13 14 15 16 17 18 19 20 3 5 3 16 W 4 0 9 1 1 3 Insert Page Layout Data A A 3 4 1 17 2 4 2 $ 25.00 $ 28.50 $25.00 $28.50 $25.00 $18.00 $28.50 $ 20.00 $20.00 $ 25,00 $25.00 $25.00 $25.00 $ 25.00 $ 20.00 $28.50 $ 22.50 1 25.00 $ 22.50 Function Library HR Training Years since HR Training Year 2015 2017 2016 2016 2017 2017 2016 2016 2016 Staff Listing 2016 2016 2016 2014 2014 IF(H2="Yes", "Yes","No") G 2016 2015 2015 2017 2015 Type here to search 2 0 Define Name Usein Form More Name Time Reference Trig Functions Manager Create from Selection Defined Names 1 1 0 0 1 1 1 1 1 1 3 1 1 2 2 0 2 H College Graduate No Yes No Yes Yes No Yes No No No Yes Yes No Yes No Yes Yes No Yes View O Academic Technology Training Yes Yos Yes Yes Yes No No No No You Developer Yet You Yes Yes No Yes No No No 11 Subject Leader No Yet No Yes Yes No Yes No No No Yes Yes No Yes No Yes Yes No Yes Help E Design Supervisor No Yes No Yes Yes No You No No No Yes Yes Ne Yer No Yes Yes No Yor CH V Tell me what you want to do Trace Precedents Show Formula 6 race Dependents Emor Checking - Watch Remove Arrows-Evaluate formula Window I Online Tutoring Supervisor No You No Yes Yes No Yes No No No Yes You Ne Yes No You Yes No You . Auding M Eligible for Academic Technology Training Completed Completed Completed Completed Completed No You No No Completed Completed Completed Completed Completed No Completed No Yes Option Egile Figitale Highs Het Eligible Digh N Hote Engile thigible my Highte thyle

Answer rating: 100% (QA)

If your data is not formatted as table than in cell J2 ... View the full answer