Please answer all the three questions given below
Attachments:
Answers
Answered by
1
Answer:
FORMULA
a) DA
1) =c2×10%
2) =c3×10%
3) =c4×10%
4) =c5×10%
5) =c6×10%
b) Total salary
1) =c2+d2
2) =c3+d3
3) =c4+d4
4) =c5+d5
5) =c6+d6
MAXIMUM
=max(c2:c6)
MINIMUM
=min(c2:c6)
AVERAGE
=average(c2:c6)
AMOUNTS
a) DA
1) 1150.00
2) 960.00
3) 1275.00
4) 1070.00
5) 1105.00
b) Total salary
1) 12650.00
2) 10560.00
3) 14025.00
4) 10700.00
5) 12155.00
MAXIMUM
12750
MINIMUM
9600
AVERAGE
11120
Similar questions