Can anyone understand this?

[BlackMane]

Under CT1, use an appropriate function to find the highest class test mark for each student, using the class test percentages on the PROGRESS MARK worksheet. there are three sheets here first one being PROGRESS MARKS/ATTENDANCE RECORDS and last one MARK CALCULATIONS.

Stud num	Last Name	First Name	CT1	CT2	CT3	CT4	CT5
Total	100	100	100	100	100
208055193	BEBE	SUYEBULELE TUNCEN	40	87	80	83	0
208105085	BEKU	THUMEKE	80	0	71	80	71
208121854	BERTLETT	MURNEY	29	93	91	89	74
210237791	BRUTZ	MERUETTE JECULUNE	0	0	0	0	0
210189770	BUNTWUNU	TENUEL	0	63	46	0	0
210182970	CHUKTE	ZEHEER EHMET	87	83	83	91	86
208074287	CHULEYU	BUMKEZU	67	53	57	51	69
210225904	ETEMS	JEEN-LEE CHRUSTUPHER	77	70	69	74	83
208006605	GCEYUYE	SENTLE	33	73	63	77	83
208037357	GEGENE	BUSUSUWE ****Y	57	73	74	63	54
208070079	HENTRUCKS	NUCULE TERYN	93	73	0	0	89
210134143	JEKEVULE	LELETHU BRUNWYNE	0	0	34	0	0
209169931	KUKESE	NGUENGU	0	83	89	69	54
210179694	LUCHEBE	METEBUU VERUNUCE	80	73	77	66	86
208143742	LUGEYENU	ETHU ENKUSU	0	57	51	0	0
207094012	LUURENCU	TERCUU CHUCELUE	87	77	66	94	83
210046503	MBEMBENU	NUSUBULELU	77	70	57	86	54
210250151	MEFULEKU	FRUETHELM NELETU	0	70	77	66	0
210099976	MEGENGELELE	EPHUWE	43	63	66	63	74
208204369	MEKEBE	EKHUNE	0	63	60	60	66
210225882	MELENGU	GEBY KESUNGU	53	70	63	74	51
210230908	MENGQUBE	ENETHU YULENTE	0	80	77	83	71

 

[Logit]

.
Sounds like homework ?

https://support.office.com/en-us/ar...-a-range-45fe249f-96c3-443b-8e9f-87f16c48462c

Are you to find the highest score on each of three sheets ?

 

[BlackMane]

yep