Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Experienced students may serve as mentors if they are at least age 2 1 and have at least 3 years of post - secondary education.
Experienced students may serve as mentors if they are at least age and have at least years of postsecondary education. In cell L enter a formula using the IF and AND functions and structured references as follows to determine if Kay Colbert is eligible to serve as a mentor:
a The IF function should determine if the value in the Age column is greater than or equal to AND the value in the student's PostSecondary Years column is greater than or equal to and should return the text Yes if a student meets both of those criteria or the text No if a student meets none or only one of those criteria.
b Fill the formula into the range : if necessary.
Step 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