Scribd
Upload
273 views2 pages

Excel

The document outlines the preparation of a Monthly Salary Sheet for employees in Excel, detailing calculations for House Rent Allowance (HRA), Dearness Allowance (DA), Gross Salary, Tax, Provident Fund, and Net Salary. It includes specific formulas for each calculation and provides multiple-choice questions to test understanding of these formulas. The focus is on percentage calculations and the use of Excel functions related to salary components.

Uploaded by

kdevkota657
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
273 views2 pages

Excel

The document outlines the preparation of a Monthly Salary Sheet for employees in Excel, detailing calculations for House Rent Allowance (HRA), Dearness Allowance (DA), Gross Salary, Tax, Provident Fund, and Net Salary. It includes specific formulas for each calculation and provides multiple-choice questions to test understanding of these formulas. The focus is on percentage calculations and the use of Excel functions related to salary components.

Uploaded by

kdevkota657
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Question:

You are working as an HR manager and need to prepare a Monthly Salary Sheet for employees
in Microsoft Excel. The table below contains employee details, including their Basic Salary,
Allowances, and Deductions.

Employee Basic HRA DA Other Gross Tax Provident Net


Name Salary (20%) (10%) Allowances Salary (10%) Fund (12%) Salary
John 40,000 ? ? 5,000 ? ? ? ?
Mary 35,000 ? ? 4,500 ? ? ? ?
Alex 50,000 ? ? 6,000 ? ? ? ?

Tasks:

1. Calculate House Rent Allowance (HRA) as 20% of the Basic Salary.


2. Calculate Dearness Allowance (DA) as 10% of the Basic Salary.
3. Calculate Gross Salary using the formula:
Gross Salary = Basic Salary + HRA + DA + Other Allowances
4. Deduct Tax (10% of Gross Salary) and Provident Fund (12% of Basic Salary).
5. Calculate Net Salary using the formula:
Net Salary = Gross Salary - (Tax + Provident Fund)

Multiple-Choice Questions:

1. Which of the following formulas correctly calculates HRA in cell C2?


a) =A2*0.2
b) =B2*0.2
c) =B2/20
d) =SUM(B2*20%)

Answer: b) =B2*0.2

2. What is the correct formula to find DA in cell D2?


a) =B2*10%
b) =B2*0.1
c) =B2/10
d) Both (a) and (b)

Answer: d) Both (a) and (b)

3. How can you calculate Gross Salary in cell F2?


a) =SUM(B2:E2)
b) =B2+C2+D2+E2
c) =B2+(B2*0.2)+(B2*0.1)+E2
d) All of the above

Answer: d) All of the above

4. Which formula should be used to calculate Tax (10% of Gross Salary) in G2?
a) =F2*0.1
b) =F2/10
c) =F2*10%
d) All of the above

Answer: d) All of the above

5. Which formula correctly calculates Provident Fund (12% of Basic Salary) in H2?
a) =B2*12%
b) =B2*0.12
c) =B2/12
d) Both (a) and (b)

Answer: d) Both (a) and (b)

6. How can you compute Net Salary in I2?


a) =F2-(G2+H2)
b) =F2-G2-H2
c) =F2- (F2*0.1) - (B2*0.12)
d) All of the above

Answer: d) All of the above

This question helps students practice percentage calculations, SUM, and IF functions in Excel
while understanding salary components. Let me know if you need further enhancements!

You might also like