just need help with question #5

Insert Format Tools Table Window Help a CIS120 Final Project Case Study Instructions-1- Saved to my Mac ign Layout References Mailings Review View 11 Aa v AalbCcDE AoCcDdte AaCOd AaCcDE AaoCcOd A 2. A Sube Emgh No feecing Heading? Emphasis tense Emp Tresuod c) Get the Average, Minimum, and Maximum of Final Test. (5 points) 4. 5. Calculate the Final Average based on Test 1, Test 2, and Final Test. (5 points) If the first 5 students expect to get the Final Average of 95, what would their Final Tests need to be. (10 6. points) Assign letter grade to each student after above calculations are completed using Vlookup or Hlookup. 7. (10 points) What is the final grade distributions? In other words, how many students eamed A, B, C, D, and F? Use COUNTIF or Pivot Table to organize your data by grade in your excel sheet to show your result. (15 points) 8. Grading scale: > 0 and = 60 and = 70 and = 80 and = 90 and