COMPUTER SCIENCE (PRACTICAL)

HSSC (Part-II) 1st A / 2025 — Complete Excel Questions with Source Data Tables

GROUP — 01: Currency Conversion Sheet

QUESTION PROMPT & DATA TABLE:

Prepare the following sheet, calculate the Amount in Pak Rupee, and draw a chart.

Country Currency Name Price in Pak Rs Total Foreign Amount in Pak Rupee

USA Dollar 278 540 [Calculate]

UK Pound 350 120 [Calculate]

KSA Riyal 75 2500 [Calculate]

Canada C Dollar 210 400 [Calculate]

Step-by-Step Solution Guide:

• Create the layout by entering headers in row 2: Country (A2), Currency Name (B2), Price in Pak
Rs (C2), Total Foreign (D2), and Amount in Pak Rupee (E2), then input the dataset.
• Click on cell E3 to determine the converted currency exchange value for the first row.
• Enter the multiplication formula to calculate the absolute price: =C3*D3
• Press Enter and use the Fill Handle feature to drag the cell down from E3 to E6.
• Select your complete finalized data region ranging from cell A2 down to E6.
• Navigate over to the Insert tab panel ribbon, find the Charts toolbox group, and click on Column Chart.

Computer Science (Practical) - Excel Solutions Guide with Tables 1

 GROUP — 02: [Link] Sheet

QUESTION PROMPT & DATA TABLE:

Calculate the Total points of ICS, BCS, and MCS. Apply nested conditions for Remarks: Total>=30
"Excellent", Total>=20 "Very Good", Total>=10 "Good".

Dated ICS BCS MCS Total Remarks

12/1/24 12 10 15 [Calculate] [Calculate]

15/1/24 15 11 10 [Calculate] [Calculate]

18/1/24 5 8 6 [Calculate] [Calculate]

20/1/24 10 4 10 [Calculate] [Calculate]

22/1/24 9 6 12 [Calculate] [Calculate]

Step-by-Step Solution Guide:

