BMA4003-20 Managing Data WY1Excel activity2. In Column G, to compute Final Average for each student, assuming each examtakes 30% weight and PART. (participation) takes 10% weight in the assessmentpackage.So, in cell G5, we type in=30%*c5+30%*d5+30%*e5+10%*f5Then, press ‘Enter’. You should have the number 85.9 shown in cell G5. Then,move the mouse to the right bottom corner of cell G5 until you see the little black30%30%30%10%Weight for different componentsin the assessment packageExam#1Exam#2Exam#3PART.BMA4003-20 Managing Data WY2cross. Left click and hold the mouse. Drag down the mouse until the cell G8 andrelease the mouse. You should get the result as below.Job done for today. You learnt the useful trick ‘copy and paste’ in Excel togetherwith the concept of weighted average. Well done!
