Programming Examples

Create worksheet for Employees Details and perform following operations


1. . Create the worksheet shown above and save the file with name “Employees_Detail”.

EMPLOYEE'S DATABASE
NAME DEPARTMENT DESIGNATION SALARY ADDRESS
JUHI  SBI BM 100000 LKO 
HARISH  LIC AD 80000 KANPUR 
ANANYA SBI RM 200000 BAREILLY 
GAURAV LIC MD 90000 LKO
KAJAL  FCI RM 200000 KANPUR
MAYANK LIC MD 80000 MEERUT 

Do the followings :

(a) Merge and center the Heading "EMPLOYEE'S DATABASE". Apply the cell style to Accent2.

b) Make the Column headings in BOLD format.

(c) Count the total no. of employees DEPARTMENT WISE.

(d) List the name of employees whose salary is greater than 120000

(e) Count the total no. of employees who have salary greater than 100000

(f) Sort the data DEPARTMENT wise in ascending order

(g) Generate a Column chart and Line chart to highlight employee name and their salary.

(h) Generate a Pie chart along the salary contribution by each DEPARTMENT

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