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

CCC Online Test 2021 CCC Practice Test Hindi Python Programming Tutorials Best Computer Training Institute in Prayagraj (Allahabad) Best Java Training Institute in Prayagraj (Allahabad) Best Python Training Institute in Prayagraj (Allahabad) O Level Online Test in Hindi Bank SSC Railway TET UPTET Question Bank career counselling in allahabad Sarkari Naukari Notification Best Website and Software Company in Allahabad Sarkari Exam Quiz