Vuhelper
01-04-2012, 07:47 PM
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
Average Marks < 60
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 25+56= 81
2 BC100402898 Abrar 53 87 53+87= 140
3 BC101402897 Abid 33 25 33+25= 58
4 BC200402900 Usman 66 85 66+85= 151
5 BC100802901 Saeed 55 65 55+65= 120
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
Average Marks < 60
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 25+56= 81
2 BC100402898 Abrar 53 87 53+87= 140
3 BC101402897 Abid 33 25 33+25= 58
4 BC200402900 Usman 66 85 66+85= 151
5 BC100802901 Saeed 55 65 55+65= 120