O Level IT Tools Practical Assignment | Enter the following data using spreadsheet tool (Excel, Calc) and save it in Grade

Exercise- Enter the following data using spreadsheet tool (Excel, Calc) and save it in Grade-

Do the following:-

a) Compute the total marks and percentage of each student by entering appropriate formula

b) Compute the grade based on following criteria-

If percentage>=90 then grade=A

If percentage>=80 and <90 grade=B

If percentage>=70 and <80 grade=C

If percentage>=60 and <70 grade=D

If percentage<60 then grade=E

c) Draw a border around the worksheet

d) Change the font size of heading to 14 points and underline it and hide column c

e) Increase the width of column A to 15 character

f) Right Align the values in column B, C, F

Solutions:- 

a) To calculate the total marks in E2 cell, type the function =sum(b2:d2) and press Enter key. 

And to calculate the percentage of student, type the formula =E3*100/300  and press Enter key. 

b) To compute the grade of student type the functions 

=if(F2>=90,"A",IF(AND(F2>=80,F2<90),"B",IF(AND(F2>=70,F2<80),"C",IF(AND(F2>=60,F2<70),"D","E"))))

c) Select the area in a worksheet which you want to apply border and click on border icon from toolbar and select all border icon.

d) Apply the font size 14 and underline for all heading and right click on C column and click hide option from drop down menu.

e) Increase the width of column A by dragging it up to 15 character size

f) Select the data of column B, C, F, and set it to right align.