Question: Create the worksheet below In MicrOSoft EXCel and save It as marks.AARUNA 1 STUDENT GENDER TEST ( 2 0 ) ASSIGNMENT ( 1 0 0

Create the worksheet below In MicrOSoft EXCel and save It as marks.AARUNA1 STUDENT GENDER TEST (20) ASSIGNMENT (100) EXAM (50)3ANIL4 MARTIN M5 MARY F6 LINDA7 VARUNTEJMBM177141514163 In cell E1, enter the text "Coursework"copy the formula to the cells E3 to E8.9 Merge the cells A1 to H1D5 In cel G1, enter the text "Final Mark"702 Insert a new column between column D and column E7 Sort the students in alphabetical order53778 Insert a new row with the cell pointer in cell A16010 In cell A1, enter the text "ACA Marks"785660Note: Exam mark contributes 60% of the final mark344 In celI E2, enter a formula to calculate the coursework for the student.23Note: Remember the test is out of 20, the assignment is out of 100, and the exam isThe coursework mark contributes 40% of the final mark. Further, test and assignmer3529406 In celI G2, enter a formula to calculate the final mark for each student243911 Bold, underline, center, change font size of heading to 15 and the font to 'Times New12 In cell H2, enter the text "Grade"13 In cell H3, enter the formula for grading the student according to final markThe grading is as follows: 0-49=F,50-64=C,65-79=B,80-100=A14 Filter all the students who got test marks greater than 15. The list of students should
Create the worksheet below In MicrOSoft EXCel and

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!