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 Python Programming Tutorials Best Computer Training Institute in Prayagraj (Allahabad) Online Exam Quiz O Level NIELIT Study material and Quiz Bank SSC Railway TET UPTET Question Bank career counselling in allahabad Best Website and Software Company in Allahabad Website development Company in Allahabad