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: