Mr.Anil Kumar a plus two commerce student entered the following details in a worksheet of Libre Office Calc.
|
A |
B |
C |
D |
E |
F |
G |
H |
| 1 |
Pay Roll |
| 2 |
Name |
BP |
DA (15% of BP) |
HRA (5% of BP) |
HTA (2% of BP) |
Gross pay |
PF (10% of BP) |
Net pay |
| 3 |
Mahesh |
15000 |
|
|
|
|
|
|
| 4 |
Venu |
24000 |
|
|
|
|
|
|
| 5 |
Reshmi |
22000 |
|
|
|
|
|
|
| 6 |
Rathi |
14500 |
|
|
|
|
|
|
| 7 |
Eliash |
18000 |
|
|
|
|
|
|
But, he faces some difficulty in completing the task. Can you help him by giving necessary commands or formula for filling the bank columns in the given spread sheet.
