Question

Create a worksheet containing the payroll of a company as given in the following table:
 

Employee Name Basic Salary (B) Dearness Allowance (DA) (30% of B Total Gross Salary (G) Income Tax (IT) (25% of G) PF (10% of G) Net Salary (N)
Raman 50000          
Mohit 65000          
Siraj 60000          
David 50000          
Phillip 45000          
Roger 30000          

 

You must enter all the labels and details as given above. You may use the following formulae:

 

DA = 30% of B

 

G = B + DA

 

IT = 25% of G

 

PF = 10% of G

 

N = B + DA IT PF

 

Write the sequence of steps that you have performed to create the formulae in different cells. Also attach printout OR a file (may be in pdf format) containing the worksheet.

12 May 2025
Answer :
Word Count : 272
| Employee Name | Basic Salary (B) | Dearness Allowance (DA) | Total Gross Salary (G) | Income Tax (IT) | PF | Net Salary (N) | | ------------- | ---------------- | ----------------------- | ---------------------- | --------------- | ---- | -------------- | | Raman | 50000 | 15000 | 65000 | 16250 | 6500 | 42250 | | Mohit | 65000 | 19500 | 84500 | 21125 | 8450 | 54925 | | Siraj | 60000 | 18000 | 78000 | 19500 | 7800 | 50700 | | David | 50000 | 15000 | 65000 | 16250 | 6500 | 42250 | | Phillip | 45000 | 13500 |
___ ___ _____ ________ _____ ______ ___.
___ ________ __________ ____ _________.
_________ __________ __________ ________ ______ ________ _________.
__________ _________ ______ ________ ______ __________ _______.
__________ _______ _____ _____ ________.
______ _________ ________ ______ ___ __________ _______ ______ ____ ________ ________.
______ _____ _________ _______ ______.
______ ______ ________ __________ _________ __________ ________.
_______ _________ ________ _______ ______ __________ ___ ______ ____.
_____ ________ ____ _____ ______ _____ _________ ________ ____ ___ __________ __________.
_____ _________ _______ _______ __________ ___ _________ ____ ____ ___.
_______ _________ ______ _______ ___ _______ ____ ________ __________ ________.
________ ____ _________ ___ ________ _________ ___ ____.
__________ _________ _____ __________ ______ __________ ________.
__________ _______ __________ ________ ________ _______ _________ ___ ___ _______ _____ ____.
______ _____ ______ _____ _____.
____ _____ _________ ___ ________ ____ ______.
__________ __________ _________ ____ _________ ________ ________ ___ __________ _____ _________ _____.
___ ________ _____ __________ _________ ___ _____.
__________ _______ ___ _____ _____ __________ _________ __________ ___ ___.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top
📞
Call Support Instant phone assistance IGNOU BCSL 13 2024 2025 - Create a worksheet containing the payroll of a company as given in the | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→