Can someone please help with this Excel assignment.
In Excel, place each problem on a new sheet and label that sheet
with the problem number. Include all subheadings (a., b., etc) for
each problem. For subheadings that do not require a numerical
answer (like 2.7a), just write “Completed”. Be sure to
include all calculations. Your answers will be graded AS WELL AS
your tabular calculations and format.
Show transcribed image text 1. Reconstruct the worksheet containing student exam scores as shown below in Excel: Overall Student Davis Graham ones Meyers Richardson Thomas William:s Exam1Exam2 Final Exam Score 95 76 100 73 76 95 59 86 69 89 71 65 92 85 59 61 AVERAGE a. I the last column, determine the Overall Score for each student. Exams each count 30% each towards the Overall Score and the Final Exam counts the remaining 40% b. Determine the average score for each of the three exams, and the overall average, in the cells on the bottom row
1. Reconstruct the worksheet containing student exam scores as shown below in Excel: Overall Student Davis Graham ones Meyers Richardson Thomas William:s Exam1Exam2 Final Exam Score 95 76 100 73 76 95 59 86 69 89 71 65 92 85 59 61 AVERAGE a. I the last column, determine the Overall Score for each student. Exams each count 30% each towards the Overall Score and the Final Exam counts the remaining 40% b. Determine the average score for each of the three exams, and the overall average, in the cells on the bottom row





