HW #1

Make a grade book. Make up the names of 10 students (first name and last name in two separate columns), and give them grades for a midterm and a final.
The grade for the course should be 40% of the midterm and 60% of the final.
Use VLOOKUP to match the course grade with a letter grade.
Use string concatenation to concatenate the first name with the last name.
Calculate the minimum grade, the maximum grade, the mean, the median, the mode, and the range. Use this website's definition of these terms.
Give the third student in your list a 70. Use Goal Seek to find out the exact grade he needs on the final to get a semester average of 75.