Problem 2: Imagine it's the end of the semester and I need to assign your grades based on the rubric provided in the spreadsheet below (E5:G9). (1) Write the formula for cell C3, C4 and C5 based on the rubric. (Hint: consider VLOOKUP()) (2) For the same rubric provided, consider the fact that getting lower than 70 is equivalent to getting F. Rewrite the formula for C3 C4 and C5. (Hint: consider IF()) (3) Verify your results using Excel and provide the screenshot including the formulas. A B C D E F G H StudentName Exam grade Final grade 2 A1 73 D 3 A2 91 ? 4 A3 94 ? Rubric Details Grade 5 A4 79 ? 70 Bad D 6 A5 82 B 75 Must improve C 7 A6 93 A 80 Good B 8 85 Better B+ 9 90 Best A 10