You are trying to determine which of the following 4 baseball teams are great teams

You need to assign the Great Teams Column by creating a formula in Cell F2 and using the fill down function

You want to assign a value of 1 to the Great Teams column for teams that have 2 or more World Series Titles or more than 5 League Titles and a value of zero otherwise.

Which of the following If, then functions would correctly assign the values if entered in cell F2 and filled down the column. There may be more than one correct answer.

a. =IF(AND(D2>5,E2>=2),1,0)

b. =IF(OR(D2

c. =IF(D2>=5,IF(E2

d. =IF(AND(D2

e. =IF(D2

f. =IF(OR(D2>5,E2>=2),1,0)

\begin{tabular}{||l|l|l|l|l||l||l||} \hline \hline & A & B & C & D & E & F \\ \hline 1 & Team number & From Texas & Wins & League Titles & World Series Titles & Great Team \\ \hline 2 & 1 & 0 & 80 & 3 & 2 & ? \\ \hline 3 & 2 & 1 & 50 & 2 & 2 & ? \\ \hline 4 & 3 & 0 & 60 & 4 & 1 & ? \\ \hline 5 & 4 & 0 & 90 & 7 & 0 & ? \\ \hline \end{tabular} \begin{tabular}{||l|l|l|l|l||l||l||} \hline \hline & A & B & C & D & E & F \\ \hline 1 & Team number & From Texas & Wins & League Titles & World Series Titles & Great Team \\ \hline 2 & 1 & 0 & 80 & 3 & 2 & ? \\ \hline 3 & 2 & 1 & 50 & 2 & 2 & ? \\ \hline 4 & 3 & 0 & 60 & 4 & 1 & ? \\ \hline 5 & 4 & 0 & 90 & 7 & 0 & ? \\ \hline \end{tabular}