Create the below table as it is using Microsoft Excel. Use the cell formatting knowledge to format the cells in a better way. Now let's try to perform the below operations on the above data set.
Create a new column and name it as Total. Calculate the total marks for each student. For this, use the suitable function.
Create a new column and name it as Average. Calculate the average marks for each student. Use the relevant function for calculating the average.
Create a new column and name it as Grade. Display the grade based on the given criteria.
If the average is greater than or equal 75 then display “Merit”, If not check if the average is greater than or equal to 60 then display “Credit”, if not check if average is greater than or equal to 40 then display “Simple”, if none of above is applicable then display "Failed".
Display the absent student count for each subject. Use a suitable function to display the absent count.
Display the highest mark that students got for each subject. Use a suitable function to display the highest marks.
Display the lowest mark that students got for each subject. Use a suitable function to display the highest marks.
Save your work.