CS001 Computer Proficiency Assignment no 2 Discussions January 2012

[Vuhelper]

Bitmap
Assignment # 02 Microsoft Excel

Due Date : January 13, 2012 Instructions

1 - Add Subject-1 cell values and Subject-2 cell values into cell of Total. [Hint: Add Row Wise ]
2 - The formula for the Total should be [Subject-1 + Subject-2 = Total Marks]
Example 68 + 90 = 158
3 - Values of Average Marks field should be obtained by using AVERAGE formula.
(Take average of Subject-1 + Subject-2 of each student)
4- Use "IF formula" to define the Result of each student. Criteria is given below.
Average Marks >= 60 Pass
Average Marks < 60 Fail
5 - Align [align=center] the values of the following cells.
(Subject-1, Subject-2, Total Marks, Average Marks, Result)
6 - Make Bold the titles of each column. E.g. Sr. No. Student ID, Student Name, Subject-1 etc.
7 - Make Bold, Italic the value of Total Marks field.
9 - Give red background colour to the student record who is FAIL.
10 - Do not forget to save your work before you exit from Microsoft Excel.



Sr. No. Student ID Student Name Subject-1 Subject-2 Total Marks Average Marks Result
1 BC102402867 Asif 25 56 81 40.5 fail
2 BC100402898 Abrar 53 87 140 70 Pass
3 BC101402897 Abid 33 25 58 29 fail
4 BC200402900 Usman 66 85 151 75.5 Pass
5 BC100802901 Saeed 55 65 120 60 Pass