can someone show me the formulas needed to answer columns E-H? thanks

Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me 28 \begin{tabular}{l} 29 \\ 30 \\ \hline 31 \end{tabular} 31 4 Sheet1 \begin{tabular}{|c|} \hline Grade Range ( ) \\ \hline 74 \\ \hline 77 \\ \hline 80 \\ \hline 84 \\ \hline 87 \\ \hline 90 \\ \hline 94 \\ \hline \end{tabular} hes per week or is an ' A student (second condition) Microsoft Excel Overal zrade equals to or wreater than 94W Practice sports at least three times per week and overall grade is at leant 88% \begin{tabular}{l} \hline D \\ \hline dering Analytics Major is \\ \hline NO \\ \hline YES \\ \hline YES \\ \hline NO \\ \hline NO \\ \hline YES \\ \hline YES \\ \hline NO \\ \hline NO \\ \hline NO \\ \hline YES \\ \hline NO \\ \hline \end{tabular}