Programming Examples

Create a spreadsheet of Student marks and find the followings


Create a table in MS-Excel as shown below:

Roll No. Name Marks in English Marks in Maths  Total Marks
1.Rahul 85 95
2.Ronit 65 50
3.Amit 72  80
4.Rupesh 40 60
5.Shivika 35 60
6.Garima 87 91

Do the following:

a) In the total marks column, entries should be calculated using formulas and it is the sum of marks in physics and marks in chemistry.

b) Insert a new row at the end of the table and also find grand total using formula.

c) Sort the table based on total marks.

d) All columns should be center aligned.

e) Heading should be in bold and underlined

Output/ Explanation:

Latest Current Affairs 2024 Online Exam Quiz for One day Exam Online Typing Test CCC Online Test Python Programming Tutorials Best Computer Training Institute in Prayagraj (Allahabad) Online MBA 2 years Online MCA Online BCA Best Website and Software Company in Allahabad