Question: (0-10 pts) Write an Excel function in cell Gymnast!l2, which is to be copied down, to determine the gymnast's overall average score. An individual's overall

(0-10 pts) Write an Excel function in cell Gymnast!l2, which is to be copied down, to determine the gymnast's overall average score. An individual's overall average score is determined from the average scores of the individual events. (Hint: Use the AVERAGE() function here with a range for individual average event scores from the Events worksheet columns K, L, M, and N. Remember to always check for if a S is needed for the numbers in any cells used since you are copying this function down.). =AVERAGE(average range in Events worksheet for average score for each event) =AVERAGE( )
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
