University of the Punjab
BA/BSc. Part I Computer Science Practical
Group 8 – Annual-2019 Solution
Download Original Papers From:
https://educationhub.pk/pu-ba-bsc-practical-papers-third-year/
Question No 01:
MS Excel
Procedure:
1. I clicked on Start Button and point to the All Programs. All installed programs list appeared.
2. I pointed to the MS Office Folder and click on MS Excel. MS Excel Program opened.
3. I click on Office Button and take new Sheet.
4. I pressed Ctrl + S to save the sheet and give the file name “Result”.
5. Entered data into sheet as given in the question.
6. I clicked on home tab and home ribbon appeared.
7. I selected the first row and applied shade from home ribbon.
8. In options list I clicked on sort Z to A to sort data in descending order.
9. I wrote a formula to display status as Pass or Fail.
Formula: = IF(B2>=50,”Pass”,”Fail”)
10. I wrote a formula to count no of Pass Students
Formula: =COUNTIF(C2:C6,”Pass”)
11. I wrote a formula to count no of Fail Students3.
Formula: =COUNTIF(C2:C6,”Fail”)
12. I Press Ctrl +S To save file
Question No 02:
Program:
Private Sub Command1_click()
End Sub