• Set up data rows according to column headers: Dated (A2), ICS (B2), BCS (C2), MCS (D2), Total (E2),
and Remarks (F2).
• Click on cell E3 to evaluate the aggregated point metrics across all course streams.
• Enter the summation function range formula: =SUM(B3:D3)
• Press Enter and pull down the edge fill crosshair downward to fill rows E4 through E7.
• Select cell F3 to construct the performance conditional remark rating output.
• Input the nested dynamic statement formula criteria: =IF(E3>=30, "Excellent", IF(E3>=20, "Very
Good", IF(E3>=10, "Good", ""))) and drag it down to F7.

Computer Science (Practical) - Excel Solutions Guide with Tables 2

 GROUP — 03: Student Data Sheet

QUESTION PROMPT & DATA TABLE:

Apply borders around the sheet. Compute the Total marks where Total = 1st Year + 2nd Year.

Name 1st Year 2nd Year Total

Kazmi 350 410 [Calculate]

Najma 410 390 [Calculate]

Mohsin 290 310 [Calculate]

Sulman 380 400 [Calculate]

Step-by-Step Solution Guide:

• Replicate the core target matrix with headers: Name (A2), 1st Year (B2), 2nd Year (C2), and Total
(D2).
• Highlight the complete block selection scope stretching across table coordinates A1 to D6.
• Go to the Home ribbon tab area, locate the font style borders grid dropdown tool, and select All Borders.
• Select the first blank summary calculation destination cell at coordinate location D3.
• Type out the mathematical formula string addition operation: =B3+C3
• Execute the line entry using the Enter button, then slide the cell corner handle down over column cells D4
to D6.

Computer Science (Practical) - Excel Solutions Guide with Tables 3

 GROUP — 04: Institute of Professional Studies Payroll

QUESTION PROMPT & DATA TABLE:

Calculate M-Alnce @15% of B-Pay, H-Rent @6.3% of B-Pay, and Net Pay = B-Pay + H-Rent + M-Alnce.

Sr # Name Desig B-Pay M-Alnce H-Rent Net Pay

1 Ali Manager 75000 [Calculate] [Calculate] [Calculate]

2 Saad Asst. Mgr 55000 [Calculate] [Calculate] [Calculate]

3 Komail Officer 35000 [Calculate] [Calculate] [Calculate]

4 Zain Clerk 22000 [Calculate] [Calculate] [Calculate]

Step-by-Step Solution Guide:

• Populate columns: Sr # (A2), Name (B2), Desig (C2), B-Pay (D2), M-Alnce (E2), H-Rent (F2), and Net
Pay (G2).
• Click inside column cell field E3 to process the Medical Allowance calculation factor rule.
• Write the percentage allocation formula expression: =D3*15% and extend it down to row 6.
• Switch to cell F3 and enter the House Rent deduction allocation formula: =D3*6.3% then drag down to
row 6.
• Select the final earnings column cell index location G3.
• Incorporate the gross net sum formula statement line: =D3+E3+F3 and drag down to G6.

Computer Science (Practical) - Excel Solutions Guide with Tables 4

 GROUP — 05: Company Balance Sheet

QUESTION PROMPT & DATA TABLE:

Calculate Balance (Revenue - Expenditure). In Remarks, write "Profit" or "Loss" based on balance
value. Draw a bar chart.

Year Revenue Expenditure Balance Remarks

2018-19 540000 420000 [Calculate] [Calculate]

2019-20 610000 500000 [Calculate] [Calculate]

2020-21 480000 520000 [Calculate] [Calculate]

2021-22 720000 600000 [Calculate] [Calculate]

2022-23 850000 710000 [Calculate] [Calculate]

2023-24 920000 860000 [Calculate] [Calculate]

Step-by-Step Solution Guide:

• Enter headers in row 2: Year (A2), Revenue (B2), Expenditure (C2), Balance (D2), and Remarks
(E2).
• Select calculation box cell D3 to evaluate net balance revenue performance margin levels.
• Apply the direct fiscal subtraction calculation formula: =B3-C3 and extend down to D8.
• Select cell E3 to populate explicit financial status context tags.
• Input the logical text branch evaluation condition formula expression:
=IF(D3>=0, "Profit", "Loss") and drag down to E8.
• Highlight columns Year and Balance together, open Insert tab panel, and select Bar Chart.

Computer Science (Practical) - Excel Solutions Guide with Tables 5

 GROUP — 06: Victoria Shopping Mall Invoice

QUESTION PROMPT & DATA TABLE:

Calculate T. Sale Price = Item 1 + Item 2. Apply a 4% Discount on T. Sale Price. Payable amount = T.
Sale Price - Discount.

Name Item 1 Item 2 T. Sale Price Discount @4% Payable amount

Asif 1200 800 [Calculate] [Calculate] [Calculate]

Bilal 3400 1500 [Calculate] [Calculate] [Calculate]

Kashif 950 450 [Calculate] [Calculate] [Calculate]

Danish 2200 1800 [Calculate] [Calculate] [Calculate]

Step-by-Step Solution Guide:

• Build sheet headers: Name (A2), Item 1 (B2), Item 2 (C2), T. Sale Price (D2), Discount @4%
(E2), and Payable amount (F2).
• Navigate cursor focus straight onto row item cell D3 to initialize cumulative billing totals.
• Enter the combined product item value sum formula: =B3+C3 and fill down to D6.
• Select markdown discount target field cell E3 and write the percentage scale formula: =D3*4% then pull
down to E6.
• Move rightwards onto individual checkout index cell F3 to figure net invoice collections.
• Apply the basic offset adjustment subtraction formula format string: =D3-E3 and fill down to F6.

Computer Science (Practical) - Excel Solutions Guide with Tables 6

 GROUP — 07: Student Marks Sheet

QUESTION PROMPT & DATA TABLE:

Create a matching grid matrix. Input core marks, and calculate the Average Marks in column 5.

Student Marks Sheet

Roll No Average Marks
English Computer Maths

601 78 85 92 [Calculate]

602 65 74 80 [Calculate]

603 88 90 85 [Calculate]

Step-by-Step Solution Guide:

• Create the nested layout with a merged header Student Marks Sheet and column headers below.
• Populate the records manually with the listed Roll Numbers (601, 602, 603) and enter subject numbers.
• Move active selection view marker directly to the Average Marks column block cell position E4.
• Inscribe standard Excel arithmetic distribution range average formula code block: =AVERAGE(B4:D4)
• Hit Enter on your keyboard unit keyset to produce the calculation metric scalar value.
• Grab the right-hand corner corner marker bounds of cell E4, dragging it downwards to cover rows E5 and
E6.

Computer Science (Practical) - Excel Solutions Guide with Tables 7

 GROUP — 08: Vertical Employee Salary Slip Layout

QUESTION PROMPT & DATA TABLE:

Create a vertical salary slip structure and write a formula to calculate the Total Salary Payable.

Salary Slip Labels (Column A) Values (Column B)

Name of Employee: Muhammad Ahmed

Address: Islamabad

Designation: Senior Clerk

Basic Pay 45000

Ad-hoc Allowance 12000

GP Fund deduction 4500

Conveyance Allowance 5000

Total Salary Payable [Calculate]

Step-by-Step Solution Guide:

• Input labels vertically down column A (A1 to A8) and place matching sample metrics in column B adjacent
to them.
• Navigate selector cursor context square interface focus point directly onto target field cell index location
B8.
• Synthesize full calculation formula balancing baseline adjustments alongside component deduction fields:
=B4+B5+B7-B6
• Press the keyboard Enter command function key execute option tracking switch.
• Validate that the computed total output accurately balances net allowances against fund deductions.

Computer Science (Practical) - Excel Solutions Guide with Tables 8

 GROUP — 09: Value Formatting Actions Matrix

QUESTION PROMPT & DATA TABLE:

Perform specific number cell formatting operations on each raw numeric column as described.

Col 1 (Apply Col 2 (Increase Col 3 (Decrease Col 4 (Apply Percentage

Currency) Decimals) Decimals) %)

1250 45.2 12.8764 0.15

3400 78.15 5.4321 0.42

950 110.4 99.1235 0.08

5600 9.87 0.7654 0.85

Step-by-Step Solution Guide:

• Input the raw numeric unstructured matrix strings table data systematically across grid columns A, B, C,
and D.
• Highlight cell array coordinates A2:A5, right-click to launch formatting context panels, choose Currency,
and save changes.
• Highlight real number data cells B2:B5, locate the Number Style Panel icon collection, and click Increase
Decimal.
• Highlight target values within block bounds C2:C5, click the adjacent layout option tool named Decrease
Decimal.
• Select integers array sequence collection D2:D5, and click the direct Percent Style (%) shortcut toggle
switch button.

Computer Science (Practical) - Excel Solutions Guide with Tables 9

 GROUP — 10: Government Graduate College Payroll Sheet

QUESTION PROMPT & DATA TABLE:

Calculate the Net Pay of the employees (BASIC Pay + Medical Allowance + House Rent) and draw a
representative chart.

Sr. No. Name Designation BASIC Pay Medical Allowance House Rent Net Pay

1 Prof. Dr. Tariq Principal 185000 15000 45000 [Calculate]

2 Mrs. Ayesha Assoc. Prof 145000 12000 35000 [Calculate]

3 Mr. Shahzad Asst. Prof 95000 9000 25000 [Calculate]

4 Miss Zainab Lecturer 65000 7000 18000 [Calculate]

Step-by-Step Solution Guide:

• Transcribe column table array field tags: Sr. No. (A2), Name (B2), Designation (C2), BASIC Pay
(D2), Medical Allowance (E2), House Rent (F2), and Net Pay (G2).
• Click inside column calculation data row space coordinate position index marked G3.
• Assemble structural component sum formula adding baseline compensation blocks: =D3+E3+F3
• Press Enter and extend the active matrix crosshair box down over range elements G4 to G6.
• Highlight selection arrays listing individual worker Name rows side by side with calculated Net Pay values.
• Access the top utility navigation ribbon bar section marked Insert, open Charts, and select a Pie/Column
Chart.

Computer Science (Practical) - Excel Solutions Guide with Tables 10