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★★★