Question

26. Write commands for the operation given below based upon the spre
A
D
E
С
B
Bonus
NETSALARY
1
NAME
DA(Rs)
BASIC(Monthly)(Rs.)
HRA(%ofBasic)
Surinder
2
5000
10
450
600
3
5600
800
Kanika
13
600
4
3500
Aashish
15
400
900
5
4500
500
Harjit
15
500
6
Abhijit
6000
700
20
400
7500
7 Jyoti
12
500
700
8
2500
Amita
10
300
700
9
Maximum
10 No. of Emp
li) To calculate the net salary as sum of Basic, HRA and DA for each employee.
2
(ii) To find the maximum NETSALARY and display in cell F9.
17
(iii) To count the number of employees and display in cell B10.
1%
(iv) The manager wants to graphically represent a comparative analysis of the salaries of
employees. Suggest the most suitable chart type for achieving the same.
1
-000-​

Answer 1

Answer:

very hard answer writing what I cannot give