use Excel formulas to do the weighted averages

		Test1	Test2	Test3		FINAL
STUDENT NAMES	STUDENT ID	#1	#2	#3	PART.	AVERAGE
Tilly, Susan	999-25-5683	84	65	89	90	80.4
Shulz, Ben	999-52-6938	93	71	97	70	85.3
Raymond, Dorthy	998-71-2838	62	83	58	90	69.9
Smith, Betty	997-74-4447	95	94	80	90	89.7
	Average	83.5	78.25	81