Experienced students may serve as mentors if they are at least age 21 and have at least 3 years of post-secondary education. In cell L2, enter a formula using the IF and AND functions as follows to determine if Kay Colbert is eligible to serve as a mentor: The IF function should determine if the student's age is greater than or equal to 21 AND the student's post-secondary years are greater than or equal to 3, 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. Fill the formula into the range L3:L31, if necessary.

Question

17-06-2020
Computers and Technology

contestada

Experienced students may serve as mentors if they are at least age 21 and have at least 3 years of post-secondary education. In cell L2, enter a formula using the IF and AND functions as follows to determine if Kay Colbert is eligible to serve as a mentor: The IF function should determine if the student's age is greater than or equal to 21 AND the student's post-secondary years are greater than or equal to 3, 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. Fill the formula into the range L3:L31, if necessary.

Respuesta :

Otras preguntas

You do a study on elephants and find that there are eight elephants per acre. This is a measurement of a) Density. b) Dispersal. c) Demographics. d) Survivorshi

Rank the limits of government in order from 1 (most important) to 5 (least important)

What assessments are part of the Armed Services Vocational Aptitude Battery Career Exploration Program (ASVAB/CEP)? 1) Assessment A 2) Assessment B 3) Assessmen

How the narrator particularize the Vietnamese immigrant experience from other Asian immigrants to the United States of American?

Fifteen years ago, a man who owned vacant land granted an easement over that land, by deed of gift, to his neighbor for use as a shortcut to her cabin. The deed

A man spent 12 1/2 %of his money and he is left with ? 140. How much money had he at first?

How does the symbol of hockey play a role in this story? Hockey equals Canada. Does the story affect the way you view hockey and the history of this country? Wh

Select the category that would yield qualitative data. a) Pet's purchase price b) Pet owner's monthly income c) Pet's age d) Pet's eye color

Describe the process you would need to follow to create a 500.0 mL. 2.0 M solution of glucose.

Which statements describe the responsibilities of the customer as part of the shared responsibility model? Select all that apply. a) Ensuring data security b) M

ACCESS MORE

MrRoyal MrRoyal · Answer 1 · 2020-06-21T03:51:35+02:00

Answer:

=IF(AND(B2>=21,C2>=3),"Yes","No")

Explanation:

Given

Age: Not less than 21

Post secondary education: Not less than 3 years

Required:

Enter a formula using the IF and AND functions as follows to determine if Kay Colbert is eligible to serve as a mentor

The excel file showing the records is not provided; So, in other to solve this question following assumption will be made

Cell B2 represents age
Cell C2 represents post secondary education

After giving you the formula using my illustration, all you need to do is to edit the cell names to suit your purpose;

Type the following in Cell L2

=IF(AND(B2>=21,C2>=3),"Yes","No")

Analysis

=: An excel formula must start with =

IF: This shows the function being used

AND: This shows that there are more than one condition in the IF function; all of which must be true

B2>=21,C2>=3: These are the two conditions in the question;

Note that B2 represents the student age and C2 represent the student post secondary education.

"YES": The IF function will return "Yes" without the quotes, if both conditions are true

"NO": Otherwise, the function will return "No" without the quotes

To fill the formula in L3 to L31, all you need to do drag the formula from L2 down to L31

topeadeniran2 topeadeniran2 · Answer 2 · 2022-03-01T17:14:03+01:00

The formula in excel regarding the students will be =IF(AND(J2>=21,K2>=3),"Yes","No")

How to input the formula in excel

In this situation, the age is not less than 21 and the post-secondary education is not less than 3 years.

In this case, it is important to enter a formula using the IF and AND functions in order to determine if Kay Colbert will be eligible to serve as a mentor

It can be deduced that IF shows the function being used while AND shows that there is more than one condition.

Hence, The formula in excel will be = IF(AND(J2>=21,K2>=3),"Yes","No")

Learn more about excel on:

https://brainly.com/question/25863198