Skip to content
Question of 29

Q.(Question 9 — internal choice, attempt this

(OR)
the alternative) Write the formulas to prepare the Pay Roll of the employees in the table given below.
Spreadsheet (columns A, B, C, D, E, F, G, H, I):
Row 1: PAY ROLL
Row 2: Name | Basic Pay | DA (25% of BP) | HRA (15% of BP) | Gross Pay | PF (10% of BP) | GPF | Total Deductions | Net Pay
Row 3: Amit | 25000 | ? | ? | ? | ? | 2500 | ? | ?
Row 4: Sunita | 30000 | | | | | 3000 | |
Row 5: Rama | 50000 | | | | | 5000 | |
Row 6: Mohan | 60000 | | | | | 6000 | |
Row 7: Deepak | 70000 | | | | | 7000 | |
Punjab PsebPSEB Punjab Class 12 (Commerce) 2026Subjective· 6mImportance★★★★★
0% · 0/29 Questions
🔒 Locked · start free trial →

You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.

Start your 14-day free trial to unlock the full solution →

DA=B25%, HRA=B15%, Gross=B+DA+HRA, PF=B*10%, Total Ded=PF+GPF, Net=Gross-Total Ded.

Formulas for the Pay Roll (shown for row 3, Amit; copy down for rows 4-7):

C3 (DA = 25% of BP) = =B325% D3 (HRA = 15% of BP) = =B315%

E3 (Gross Pay) = =B3+C3+D3

F3 (PF = 10% of BP) = =B3*10%

G3 (GPF) = given value (2,500 for Amit)

H3 (Total Deductions) = =F3+G3

I3 (Net Pay) = =E3-H3

…

Unlock everything free for 14 days

  • Full step-by-step solutions
  • Concept-first explanations
  • Methods, shortcuts & mistakes
  • PYQ mapping + timed mock tests

Full access for 14 days. No credit card required.