Question

Write commands for the operations (i) – (ii) based upon the spreadsheet shown
below :
A
B
С C
D
E
G
Н
Basic
(Monthly)
(Rs.)
HRA
(%of Basic)
DA
(Rs.)
Name
TotalSalary
(2017)
Total
(Salary)
(2018)
Bonus
(Rs.)
%
Increase
1
5000
10
450
2.
Shirome
54601200
200
6000
800
15
3
Somya
1800
12
900
7000
4
Tanya
1700
500
10
4000
usio
5.
Aziz
1500
700
12
8000
6
Arjun
2000
1000
12
9000
7
Kushagra​

Answer 1

Answer:

Write commands for the operations (i) – (ii) based upon the spreadsheet shown

below :

A

B

С C

D

E

G

Н

Basic

(Monthly)

(Rs.)

HRA

(%of Basic)

DA

(Rs.)

Name

TotalSalary

(2017)

Total

(Salary)

(2018)

Bonus

(Rs.)

%

Increase

1

5000

10