Algorithm for Employee Table with Payroll

Algorithm

1. Start
2. Click on Start Button à All Programs à MS Office à MS-Word
3. A new Blank document is opened, Click on Table à Insert à Table and type 5 columns and 5 rows and an empty table appears on the document
4. Type in the cells proper headings as given and appropriate information in the rows correspondingly for the columns : Employee Name, Basic Salary, D.A. and H.R.A.
5. Calculate Total Salary using the Formula option in the Table menu and enter in each row properly the cell references
6. For example in the 2^nd row of the table for total salary column type as, =sum(b2:d2) in formula box under formula which is already opened in step (5)
7. Repeat step (6) by copying and selecting Update Field option in the right click menu of each copied entry
8. And likewise, calculate the grand total salary of all the rows
9. Similarly, by using the min() and max() functions through formula option, separately find Lowest salary and Highest salary receiving employees and place it at last
10. Copy the entire table to other place and use Table à Sort option to sort the data based on the name of the employee by clicking proper options on the wizard, and the table with sorted list of employees is ready
11. Save the document with appropriate name and Close it
12. Stop