00:00The conventional way to calculate the weighted average mark will be equal
00:03midterm multiplied by weight of the midterm press F4 to make the cell into
00:08a fixed reference plus final year exam multiplied by the weight F4 plus
00:15project result multiplied that by the weight press F4 to make it fixed
00:20reference plus final remedial exam multiplied that by the weight and press
00:25F4 and hit enter that will give you the weighted average and then after that
00:29apply the rest of rows for the rest of the students as you can see there's a
00:33lot of typing going on the fastest way and the most easiest way would be to use
00:37some product like this and the first argument on some product will be the
00:41whole row of the results comma the second argument will be the weighted average
00:46make sure you press F4 to make it fixed reference so they can apply to the rest
00:49of row close parenthesis hit enter and then apply the same formula to the rest
00:54of the row so they can calculate the weighted average for all the students
Comments