[go: up one dir, main page]
Scribd
Upload
17 views8 pages

Excel Practice With Answers

The document contains employee data including their ID, name, department, city, salary, score, result, and bonus. It summarizes performance results with pass/fail outcomes and includes departmental salary averages and percentages. Additionally, it lists employee names alongside their salaries and bonuses.

Uploaded by

Sanika Narvekar
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
17 views8 pages

Excel Practice With Answers

The document contains employee data including their ID, name, department, city, salary, score, result, and bonus. It summarizes performance results with pass/fail outcomes and includes departmental salary averages and percentages. Additionally, it lists employee names alongside their salaries and bonuses.

Uploaded by

Sanika Narvekar
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/ 8

EmpID Name Dept City Salary Score Result Bonus

101 Amit Sales Pune 22000 55 Pass 2200


102 Bhavna HR Mumbai 25000 48 Fail 2500
103 Chirag Sales Pune 27000 62 Pass 2700
104 Deepa IT Pune 30000 40 Fail 3000
105 Esha Finance Delhi 26000 73 Pass 2600
106 Farhan IT Pune 28000 51 Pass 2800
107 Gauri HR Mumbai 24000 67 Pass 2400
108 Harsh Sales Pune 32000 59 Pass 3200
109 Isha IT Pune 29000 64 Pass 2900
Dept Salary
Finance 26000
HR 24500
IT 29000
Sales 27000
EmpID Name Dept City Salary Score Result
108 Harsh Sales Pune 32000 59 Pass
104 Deepa IT Pune 30000 40 Fail
109 Isha IT Pune 29000 64 Pass
106 Farhan IT Pune 28000 51 Pass
103 Chirag Sales Pune 27000 62 Pass
105 Esha Finance Delhi 26000 73 Pass
102 Bhavna HR Mumbai 25000 48 Fail
107 Gauri HR Mumbai 24000 67 Pass
101 Amit Sales Pune 22000 55 Pass
EmpID Name Dept City Salary Score Result
101 Amit Sales Pune 22000 55 Pass
103 Chirag Sales Pune 27000 62 Pass
104 Deepa IT Pune 30000 40 Fail
106 Farhan IT Pune 28000 51 Pass
108 Harsh Sales Pune 32000 59 Pass
109 Isha IT Pune 29000 64 Pass
EmpID Name Dept City Salary Score Result
103 Chirag Sales Pune 27000 62 Pass
104 Deepa IT Pune 30000 40 Fail
105 Esha Finance Delhi 26000 73 Pass
106 Farhan IT Pune 28000 51 Pass
108 Harsh Sales Pune 32000 59 Pass
109 Isha IT Pune 29000 64 Pass
Dept Percentage
Sales 33.33333
IT 33.33333
HR 22.22222
Finance 11.11111
Dept Options
Finance
HR
IT
Sales
Name Salary Bonus
Amit 22000 2200
Bhavna 25000 2500
Chirag 27000 2700
Deepa 30000 3000
Esha 26000 2600
Farhan 28000 2800
Gauri 24000 2400
Harsh 32000 3200
Isha 29000 2900

You might also like