ADS Computer Science-III PU Practical Solution Group-11 2019

University of the Punjab

BA/BSc.  Part I Computer Science Practical

Group 2 – 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.      Entered data into sheet as given in the question.

5.      I Selected Header Row and apply shade from home ribbon.

6.      I wrote a formula to calculate Monthly Salary

Formula: = B2*C2

I dragged this formula from row 2 to row 6 to apply formula on all rows.

7.      I selected Cell A7 , B7 ,C7 and clicked on Merge and Center.  I wrote “Total” in new cell and make it Right Aligned by pressing “CTRL + R”.

8.      I wrote a formula to calculate total in Cell D7

Formula: =SUM(D2:D6)

9.      I pressed Ctrl + S to save the sheet and give the file name “Monthly Salary Sheet”.

Question No 02:

Program:

Private Sub Command1_click()

Dim no As Integer, Largest As Integer, Smallest As Integer , Sum As Integer

no = InputBox(“Enter a number”,”Input” , 0)

Largest  = no;

Smallest = no;

Sum = 0

While no < > 0

Sum = Sum + no

If no > Largest Then

            Largest = no

End If

If no < Smallest Then

            Smallest = no

End If

no = InputBox(“Enter a number”,”Input” , 0)

Wend

Print “Sum of All Values = ”& Sum

Print “Largest Value = “&Largest

Print “Smallest Value = “ &Smallest

End Sub

Please Visit: www.risingeducation.com for more educational stuff.