CS001 Assignment No 4 Solution & Discussion Due Date :09-01-2012

Assignment # 04                              Microsoft Excel
Due Date : January 9, 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 [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
2	BC100402898	Abrar	53	87
3	BC101402897	Abid	33	25
4	BC200402900	Usman	66	85
5	BC100802901	Saeed	55	65

Read more: CS001 Assignment No 4 Solution & Discussion Due Date :09-01-2012 - Virtual University of Pakistan http://vustudents.ning.com/group/cs001computerproficiency/forum/topics/cs-001-ki-ass-solution-chaiyay-mujy-plz-give-me#ixzz1ilxEGbe1