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/ Explanation: