RESULT SHEET COMPUTATION IN MS-EXCEL

—step 1:

enter your data in a worksheet,eg below

 To get the mark obtained by each student in all the courses

—Click on the cell below the cell named mark obtained

—Type in the sum formular

—=SUM(D4:J4)

—Press Enter

step 2:

 Click and hold the mouse pointer on the result given untill it turns to a thin cross

—Drag it down to get the mark obtained by each student on the list

  

  To get the minimum mark obtained by each student in all the courses

—Click on the cell below the cell named mark obtained

—Type in the Min formular

—=Min(D4:J4)

—Press Enter

—Click and hold the mouse pointer on the result given untill it turns to a thin cross

—Drag it down to get the minimum mark obtained by each student on the list

step 3:

—To get the minimum mark obtained by each student in all the courses

—Click on the cell below the cell named mark obtained

—Type in the Min formular

—=Min(D4:J4)

—Press Enter

—Click and hold the mouse pointer on the result given untill it turns to a thin cross

—Drag it down to get the minimum mark obtained by each student on the list