Create a worksheet containing the payroll of a company as given in the

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 ___ ___ ___ ____ ____ ___ ___ _____ _____ ________.
___ _______ ___ ______ _____ ________ _____ ____ _______.
_______ _________ ______ ______ ____ ________ ___ ________ ____.
___ ________ _________ ____ __________ ____.
___ ____ __________ _____ ____ _________ ______ ___ _____ ________ _____.
____ _________ _____ __________ _______ ________ _________ ____ _______.
________ _________ __________ ____ ____ _____ _______ _______.
___ ___ __________ __________ ______ _______ ____ _________ _______.
__________ ________ ________ ____ ___.
___ ____ ________ _____ _______.
_________ _________ ______ _______ ___ __________ _______ _________ ______ _______ _______.
_________ ______ ________ ____ ___ ___ _____ ________.
______ _____ ______ _________ _______ _______.
________ _________ __________ _______ ___.
____ ______ ___ ________ ___ _________ _________ ____ ___ ____ _____ _______.
________ ___ _________ ______ ____ _____ _______ ________.
___ ________ ________ ____ ___ __________ ____.
_______ ________ _____ ______ _______ _______ _______ ________.
_______ ________ _______ _________ __________ ____ ____ ________ ____ ___.
____ _______ _______ _____ _____ ____ ________ ______.
_________ _________ ________ __________ ___ _______ ___ _______ ___ __________ ______.
______ ______ ________ ________ ____ __________ _______ ___ _______ ______ _________.
_______ ___ _________ ______ ______ ___ ______.
___ _____ ______ ___ _______ ____.
____ __________ _________ ____ _________ __________.
__________ ____ _______ _____ ___ _____ ________ ____.
______ ________ _______ _____ _________.
Get Full Answer on WhatsApp

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★