University of the Punjab
BA/BSc. Part I Computer Science Practical
Group 3 – 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 Percentage Marks
Formula: = (C2/B2)*100
I dragged this formula from row 2 to row 6 to apply formula on all rows.
7. I wrote “Total” in A7 cell and make it Right Aligned by pressing “CTRL + R”.
8. I wrote a formula to calculate total of Max Marks in Cell B7
Formula: =SUM(B2:B6)
9. I wrote a formula to calculate total of Obtained Marks in Cell C7
Formula: =SUM(C2:C6)
10. I pressed Ctrl + S to save the sheet and give the file name “Result Card”.
Question No 02:
Program:
Private Sub Command1_click()
Dim Price As Integer
Price = InputBox(“Enter Current Price”, “Input” , 0)
Price = Price * 1.05
Print “Price after 1 year = ”& Price
Price = Price * 1.04
Print “Price after 2 year = ”& Price
Price = Price * 1.06
Print “Price after 3 year = ”& Price
End Sub
Please Visit: www.risingeducation.com for more educational stuff.

Sports Injuries M.A Physical Education-2 Past Papers UOS 1-A2021
Go Back to Main Page More Papers

Sports Nutrition MA Physical Education UOS Past Paper 1-A2021
Go Back to Main Page More Papers

Measurement & Evaluation in P.ED MA Physical Education UOS Past Paper 1-A2021
Go Back to Main Page More Papers

Administration & Management MA Physical Education UOS Past Paper 1-A2021
Go Back to Main Page More Papers

Sports Medicine M.A Physical Education-2 UOS Past Paper 1-A2021
Go Back to Main Page More Papers

Bio-Mechanic MA Physical Education UOS Past Paper 1-A2021
Go Back to Main Page More Papers

Research Methodology in Physical Education MA Physical Education UOS Past Paper 1-A2021
Go Back to Main Page More Papers

Fluid Mechanics MSc Math Sargodha University Past Papers
Other Subjects MSc Math. Part 02

Computer Applications MSc Math Sargodha University Past Papers
Other Subjects MSc Math. Part 02