6. Enter a formula in cell G2 to calculate the exam average earned for the student in cell A2 after dropping the lowest exam score. Your formula must:Use a reference for the total points earned that does not use a hard-wired number Use a denominator calculated using a function that counts ((number of exams taken)-1)Automatically update if an exam score changes
Solved by G. J. in 12 mins