[go: up one dir, main page]
Scribd
Upload
48 views2 pages

Excel Assignment 2

The document outlines various tasks related to visualizing employee salary data, including creating different types of charts such as column, bar, pie, line, and histogram. Each task specifies the need for descriptive titles, axes labels, and trendlines to analyze salary distributions and trends by department and employee. The goal is to effectively represent and interpret the salary information of employees across different departments.

Uploaded by

Anil verma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
48 views2 pages

Excel Assignment 2

The document outlines various tasks related to visualizing employee salary data, including creating different types of charts such as column, bar, pie, line, and histogram. Each task specifies the need for descriptive titles, axes labels, and trendlines to analyze salary distributions and trends by department and employee. The goal is to effectively represent and interpret the salary information of employees across different departments.

Uploaded by

Anil verma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Employee Records

B C D E
4 Employee ID Employee Name Department Salary (INR)
5 E001 Aditya Operations 1299354
6 E003 Meena HR 1067018
7 E005 Rahul IT 502212
8 E006 Monika Finance 318367
9 E007 Pallavi Marketing 397724

Q1 Create a column chart to display the salaries of employees by their respective departments and add descriptiv

Q2 Construct a bar chart to compare the salaries of all employees and Add descriptive axes Title "Employee IDs"

Q3 Use a pie chart to show the proportion of total salary contributed by each department and place the Legend i

Q4 Create a line chart to illustrate the trend of salaries based on Employee IDs and department and change the c

Q5 Plot a histogram to represent the distribution of salaries among employees.

Q6 Add a linear trendline to a line chart showing salary trends to identify overall growth or decline.

Q7 Use a column chart to display salaries by department and add a Exponential trendline to estimate future salar

Q8 Plot a bar chart for employee salaries and add a moving average trendline to smooth fluctuations.

Q9 Add a forecast trendline to a line chart predicting future salaries based on current data.
artments and add descriptive chart title "Salaries of Employees Departmentwise (INR)"

e axes Title "Employee IDs" to Y axis and add Title "Salaries of Employees" to X axis

ment and place the Legend in right position or Left

partment and change the colour with different style

wth or decline.

line to estimate future salary trends in each department.

oth fluctuations.

You might also like