Question

2. Copy and paste student ID and all five exams into a separate worksheet in your workbook. Label this worksheet Exams". In this worksheet include the 3 highest exam grades among exams 1,2 3 and the comprehensive exam. Average those grades with mandatory exam 4. Note, you should sum the bonus points and exam four in your average. There ought to be 4 exams included in your average, with the comprehensive exam replacing the lowest score among exams 1-3. Use the "average" function and the large" function only. Eastern Train Company Class Data fx Eastern Train Company Class Data fx 1 Student ID hwl hw2hw3 hw4 hws hw6 hw7 hw8 hw9 hw10 hw11 Exam 1 Exam 2 Exam 3 Comp. Exam Exam 4 Test Bonus Points day1 day 100 100 100 100 100 100 100 100 95 100 100 100 100 100 100 100 100 100 100 100 100 100 00 44.74 100 100 100 100 100 100 100 100 100 0 100 100 056 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 0 0 10 00 100 1000 100 100 100 100 100 100 100 100 100 100 100 00 100 100 100080 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 O 10000 0100 100 1000 100 100 100 100 100 100 100 100 100 100 100 0O 65.960010001000 100 26.32 100 100 100 100 100 100 100 0 100 Eastern Train Company Class Data fx STUVW X Y ZAA AB AC AD AE AF AG AH AI AJ AK AL AM AN AL 1 ·s Points day1 day2 day3 day4 dayS day6 day7 day8 day9 day10 day! 1 day12 day13 day14 day15 day16 day17 day 18 day19 day20 day21 day 2 0 100 100 10 100 100 100 100 100 0 100 100 100 100 100 100 100 100 100 100 100 100 00 00 50 50 50 100 10 1000100 000 10000 100 S0 100 100 100 100 00100 100 100 100 100 100 100 100 100 10 100 100 100 100 100 100 1000 100 100 100 100 0100 100 100 100 0 100 1000 S0 50 100 100 100 100 100 100 100 100 100 100 100 100100 100 100 10 100 100 100 100 100 00100 100 100 00 100 100 100 100 10 100 S0 S0 100 00 50 1000 100 0100 100 100 100 10 100 1000100 050 100 100 100100 50 10000 50 100100100 100 100 00100O 10 00 100 100 100 100 100 0 100 0100 100 100 100 000 100 0 S0 100 0 100 100 100 100 100 100100 100 100 100 00 100 100 100 100 100100 100 0100 100 50 100 100 100 100 10 100 100 0 100 100 0 100 0 1000 000 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100100 100 10 100 100 100 100 100 100 100 100 100 100 10 100 100 100 100 100 100100 0 100 100 100 100 100 100 100 100 100 100 0100 10100 0 100 100 000 10 100 100 00 100 0 100 100 100 01000 100 100 100100 100 10010 100 100 100 2

Answer 1

The answer is in an excel worksheet

Student ID	Exam 1	Exam 2	Exam 3	Comp exam	Exam 4	Test bonus points				Average
T001	87	69	60	80	68	0				76
T002	71	44	48	59.25	32	0				52.5625
T003	66	72	52	56.5	32	10				59.125
T004	55	63	88	62.25	64	10				71.8125
T005	82	66	88	15.75	82	0				79.5
T006	42	44	72	58	55	10				59.75
T007	71	69	88	71	95	10				83.75
T008	66	50	36	23.5	59	10				55.25
T009	71	84	64	52.75	36	10				66.25
T010	76	72	96	64.75	45	0				72.25
T011	87	75	88	42.75	91	10				87.75
T012	87	56	32	58.5	41	0				60.625
T013	68	59	72	50.75	59	10				67
T014	71	34	88	84.5	55	10				77.125
T015	97	59	68	34.5	59	10				73.25