You are to complete the spreadsheet above with formulas in the blue boxes. The formulas should calculate the grade for each student using the weightings indicated. For example, the grade in cell F7 should be 35/2+21/2+50*3/5 = 58.
brocky, my answer was 58 without your change to the equation....as fanta set out her equation, I read 3/5 as three fifths of 50; answer 30...of course as you say (50*3)/5 also gives 30...