what formulas in excel would I use?

This data set shows the scores for 123 students in an advanced analytics course for a midterm and final exam. 1. Compute the total points for the 2 exams in column E. 2. Calculate the percent grade based on 200 points possible in column E, and format the values as percent. 3. Use an appropriate function to enter the letter grade in column F based on the following scale: - 90% and above - A - At least 80% but less than 90% - B - At least 70% but less than 80% - C - At least 60% but less than 70% - D - Less than 60%F