OAT-Record-02) Salary Table

 

Create a table with following columns and display the result in separate cells for the following

1.      Employee Name, Basic pay, DA, HRA, Total salary.

2.      Sort all the employees in ascending order with the name as the key

3.      Calculate the totals alary of the employee

4.      Calculate the Grand total salary of the employee

5.      Finding highest salary and

6.      Find lowest salary

Procedure:-

STEP 1: 

    Enter into MS-Word environment by choosing start àProgramsàMs OfficeàMS Word.

STEP 2: 

    Now save the opened Blank document with the following step Office Buttonàsaveàcreate a table

àGoto Insert Tab à selects a drag columns and rows (6X5).

STEP 3: 

    Enter required data in to cells of columns.

STEP 4: 

    The Top column select or drag all (1X6) àGoto Home Tab Center Alignment.

STEP 5: 

    Enter Employee Name and Basic Salary Payà

·         D.A is a take 10% for Basic payàGoto layout Tab àData formula (f_x) = (Basic Pay * 10%).

·         HRA is a take 20% for Basic payàGoto layout Tab àData formula (f_x) = (Basic Pay * 20%).

·         Total Salary Calculate àGoto layout Tab àData formula (f_x) =sum (left).

Note: - salary note the cell selects the cellsà Goto Home Tab Left Alignment.

STEP 7: 

    Press Ctrl+S or form the menu option click File-> Save.

STEP 8: 

    Press Alt+F4 or click Office Button-> Exit from menu to exit word.

OUTPUT: - 02

s.no.	Employee Name	Basic Pay	D.A (10%)	HRA (20%)	Total Salary
1	S.Kumar	20000	2000	4000	26000
2	B.Raju	35000	3500	7000	45500
3	K.Rani	40000	4000	8000	52000