Question

5. Zodiac Fashions maintains their employee salary details in a spreadsheet as shown
below. A sample data of 7 employees is shown below. Write steps for the
operations (0) to (V) based on the spreadsheet given below along with the relative
cell address
SALARY
NAME
Surinder
Kanika
ASK HRADA
50000 20000
56000 20000
35000 15000
5000 15000
60000 25000
75000 30000
25000 10000
400
600
200
700
700
300
Abhije
Jyoti
Amis
19 Maximum
No. of
Imp
1. To calculate the DA as 25% of BASIC+HRA for each employee and display in
column D.
ii. To calculate the NETSALARY as BASIC+DA+HRA+PF for each employee and
display in column F.
iii. To find the maximum NETSALARY and display in cell F9.
iv. To count the number of employees and display in cell B10.
v. To calculate the Average NETSALARY and display in cell F10.​

Answer 1

Answer:

to calculate DA as 25% of