Programming Examples
Create a worksheet employee with the following information
(a) Create a worksheet "employee" with the following information.
Name | Phone | Floor | Office | Dept | Design | Salary |
Neha | 5834 | 2 | 11 | Admin | PM | 8000 |
Sucheta | 2812 | 2 | 21 | Admin | CL | 9000 |
Amrit | 3477 | 1 | 17 | Mkt | CL | 10000 |
Arunesh | 6992 | 3 | 14 | Mkt | MM | 8500 |
Ashwin | 1538 | 3 | 12 | Mkt | SI | 5000 |
(b) To find floor in which there is no person whose name starts with A.
(c) To display name and office for the persons in office 11 and 14.
(d) To extract name and phone for the persons on the floor between 2 and 4.
(e) To extract name and office for persons of Admin department.
(f) To extract name and phone for the persons having salary more than 8000/-.
Output/ Explanation: