University of the Punjab
BA/BSc. Part I Computer Science Practical
Group 1 – 2018 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 data cells and point to the Sort & Filter icon in Editing group.
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()
Dim no As Integer
no = InputBox(“Enter a Number from 1 to 4”)
If no = 1 Then
Print “Winter”
Elseif no = 2 Then
Print “Spring”
Elseif no = 1 Then
Print “Summer”
Elseif no = 1 Then
Print “Autumn”
Else
Print “Invalid Number”
End If
End Sub
Please Visit: www.risingeducation.com for more educational stuff.
