https://www.google.com/contributor/welcome/?utm_source=publisher&utm_medium=banner&utm_campaign=2376261057261409

Search This Blog

Search with our Site

Custom Search

Saturday, January 7, 2012

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 IDStudent NameSubject-1Subject-2Total MarksAverage MarksResult
1BC102402867Asif2556   
2BC100402898Abrar5387   
3BC101402897Abid3325   
4BC200402900Usman6685   
5BC100802901Saeed5565


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

No comments:

Post a Comment