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

Assignment No. 03 Semester Fall 2011 Computer Proficiency Licence-CS001

Assignment No. 03
Semester Fall 2011
Computer Proficiency Licence-CS001

Total Marks: 20

Due Date: 26/12/2011

Objective: To learn and understand basic features of Microsoft Word.

Instructions: Please read the following instructions carefully before solving & submitting assignment:

File format should be Microsoft Word Document (.doc). It should be clear that your assignment will not get any credit if:

• The assignment is submitted after due date.
• The submitted assignment does not open or file is corrupt.
• The assignment is copied (from other student or internet).
• Student ID is not mentioned in the assignment file or name of file is other than student ID.
• It is in some format other than MS Word Document (.doc).

For any query about the assignment, contact at cs001@vu.edu.pk

INSTRUCTIONS FOR ASSIGNMENT

View the following image of Microsoft Word document and perform the following tasks.                                   [Marks: 20]

Figure A

1. Draw the diagram (Figure A) in new MS word file named as student Id.doc

       [Hint: Use Auto shapes of Microsoft Word]. [Marks: 10]

2. Insert a new page in this file. [Mark: 2]

3. Write “My data” as the “Heading 1” of this page. [Mark: 2]

4. Type your name, id, city, department and qualification. [Marks: 3]

5. Format above data (mentioned in point-4) according to specifications given below:

      [Marks: 3].

• Font: Impact
• Font size: 16
• Font style: Bold + Italic
• Alignment: Center 
• Bulleted

GOOD LUCK

Download form vulms