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

CCC Online Test 2021 CCC Practice Test Hindi Python Programming Tutorials Best Computer Training Institute in Prayagraj (Allahabad) Best Java Training Institute in Prayagraj (Allahabad) Best Python Training Institute in Prayagraj (Allahabad) O Level Online Test in Hindi Bank SSC Railway TET UPTET Question Bank career counselling in allahabad Sarkari Naukari Notification Best Website and Software Company in Allahabad Sarkari Exam Quiz