B B C D Test 1 Test 2 Final Test 70 67 60 1 Grade Book 2 Course CIS 120 3 Name 4 ab.cd 5 cd,ef 6 ef.gh 7 ghij 8 0), kl 9 kl.mn 10 mnop 11 op.gr 12 qr,st 13 st, uv 14 uv,wx 15 wx,yz 16 67 60 67 56 56 60 59 51 59 50 58 51 59 55 54 85 80 66 80 75 80 90 60 80 70 60 80 64 60 61 68 63 69 5 Overview 2. 3 4. 5. Please use the Excel data file to analyze the grades for students in their class. You are required to use either a formula or function to receive points for the steps. Typing in the answer is worth 0 (zero) points. Steps to complete are as following: 1. Separate the student first name and last name into two columns. (5 points) Get the Average, Minimum, and Maximum of Test 1. (5 Points) Get the Average, Minimum, and Maximum of Test 2. (5 points) Get the Average, Minimum, and Maximum of Final Test. (5 points) Calculate the Final Average based on Test 1, Test 2, and Final Test. (5 points) 6. If the first 5 students expect to get the Final Average of 95, what would their Final Tests need to be. (10 points) 7. Assign letter grade to each student after above calculations are completed using Vlookup or Hlookup. (10 points) 8. What is the final grade distributions? In other words, how many students earned A, B, C, D, and F? Organize your data by grade in your excel sheet to show your result (15 points) Grading scale: >= 0 and = 60 and = 70 and = 80 and = 90 and