Question

Q10. Write commands for the operation (i) and (ii) based upon the spreadsheet shown below: (6)the spreadsheet shown below:
26. Write commands for the operations (0) - (ii) based upon the spreadsheet she
A
Basic
HRA.
(%of Basic)
DA
(Rs.)
TotalSalary
(1997)
Bonus
(Rs.)
Total
(Salary) (1998)
1
Name
(Monthly) (Rs.)
Inc
Increase
450
10
1200
2
5000
Shirome
800
200
3
Somya
6000
1800
900
4
7000
Tanya
1700
500
5
4000
Aziz
700
8000
Arjun
1500
9000
Kushagra
2000
1000

i. To calculate the total salary as sum of Basic Salary, HRA and DA for each employee for the

year 2017

ii. To calculate the total salary of each employee for the year 2018 as sum of salary for year 2017

and bonus. Also calculate the percentage increase in the total salary from 2017 to 2018 for

each employee​

Answer 1

Answer:

in cell E2=(B2 +C2+D2)

Explanation:

sum ( )