Question: i need help with #3 please, must be a structured reference 3. To be elgible for the leadership troining program offered by the office, a

i need help with #3 please, must be a structured reference
i need help with #3 please, must be a structured reference 3.

3. To be elgible for the leadership troining program offered by the office, a sfudent must have at leost 2 years of post- 0/5 secondary educafion or have gone through the organization finance training. In cel K2 enter a formula using the If and OR functions and structured references as tollows to determine if Kay, Colbert can join the leodeship training program: a. The if function should determine if the students PostSecondary Years is greater then or equal to 2 OR it the students finance centifed status is "Yes". retuming the text Yes i a student meets one or both of those criteria or the test No it a student moets nether of those citeria. b. Fi the formula into the range K3K31, it necessary. Create a formula using a function. In the 5 tudent Representalves wensheet, the Jarmula in cel k.2 should use a structured relerence to the Post. Socondary Yean valve in the logicall argument of the OR function. Copy a tormula into a range. in the Student Repretentalives workeneet, cei K2 contain an incorrect fommila. 4. Eperienced students may serve as mentons it they are at leat age 21 and have at least 3 years of postsecondary 0/5 education, in cel 12, enter a formila using the If and AND functions and structured references as follows to determine if Kay Colbert is eligble to serve as a mentor: a. The if function should delemrine it the studenfs age is greoter than or equal to 21 AND the studenfs postsecondary Yean are greater then or equal to 3 , and shovid return the text Yes if a student meebs both of those citeria or the fext No if a student meets none or oniy one of these crileria. b. Fit the toemuia into the range 2.3:31, It necesiary. Creale a formula using a Ancton. In the Student keptosentativen workseet, the forrnia in cei 12 ahoild ute a shictured reference to the Age youe in the logicail argument of the AMD functan. Copy a tomula into a range. In the Student \&epaesontof wersisheot, cel 12 contains an incorrect formula: 5. Loel is always on the lookout foe sudents who might be interesled in running for olfice in sfudent groups. 0/5 h cell M2, enter a formulo using a nested if tunction and structured references as tolows to detemne first if a student has areody been elected to office in a student group, and if nok, whener that student meets the qualications to nun in the tulure: a. It the value in the Becled column is equal to the lext "Yes", the formula should display fiected as the text. b. Otherwise, the fomrila should delermine if the value in the Finance Cert fed column is equal to the feat "Yes" and return the teat Yes if the And No It false. Create a formula viling a tuncton. in mo Student Repteventatives wonaheet, the fomyla in cel M2 should see a thuctured relerence to the finance. Ceffifed valuo in the logical lent orgument of the inner if function. Copy a formula into a range. in the Student Representatver wodaroet, cel M2 contoint an incorect formula

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!