Question

Question 30 - 5 Marks
Non
Tarıq Fashions maintain their employee salary details in a
spreadsheet as shown below. A sample data of 7 employees is
shown below. Write formulas for the operations (1) to (v) and answer
the questions (vi) to (v11) based on the spreadsheet given below
along with the relevant cell address:
D
E
11
NAME
PF
NET SALARY
BASIC THRA - DA
150000 20000
2
Surender
000
Kanika
66000 20000
000
4.
Aashish
36000
15000
400
4500D
125000
8
30000
30000
700
Harjit
Abhin
wydi
Anto
17
30000
700
75000
2500D
10000
100
9
Maximum
10
No Or Employec
1. To calculate the DA as 25% of BASIC HRA for each
employee and display in column D
2. To calculate the NETSALARY AS BASIC-HRA-DA-PF for
each employee and display in column F
3. To find the maximum NETSALARY and display in cell F9
4. To count the number of employees and display in cell B10
The manager realizes that he has forgotten to add the S No
Column in the above spreadsheet. Which feature will help
him automate the typing of sequential numbers
Type here to search​

Answer 1

Answer:

two and a half litre of paint used to cover 725 Sq m of a area.how much are in sq m can be covered by 4.75 litre of paint