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.
CHM-422 Basic Physical Chemistry BS Botany GCUF Past Papers
Past Papers Other Subjects BS Botany GCUF Semester 04 CHM-421
CHM-421 Basic Analytical Chemistry BS Botany GCUF Past Papers
Past Papers Other Subjects BS Botany GCUF Semester 03 CHM-421

Urdu 10th Class Lahore Board Past Paper Annual 2023 Group-1
Objective Type Paper Subjective Type Paper More Papers of This

Urdu 10th Class Lahore Board Past Paper Annual 2023 Group-2
Objective Type Paper Subjective Type Paper More Papers of This

Lahore Board Urdu 9th Class Past Paper Annual-2023 Group-1
Objective Type Paper Subjective Type Paper More Papers of This

Lahore Board Urdu 9th Class Past Paper Annual-2023 Group-2
Objective Type Paper Subjective Type Paper More Papers of This

Physics 10th Class Lahore Board Past Paper Annual 2023 Group-1
Objective Type Paper Subjective Type Paper More Papers of This

Physics 10th Class Lahore Board Past Paper Annual 2023 Group-2
Objective Type Paper Subjective Type Paper More Papers of This

Physics 9th Class Lahore Board Past Paper Annual-2023 Group-1
Objective Type Paper Subjective Type Paper More Papers of This

Physics 9th Class Lahore Board Past Paper Annual-2023 Group-2
Objective Type Paper Subjective Type Paper More Papers of This

Pakistan Studies 10th Class Lahore Board Past Paper Annual 2023 Group -1
Objective Type Paper Subjective Type Paper More Papers of This

Lahore Board 9th Class Pakistan Studies Past Paper Annual-2023 Group-1
Objective Type Paper Subjective Type Paper More Papers of This

Lahore Board 9th Class Pakistan Studies Past Paper Annual-2023 Group-2
Objective Type Paper Subjective Type Paper More Papers of This

Mathematics (Science) 10th Class Lahore Board Past Paper Annual 2023 Group-1
Objective Type Paper Subjective Type Paper More Papers of This

Mathematics (Science) 10th Class Lahore Board Past Paper Annual 2023 Group-2
Objective Type Paper Subjective Type Paper More Papers of This

Lahore Board 9th Class Mathematics Past Paper Annual 2023 Group-1
Objective Type Paper Subjective Type Paper More Papers of This

Lahore Board 9th Class Mathematics Past Paper Annual 2023 Group-2
Objective Type Paper Subjective Type Paper More Papers of This

Islamic Studies 10th Class Lahore Board Past Paper Annual 2023 Group-1
Objective Type Paper Subjective Type Paper More Papers of This

Islamic Studies 10th Class Lahore Board Past Paper Annual 2023 Group-2
Objective Type Paper Subjective Type Paper More Papers of This

Lahore Board 9th Class Islamiat Past Paper Annual-2023 Group-1
Objective Type Paper Subjective Type Paper More Papers of This

Lahore Board 9th Class Islamiat Past Paper Annual-2023 Group-2
Objective Type Paper Subjective Type Paper More Papers of This

Pakistan Studies 10th Class Lahore Board Past Paper Annual 2023 Group -2
Objective Type Paper Subjective Type Paper More Papers of This

English 10th Class Lahore Board Past Paper Annual 2023 Group-1
Objective Type Paper Subjective Type Paper More Papers of This

English 10th Class Lahore Board Past Paper Annual 2023 Group-2
Objective Type Paper Subjective Type Paper More Papers of This

Lahore Board English 9th Class Past Paper Annual 2023 Group-1
Objective Type Paper Subjective Type Paper More Papers of This