W AutoSave Off H Assignment 3-IDS 200-Fall 2022 (2) . Saved to this PC v Search (Alt+Q) Gonzalez, Viviana GV O X File Home Insert Draw Design Layout References Mailings Review View Help RCM Comments Share Arial 10 O B I Uv. X, X = Heading 1 Normal Title Paste Editing Dictate Sensitivity Editor Reuse A ~ Aav A A AL Files Undo Clipboard Font IN Paragraph N Styles Voice Sensitivity Editor Reuse Files IDS 200 You will need to create a new Excel file for this assignment. Fall 2022 Assignment 3 Create a worksheet with the columns of student names and scores as shown above. Due Friday 10/21, 11:59pm AWN . Add a column to the right of Exam 2 labeled "Percentage" Add a column to the right of Percentage labeled "Grade" 24 points Put the maximum score (300, to include both exams) in any convenient cell on your worksheet. Reference this cell - using absolute addressing - to calculate the corresponding percentage score for each student Instructions Points will be deducted if you do not use absolute addressing in this formula. Deadline EX: If a student's score was in cell C2 and the maximum score is in cell G3, your formula would To receive full credit, this assignment must be submitted by Friday, October 21st at 11:59pm. Submitting be C2/$G$3, not C2/G3 (relative addressing). your assignment early is recommended. Late submissions will be accepted (but penalized 8pts) up to one week after the submission deadline. After that, assignments will not be accepted. 5. Below the table of students, use the MIN function to calculate the lowest percentage and display with a label of "Lowest Percentage". Assignment 6. Below the lowest percentage, use the MAX function to calculate the highest percentage score and display with a label of "Highest Percentage." In the table below, there are exam scores from a class of students. Each exam was worth 150 points and 7. In any convenient area on your worksheet, order the grade cutoffs in ascending order. Then, use e scores in the table are the # of points out of 150. Letter grades will be assigned using the standard the VLOOKUP function to display the letter grade for each student. If you don't have the grade ade boundaries given on the right, below. cutoffs in ascending order, your VLOOKUP function will not work. Also, remember that the cutoff for an F grade is actually a zero. Last Name | First Name | Exam 1 am 2 Aliya Sally 132 147 Anderson Vega 118 126 The Excel file with your completed assignment should be submitted to the Blackboard site for your lab Bardsley Abhilash 86 87 section. Please name your file HW30coxx where xxxx is your Netld. Donegal Kyle 98 103 Example: HW3jdoe2 if your Netld is jdoe2. Golden Stacey 129 133 Harrison David 127 122 Hendry stasia 123 129 Henry Pat 123 127 Hollins Gus 129 135 Percentage Grade Jonas Maliyah 158 170 inwood Carey 156 164 760 B Marshall Cronelia, 99 104 64% Mercado Jaylyn 112 115 50% D Morales Katie 110 103