CLASS 9 Chapter 10 Spreadsheet Tool: OpenOffice Calc

(a) To calculate the DA as 25 % of BASIC+HRA for each employee and display in column D. (b) To calculate the NET SALARY as BASIC+HRA+DA–PF for each employee and display in column F. (c) To find the maximum NET SALARY and display in cell F9. (d) The manager wants to know how many employees from the above data are eligible for bonus. ................
................