1) Rename the first worksheet in your spreadsheet to“Student information

1) Rename the first worksheet in your spreadsheet to“Student information”. 2)Add the title “Students Results” at the top of your worksheet. 3)Format the title Hconsider font style,font size,text colour,cell back ground colour, text alignment or merged cells. 4)Use anappropriate function to calculate the date.) 5)Foreach subject(English,Maths,Accounting,andCommerce),write a formula to calculate the tota lmarks.) 6)Foreachstudent,calculatetheaveragemarkforthefoursubjects(English, Maths,Accounting,and Commerce)7)Using an IF function,output the following letters forthefollowingconditions: “A”where the average is greater than or equal to, “B”where the average is greater than or equal to65%, “C”where the average is greater than or equal to50%, “D”where the average is greater than or equal to40%,“E”where the average is greater than or equal to25%, “F”otherwise.

Leave a Reply

Your email address will not be published. Required fields are marked *