Scribd
Upload
7 views4 pages

Excel Basic Exercises

The document provides an employee salary report listing employee IDs and names, along with a salary comparison chart. It details salaries by department, highlighting the highest and lowest salaries, bonuses, and overall salary statistics including total and average salaries. The highest salary recorded is $100,000 and the lowest is $49,000.

Uploaded by

tempm9813
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
7 views4 pages

Excel Basic Exercises

The document provides an employee salary report listing employee IDs and names, along with a salary comparison chart. It details salaries by department, highlighting the highest and lowest salaries, bonuses, and overall salary statistics including total and average salaries. The highest salary recorded is $100,000 and the lowest is $49,000.

Uploaded by

tempm9813
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

EMPLOYEE SALARY REPO

[Link] EMPLOYEE ID EMPLOYEE NAME


1 1001 YASIN
2 1002 HASSAN
3 1003 ADAM
4 1004 MUZZAMIL
5 1005 ADNAN
6 1006 WASSEM
7 1007 JUNAID
8 1008 MANZOOR
9 1009 FATIMA
10 1010 SANA
11 1011 AMAAN

EMPLOYEE SALARY COMPARISON


$120,000

$100,000

$80,000
SALARY

$60,000

$40,000

$20,000

$-
YASIN HASSAN ADAM MUZZAMIL ADNAN WASSEM JUNAID MANZOOR FATIM

EMPLOYEE NAME
YEE SALARY REPORT
DEPARTMENT SALARY STATUS BONUS
HR $ 90,000 HIGHEST SALARY 9000
FRONTEND $ 65,000 LOWEST SALARY 3250
BACKEND $ 55,500 LOWEST SALARY 2775
HR $ 81,000 HIGHEST SALARY 8100
HACKER $ 94,000 HIGHEST SALARY 9400
CA $ 55,000 LOWEST SALARY 2750
BACKEND $ 49,000 LOWEST SALARY 2450
HACKER $ 95,000 HIGHEST SALARY 9500
FORNTEND $ 67,000 LOWEST SALARY 3350
CA $ 68,700 LOWEST SALARY 3435
CEO $ 100,000 HIGHEST SALARY 10000

TOTAL SALARY ₹ 820,200


AVG SALARY ₹ 74,564
HIGHEST SALARY ₹ 100,000
LOWEST SALARY ₹ 49,000

MPARISON

JUNAID MANZOOR FATIMA SANA AMAAN

ME
EMPLOYEE SALARY REPO
[Link] EMPLOYEE ID EMPLOYEE NAME
1 1001 YASIN
2 1002 HASSAN
3 1003 ADAM
4 1004 MUZZAMIL
5 1005 ADNAN
6 1006 WASSEM
7 1007 JUNAID
8 1008 MANZOOR
9 1009 FATIMA
10 1010 SANA
11 1011 AMAAN

EMPLOYEE SALARY COMPARISON


$120,000

$100,000

$80,000
SALARY

$60,000

$40,000

$20,000

$-
YASIN HASSAN ADAM MUZZAMIL ADNAN WASSEM JUNAID MANZOOR FATIM

EMPLOYEE NAME
YEE SALARY REPORT
DEPARTMENT SALARY STATUS BONUS
HR $ 90,000 HIGHEST SALARY 9000
FRONTEND $ 65,000 LOWEST SALARY 3250
BACKEND $ 55,500 LOWEST SALARY 2775
HR $ 81,000 HIGHEST SALARY 8100
HACKER $ 94,000 HIGHEST SALARY 9400
CA $ 55,000 LOWEST SALARY 2750
BACKEND $ 49,000 LOWEST SALARY 2450
HACKER $ 95,000 HIGHEST SALARY 9500
FORNTEND $ 67,000 LOWEST SALARY 3350
CA $ 68,700 LOWEST SALARY 3435
CEO $ 100,000 HIGHEST SALARY 10000

TOTAL SALARY ₹ 820,200


AVG SALARY ₹ 74,564
HIGHEST SALARY ₹ 100,000
LOWEST SALARY ₹ 49,000

MPARISON

JUNAID MANZOOR FATIMA SANA AMAAN

ME

You might also like