The column headings of payroll to be prepared through Libre Office Calc is given below.
| Cell |
A1 |
B1 |
C1 |
D1 |
E1 |
F1 |
G1 |
| Content |
Name |
BP |
DA (20% of BP) |
HRA(5% of BP) |
Gross pay |
TDS (10% of GP) |
Net pay |
1. Write the formula to calculate DA, HRA, Gross pay, TDS and Net pay of Jexin Jose the rst employee, in the second row of the worksheet.
2. Give the command to ll the calculation automatically for the remaining ‘10’ employees in the rm.
