Instructions Part $2$: Switch to the IF sheet in the SC$\_$EX$\_3\_$Fill$\_$and$\_$IF workbook.

Write an IF function in cell C$3$ that assigns a grade of "Pass" if the score in cell B$3$ is $70$ or above,

and a grade of "Fail" if the score in cell B$3$ is below $70.$ Copy this function to cells C$4$:C$19.$

Write a nested IF function in cell D$3$ that assigns a grade of A for scores between $90$ and $100,$ a

grade of B for scores between $80$ and $89,$ a grade of $C$ for scores between $70$ and $79,$ and a grade

of $F$ for scores below $70.($Hint: Search in Help for nested IF when constructing your function.$)$

Copy this function to cells D$4$:D$19.$

Calculate the average grade in cell B$21.$ In cells C$21$ and D$21,$ use a formula to determine

whether the average grade is a passing grade, and the overall grade achieved by the class.