ADS Computer Science-III PU Practical Solution Group-1 2018

University of the Punjab

BA/BSc.  Part I Computer Science Practical

Group 1 – 2018 Solution

Download Original Papers From:

Question No 01:

MS Excel


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:



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”


            Print “Invalid Number”

End If

End Sub


Please Visit: for more educational stuff.

Leave a Comment