The column headings of payroll to be prepared through Libre Office Cal

1.	The column headings of payroll to be prepared through Libre Office Calc is given below.CellA1B1C1D1E1F1G1ContentNameBPDA (20% of BP)HRA(5% of BP)Gross payTDS (10% of GP)Net pay1. 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.
Answer» 1. DA → C2 =B2 * 20% HRA → D2 = B2 * 5% GP → E2 = B2 + C2+ D2 TDS → F2 = E2 * 10% NP → G2 = E2 – F2 2. Fill the calculation for the remaining ‘10’ employees in the rm.

The column headings of payroll to be prepared through Libre Office Calc is given below.CellA1B1C1D1E1F1G1ContentNameBPDA (20% of BP)HRA(5% of BP)Gross payTDS (10% of GP)Net pay1. 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.

Answer»

1. DA → C2 =B2 * 20%

HRA → D2 = B2 * 5%

GP → E2 = B2 + C2+ D2

TDS → F2 = E2 * 10%

NP → G2 = E2 – F2

2. Fill the calculation for the remaining ‘10’ employees in the rm.