In Excel Chapter 2 Lesson (v2019) x M SIMnet - Excel 2019 Chapter 3 PI X Course Hero X | + C & https://lavc.simnetonline.com/sp/assignments/projects/details/6439072 SIMnet ASSIGNMENTS LIB 8. Display your formulas to check for accuracy. a. On the Formula tab, in the Formula Auditing group, click the Show Formulas button. b. When you are ready to continue, hide the formulas and display formula values by clicking the Show Formulas button again. 9. Define a named range for the total possible points up to the class drop cut-off point. a. Select cells D7:R7 b. In the Name box, type: PossiblePtsMid c. Press Enter 10. Find out which students have a grade below C at the cut-off point for dropping the class. Enter an IF function in cell $10 to check if the student's total points divided by the total possible points through the midterm is less than 70% (the lowest percentage for a C grade). Use SUM functions within the IF function. Be sure to use the range name you just defined for possible points. If the student is below a C grade, display Warning! in the cell; otherwise leave the cell blank. a. Click cell $10. b. On the Formulas tab, in the Function Library group, click Logical. c. Click IF. d. W If necessary. move the Function Arguments dialog so you can see the worksheet data. e. In the Logical test argument box, type: SUM (D10 : R10) /SUM(PossiblePtsMid)