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 211Admin PM 8000
Sucheta 2812 221Admin CL 9000
Amrit 3477 117Mkt CL 10000
Arunesh 6992 314Mkt MM8500
Ashwin 1538 312Mkt SI5000

(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:

Latest Current Affairs 2024 Online Exam Quiz for One day Exam Online Typing Test CCC Online Test Python Programming Tutorials Best Computer Training Institute in Prayagraj (Allahabad) Online MBA 2 years Online MCA Online BCA Best Website and Software Company in Allahabad