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