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.
Answer :
Word Count : 272
___ ________ __________ ____ _________.
_________ __________ __________ ________ ______ ________ _________.
__________ _________ ______ ________ ______ __________ _______.
__________ _______ _____ _____ ________.
______ _________ ________ ______ ___ __________ _______ ______ ____ ________ ________.
______ _____ _________ _______ ______.
______ ______ ________ __________ _________ __________ ________.
_______ _________ ________ _______ ______ __________ ___ ______ ____.
_____ ________ ____ _____ ______ _____ _________ ________ ____ ___ __________ __________.
_____ _________ _______ _______ __________ ___ _________ ____ ____ ___.
_______ _________ ______ _______ ___ _______ ____ ________ __________ ________.
________ ____ _________ ___ ________ _________ ___ ____.
__________ _________ _____ __________ ______ __________ ________.
__________ _______ __________ ________ ________ _______ _________ ___ ___ _______ _____ ____.
______ _____ ______ _____ _____.
____ _____ _________ ___ ________ ____ ______.
__________ __________ _________ ____ _________ ________ ________ ___ __________ _____ _________ _____.
___ ________ _____ __________ _________ ___ _____.
__________ _______ ___ _____ _____ __________ _________ __________ ___ ___.
Skip in 10
| 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
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.