create worksheet for Employees Details and perform following operations

Programming Example

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

Solution


							
Output

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