Question
I am stuck on this part and can't find a video, please help Luke now wants to determine how many members of his staff will
I am stuck on this part and can't find a video, please help
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 members college graduate status is equal to Yes.
C. The function should return the text No if the staff member is not a college graduate.
THE BELOW IS A VISUAL ON WHERE I AM STUCK
Jr 2 AutoSum Logical - Lookup & Referencer a Detine Name A Recently used - A Text - O Math & Trig - E Use in Formula Insert Name unction Financial - O Date & Time" - More Functions Manager Create from Selection Function Library Defined Names XV fi =IF([College Graduate),"Yes", "No") O Trace Precedents A Show Formulas Trace Dependents Error Checking - Watch Calculation D K Remove Arrows & Evaluate Formula Window Options Formula Auditing Calculation Subject Leader Supervisor - Online Tuto Superviso Yes A 65 C D E F G Employee Name Service Years Pay Rate HR Training Years since College Academic ID Time YearHR Training Graduate Technology Training 2012 Alison Simoneau Yes $ - 2015 No 2007 Bert Tuma No $. 2017 Yes Yes 2027 Brooke Abalos Yes $ - 2016 No Yes 2024 Danilo Thedford No 16 $ - 2016 Yes 2009 Donna Dressler Yes 4 2017 Yes 2017 Elizabeth Pries Yes O 2017 No No 2010 Gary Zellers No $ - 2016 Yes No 2005 Glenn Delatorre Yes S. 2016 No No 2001 Jenette Forst No $. 2016 No No 2018 Karen Coyle No 2016 No Yes 2002 Ken Keith Yes $. 2016 Yes 2015 Kecio Mcleod 2016 Yes Yes 6 $ - #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! es" "No" Yes Yes YesStep 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