Design the worksheet as shown and answer the following questions:
(vii) If the Total salary is greater than 13000, then display the message. "You are getting the highest salary".
SECTION 6: PROJECT WORK
SA
G
F
E3
E
Total Salary
D
HRA
TA
(vi) Employee getting the least salary must receive Rs. 500 as bonus. Find the Total Salary of this employee.
(i)
Calculate the DA of all the employees as 10% of their salary.
Calculate the TA of all the employees as 15% of their salary.
(iii) Calculate the HRA of all the employees as 25% of their salary.
(iv) Calculate the Total Salary as DA+TA+HRA.
(v) Find the maximum, minimum, and average salaries being dispensed by this company.
А
B.
1 Emp ID Name
2 10488149 Ayush
3
10488167 Simram
10488151 Geetli
5
10488142 Mitali
6 10488175 Aarush
C С
Salary
DA
11500
9600
10700
12750
11050
Answers
Answer:
Design the worksheet as shown and answer the following questions:
(vii) If the Total salary is greater than 13000, then display the message. "You are getting the highest salary".
SECTION 6: PROJECT WORK
SA
G
F
E3
E
Total Salary
D
HRA
TA
(vi) Employee getting the least salary must receive Rs. 500 as bonus. Find the Total Salary of this employee.
(i)
Calculate the DA of all the employees as 10% of their salary.
Calculate the TA of all the employees as 15% of their salary.
(iii) Calculate the HRA of all the employees as 25% of their salary.
(iv) Calculate the Total Salary as DA+TA+HRA.
(v) Find the maximum, minimum, and average salaries being dispensed by this company.
А
B.
1 Emp ID Name
2 10488149 Ayush
3
10488167 Simram
10488151 Geetli
5
10488142 Mitali
6 10488175 Aarush
C С
Salary
DA
11500
9600
10700
12750
11050
Explanation:
Design the worksheet as shown and answer the following questions:
(vii) If the Total salary is greater than 13000, then display the message. "You are getting the highest salary".
SECTION 6: PROJECT WORK
SA
G
F
E3
E
Total Salary
D
HRA
TA
(vi) Employee getting the least salary must receive Rs. 500 as bonus. Find the Total Salary of this employee.
(i)
Calculate the DA of all the employees as 10% of their salary.
Calculate the TA of all the employees as 15% of their salary.
(iii) Calculate the HRA of all the employees as 25% of their salary.
(iv) Calculate the Total Salary as DA+TA+HRA.
(v) Find the maximum, minimum, and average salaries being dispensed by this company.
А
B.
1 Emp ID Name
2 10488149 Ayush
3
10488167 Simram
10488151 Geetli
5
10488142 Mitali
6 10488175 Aarush
C С
Salary
DA
11500
9600
10700
12750
11050