Exercise:1

Emp Code Employee Name Depttname District

E101 Rahul Jain Police Hyderabad

E102 Namita Mishra Panchayat Raj Khammam

E103 Sanjana Paul Education Medak

E104 Abhishek Sharma Education Hyderabad

E105 Atul Parashar Police Medak
E106 Sandeep Goel Police Hyderabad
E107 Vivek Gupta Education Medak
E108 Ruchika Sarawat Panchayat Raj Khammam
E109 Sumit Narwankar Education Medak
E110 Parul Jain Panchayat Raj Hyderabad
E111 Rekha Kujur Police Warangal
E121 Azzu Police Warangal
E112 Rina Malik Education Medak
E113 Ulrica Paul Education Hyderabad
E114 Sucheta Ghosh Police Medak
E115 Debashree Basu Panchayat Raj Khammam
E116 Priyank Ahluwalia Police Hyderabad
E117 Sayantani Banerjee Education Medak
E118 Bikram Bansal Education Warangal

Exercise:2

150
Naveen

12
360
Madhu
 80
190
Nithin
523
253

count all numeric cells

count all cells except blank
count all blank cell
Count all text cells
DOJ Designation Salary
1/21/2001 Jr.Asst 2000

2/25/2001 Sr.Asst 31423 1. Sum of salaries of all the employees

10/8/2000 Supd 22511 2. Average salaries from all the employees

11/12/2000 Jr.Asst 23293 3. Sum of salaries of all the employees those w

4/21/2002 Supd 22762 Police 4. Sum of salaries of Education department onl

8/4/2002 Jr.Asst 19500 5. Sum of salaries of Jr.Assts only

9/8/2002 Sr.Asst 27043 6. Average salaries of district Medak

11/17/2002 Sr.Asst 26551 7. Maximum salary from all the employees

1/26/2003 Jr.Asst 17806 8. Minimum salary from all the employees

4/6/2003 Sr.Asst 24024 9.3rd Maximum salary from all the employees

8/24/2003 Supd 30100 10. 2nd Minimum salary from all the employee

8/24/2003 Jr.Asst 29800 11. Count the no. of employees from location H

9/28/2003 Jr.Asst 20817

1/11/2004 Supd 15483
2/15/2004 Sr.Asst 27233
4/25/2004 Jr.Asst 23478
7/4/2004 Sr.Asst 29752
9/12/2004 Jr.Asst 19771
10/17/2004 Jr.Asst 25934

10
7
3
1. Sum of salaries of all the employees

2. Average salaries from all the employees

3. Sum of salaries of all the employees those who are drawing salary >25000

4. Sum of salaries of Education department only

5. Sum of salaries of Jr.Assts only

6. Average salaries of district Medak

7. Maximum salary from all the employees

8. Minimum salary from all the employees

9.3rd Maximum salary from all the employees

10. 2nd Minimum salary from all the employees

11. Count the no. of employees from location Hyderabad

Hyderabad 6
Large

Small
logical function
If
And
or
not
Exercise:3

Total Remark 200 >

216 < 200
125
112
236 150
235 Syntax
215 Arguments
166
80
Exercise:4 23

Product Rate Discount

Pens 900
Notepads 1500
Files 1780
Markers 800
Manager 1200
Acc 980

Exercise:5
 Emp code Salary Tax(Nested IF) Tax(IFS)
1 6399
2 33362
3 17505
4 35675
5 47233
6 20538
7 35169
8 17779
9 12705

Exercise -6

Ecode Basic Increment

1 12000
2 56000
3 23000
4 66000
5 8000

Exercise-7

Ecode Desg Salary Tax-1

A1 Manager 33000 10.00%
A2 Acc 54000 5.00%
A3 Officer 18000 10.00%
A4 Manager 60000 10.00%
A5 Officer 65000 10.00%
A6 Manager 22000 10.00%
A7 Acc 40000 5.00%
Over Budget

Within Budget

200 0 within Budget

Rules of the formula

TRUE

FALSE

calculate discount as below:

if rate is >=1000 then discount will be 6%
otherwise discount is 2%
 calculate tax:
Tax will be Deducted
Tax will be Deducted
Tax will be Deducted
Tax will be Deducted
Tax will be Deducted

Ascending
Descending

calculate increment as follow

1- 10% increment in basic if basic
is >50000
2- 20% increment in basic if basic
is >10000
3- else 30% increment

Tax-2
Task-1

Task-2
thin Budget
x will be Deducted 15% if Salary >=35000
x will be Deducted 12% if Salary >=25000
x will be Deducted 10% if Salary >=15000
x will be Deducted 8% if Salary >=10000
x will be Deducted 5% if Salary <10000

cending
scending

calculate tax
10% if salary is >=50000 and Desg is
Manager otherwise 5%
10% if salary is >=50000 or Desg is Acc otherwise 5%

Manager,Officer

10%

5%
 AND OR

T T T T T
T F F T F

F T F F T

F F F F F
T
T

F
Exercise:8 Conditional Formatting 500

EmpCode EmpName Gender Designation District DOJ Salary

E001 Yogesh Karwa Male Manager Adilabad 30-Jul-00 62000

E002 Gaurav Keshari Male Manager Hyderabad 17-Dec-00 13724
E003 M.V.Krishna Murthy Male Asst Manager Medak 21-Jan-01 45432
E004 Radhika Male Asst Manager Adilabad 25-Feb-01 15724
E005 M Khaja Moinuddin Male Jr.Associate Medak 1-Apr-01 45433
E006 Naveen Chadra Madap Male Jr.Associate Hyderabad 6-May-01 65253
E007 S Kanaka Durga Female Sr.Associate Adilabad 10-Jun-01 67563
E008 BalaSubrahmanyam Nanduri Male Sr.Associate Medak 15-Jul-01 76332
E009 V Srikantha Reddy Male Manager Adilabad 3-Sep-00 56532
E010 N.G Naresh Male Asst Manager Hyderabad 8-Oct-00 12124
E011 Susma Kranthi Patale Female Asst Manager Hyderabad 12-Nov-00 76754
E012 M Lakshmi Priya Female Manager Adilabad 19-Aug-01 67643
E013 K Amarnath Male Jr.Associate Medak 23-Sep-01 24724
E014 Inayath Ulla Khan Male Sr.Associate Adilabad 28-Oct-01 78564
E015 AnbuKumar B Male Sr.Associate Medak 2-Dec-01 26724
E016 Swetha Mandal Female Jr.Associate Hyderabad 6-Jan-02 27724
E017 Vijay Kumar D Hegde Male Jr.Associate Hyderabad 10-Feb-02 28724
E018 N.G Naresh Male Sr.Associate Medak 17-Mar-02 29724
E019 Dasari Ratna Kishore Male Asst Manager Adilabad 21-Apr-02 30724
E020 Radhika Female Sr.Associate Hyderabad 26-May-02 31724
>800

Questions
1) Highlight whose salary is > 65000 with light green color
2) Highlight whose salary is between 50000 to 65000 with yellow color
3) Highlight whose salary is less then 25000 with orange color
4) Highlight district "Adilabad" with red color text
5) Highlight whose designation is Sr.Associate with light green color
6) Highlight the gender Female with Cell color "Purple" and text color "White"
7) Highlight Duplicate names with blue colour

If salary > 40000, Emp Name

Male

Text That Contains

Male Female
color "White"
Exercise : 9

References
A2 RELATIVE REF Cell A2 is not fixed
$A$2 ABSOLUTE REF Cell A2 is fixed
$A2 MIXED REF only col A is fixed, row is not fixed
A$2 MIXED REF only row 2 is fixed, col is not fixed

Increment

EmpID Name Dept Desig Salary Increment

E001 Naveen CT ASO 26527 2652.7 Absolute
E002 Praveen Revenue SO 15434 1543.4 Row freeze
E003 Meena Police Jr.Asst 27863 2786.3 column freeze
E004 Dinesh Agrl DEO 31254 3125.4 Relative
E005 Sam CT DEO 10589 1058.9
E006 Anuradha Revenue Jr.Asst 18584 1858.4
E007 Kiran Revenue DEO 20951 2095.1
E008 Neha Agrl Jr.Asst 16210 1621
E009 Usha CT ASO 15010 1501
E010 Radhika Police ASO 23029 2302.9
E011 Eshwar Police SO 23993 2399.3
E012 Ajay Revenue ASO 10667 1066.7
E013 Jaya Police DEO 13924 1392.4
E014 Ganesh CT Jr.Asst 10755 1075.5
E015 Sai CT SO 26414 2641.4
E016 Ganga Revenue SO 25840 2584
 Product Rate S.Pr-1 S.Pr-2 S.Pr-3
10.00% LCD
Printer
Projector

10% 20% 30%

Data Profit S.Pr-1 S.Pr-2 S.Pr-3

IOCL 10000
ONGC 20000
BPL 30000

10% 20% 30%

 Name of the Date of
S.No employee Joining Years of Service
1 Ramu 12/15/1990
2 Vijay 1/5/1999
3 Gopal 8/5/1990
4 Venkat 8/15/1990
5 Vani 11/16/1995
6 Kiran 12/26/2000
7 Meena 5/3/2000
8 Sam 1/10/1985
9 Sai 2/26/2000
10 Raju 1/3/2000
11 Pinky 1/10/2000
12 Priya 12/26/1982
13 Sanjay 1/3/2000
14 Srinivas 1/10/2000
15 Divya 12/26/2000
16 Rajesh 1/3/1990
17 Naveen 1/10/2000
18 Vinay 12/26/2000
19 Krishna 1/3/2000
20 Srikanth 1/10/1980
21 Vijay 12/26/2000
22 Lakshmi 1/3/1984
23 Sravani 1/10/2000
24 Divya 12/26/2000
25 Gopal 1/3/2000
26 Gopi 1/10/2000
27 Ramya 12/26/2000
28 Waseem 1/3/2000
29 Manish 1/10/2000
30 Arif 12/26/2000
31 Eshwar 1/3/2000
32 Manoj 1/10/2000
33 Rajeev 12/26/2000
34 Lokesh 1/3/2000
35 Madhan 1/10/2000
DATE MON YEAR

6/27/2023
 Age at Membership
Date of Age at
Client Name Date of Birth Membership Membership
Vinay Kumar 11/16/1946 7/9/1971
Sampath Kumar 8/10/1951 11/16/1991
Gopal 7/10/1958 4/3/1980
Vani 12/26/1962 1/25/1983
Aruna 5/3/1939 5/15/1970
Ravinder 10/27/1955 2/4/1981
Gopala chary 12/26/1942 12/20/1970
Nagesh 1/10/1964 3/6/1986
Kumar 12/26/1967 11/14/1989
Vanaja 1/3/1980 4/7/2006
Giridher 1/3/1930 10/17/1969
Latha 1/3/1966 5/1/2000
Sowmya 1/10/1967 9/9/2005
Sanjay 1/10/1971 6/18/2000
Sam 1/3/1978 8/3/2002
Tina 3/24/1990 4/15/2011
Uma 12/26/1959 8/7/1990
Anuradha 1/3/1957 5/19/1988
ship
Month Days
Exercise:13

EmpCode EmpName Gender Designation District DOJ

E001 Yogesh Karwa Male Manager Khammam 30-Jul-00
E002 Gaurav Keshari Male Manager medak 17-Dec-00
E003 M.V.Krishna Murthy Male Asst Manager Hyderabad 21-Jan-01
E004 Vivek D Dand Male Asst Manager medak 25-Feb-01
E005 M Khaja Moinuddin Male Jr.Associate Khammam 1-Apr-01
E006 Naveen Chadra Madap Male Jr.Associate Khammam 6-May-01
E007 S Kanaka Durga Female Sr.Associate medak 10-Jun-01
E008 BalaSubrahmanyam Nanduri Male Sr.Associate Adilabad 15-Jul-01
E009 V Srikantha Reddy Male Manager Hyderabad 3-Sep-00
E010 N.G Naresh Male Asst Manager Adilabad 8-Oct-00
E011 Susma Kranthi Patale Female Asst Manager Khammam 12-Nov-00
E012 M Lakshmi Priya Female Manager medak 19-Aug-01
E013 K Amarnath Male Jr.Associate Adilabad 23-Sep-01
E014 Inayath Ulla Khan Male Sr.Associate Hyderabad 28-Oct-01
E015 AnbuKumar B Male Sr.Associate Hyderabad 2-Dec-01
E016 Swetha Mandal Female Jr.Associate medak 6-Jan-02
E017 Vijay Kumar D Hegde Male Jr.Associate Adilabad 10-Feb-02
E018 Girish Shiralkar Male Sr.Associate Khammam 17-Mar-02
E019 Dasari Ratna Kishore Male Asst Manager Hyderabad 21-Apr-02
E020 Radhika Female Sr.Associate Adilabad 26-May-02
Salary
23200
13724
45432
15724
45433
65253
67563
76332
56532
12124
76754
67643
24724
78564
26724
27724
28724
29724
30724
31724
Exercise:14

EmpCode EmpName Gender Designation District DOJ

E001 Yogesh Karwa Male Manager Khammam 30-Jul-00
E002 Gaurav Keshari Male Manager medak 17-Dec-00
E003 M.V.Krishna Murthy Male Asst Manager Hyderabad 21-Jan-01
E004 Vivek D Dand Male Asst Manager medak 25-Feb-01
E005 M Khaja Moinuddin Male Jr.Associate Khammam 1-Apr-01
E006 Naveen Chadra Madap Male Jr.Associate Khammam 6-May-01
E007 S Kanaka Durga Female Sr.Associate medak 10-Jun-01
E008 BalaSubrahmanyam Nanduri Male Sr.Associate Adilabad 15-Jul-01
E009 V Srikantha Reddy Male Manager Hyderabad 3-Sep-00
E010 N.G Naresh Male Asst Manager Adilabad 8-Oct-00
E011 Susma Kranthi Patale Female Asst Manager Khammam 12-Nov-00
E012 M Lakshmi Priya Female Manager medak 19-Aug-01
E013 K Amarnath Male Jr.Associate Adilabad 23-Sep-01
E014 Inayath Ulla Khan Male Sr.Associate Hyderabad 28-Oct-01
E015 AnbuKumar B Male Sr.Associate Hyderabad 2-Dec-01
E016 Swetha Mandal Female Jr.Associate medak 6-Jan-02
E017 Vijay Kumar D Hegde Male Jr.Associate Adilabad 10-Feb-02
E018 Girish Shiralkar Male Sr.Associate Khammam 17-Mar-02
E019 Dasari Ratna Kishore Male Asst Manager Hyderabad 21-Apr-02
E020 Radhika Female Sr.Associate Adilabad 26-May-02

EmpCode EmpName Gender Designation District DOJ

E001 Yogesh Karwa Male Manager Khammam 30-Jul-00
E002 Gaurav Keshari Male Manager medak 17-Dec-00
E003 M.V.Krishna Murthy Male Asst Manager Hyderabad 21-Jan-01
E004 Vivek D Dand Male Asst Manager medak 25-Feb-01
E005 M Khaja Moinuddin Male Jr.Associate Khammam 1-Apr-01
E006 Naveen Chadra Madap Male Jr.Associate Khammam 6-May-01
E007 S Kanaka Durga Female Sr.Associate medak 10-Jun-01
E008 BalaSubrahmanyam Nanduri Male Sr.Associate Adilabad 15-Jul-01
E009 V Srikantha Reddy Male Manager Hyderabad 3-Sep-00
E010 N.G Naresh Male Asst Manager Adilabad 8-Oct-00
E011 Susma Kranthi Patale Female Asst Manager Khammam 12-Nov-00
E012 M Lakshmi Priya Female Manager medak 19-Aug-01
E013 K Amarnath Male Jr.Associate Adilabad 23-Sep-01
E014 Inayath Ulla Khan Male Sr.Associate Hyderabad 28-Oct-01
E015 AnbuKumar B Male Sr.Associate Hyderabad 2-Dec-01
E016 Swetha Mandal Female Jr.Associate medak 6-Jan-02
E017 Vijay Kumar D Hegde Male Jr.Associate Adilabad 10-Feb-02
E018 Girish Shiralkar Male Sr.Associate Khammam 17-Mar-02
E019 Dasari Ratna Kishore Male Asst Manager Hyderabad 21-Apr-02
E020 Radhika Female Sr.Associate Adilabad 26-May-02

EmpCode EmpName Gender

E010 N.G Naresh Male
E003 M.V.Krishna MuMale
E019 Dasari Ratna KisMale
E011 Susma Kranthi PFemale
E004 Vivek D Dand Male
E013 K Amarnath Male
E017 Vijay Kumar D HMale
E005 M Khaja MoinudMale
E006 Naveen Chadra Male
E016 Swetha Mandal Female
E009 V Srikantha RedMale
E001 Yogesh Karwa Male
E002 Gaurav Keshari Male
E012 M Lakshmi PriyaFemale
E008 BalaSubrahmanyMale
E020 Radhika Female
E014 Inayath Ulla KhaMale
E015 AnbuKumar B Male
E018 Girish Shiralkar Male
E007 S Kanaka Durga Female
Salary
23200
13724
45432
15724
45433
65253
67563
76332
56532
12124
76754
67643
24724
78564
26724
27724
28724
29724
30724
31724

Salary
23200
13724
45432
15724
45433
65253
67563
76332
56532
12124
76754
67643
24724
78564
26724
27724
28724
 29724
30724
31724

DesignationDistrict DOJ Salary

Asst ManageAdilabad 8-Oct-00 12124
Asst ManageHyderabad 21-Jan-01 45432
Asst ManageHyderabad 21-Apr-02 30724
Asst ManageKhammam 12-Nov-00 76754
Asst Managemedak 25-Feb-01 15724
Jr.Associate Adilabad 23-Sep-01 24724
Jr.Associate Adilabad 10-Feb-02 28724
Jr.Associate Khammam 1-Apr-01 45433
Jr.Associate Khammam 6-May-01 65253
Jr.Associate medak 6-Jan-02 27724
Manager Hyderabad 3-Sep-00 56532
Manager Khammam 30-Jul-00 23200
Manager medak 17-Dec-00 13724
Manager medak 19-Aug-01 67643
Sr.Associate Adilabad 15-Jul-01 76332
Sr.Associate Adilabad 26-May-02 31724
Sr.Associate Hyderabad 28-Oct-01 78564
Sr.Associate Hyderabad 2-Dec-01 26724
Sr.Associate Khammam 17-Mar-02 29724
Sr.Associate medak 10-Jun-01 67563
Exercise:15

EmpCode EmpName Gender Designation District DOJ

E001 Yogesh Karwa Male Manager Khammam 36737
E002 Gaurav Keshari Male Manager Kurnool 36877
E003 M.V.Krishna Murthy Male Asst Manager Adilabad 36912
E004 Vivek D Dand Male Asst Manager Kurnool 36947
E005 M Khaja Moinuddin Male Jr.Associate Vizaq 36982
E006 Naveen Chadra Madap Male Jr.Associate Khammam 37017
E007 S Kanaka Durga Female Sr.Associate Kurnool 37052
E008 BalaSubrahmanyam Nanduri Male Sr.Associate Adilabad 37087
E009 V Srikantha Reddy Male Manager Hyderabad 36772
E010 N.G Naresh Male Asst Manager Adilabad 36807
E011 Susma Kranthi Patale Female Asst Manager Khammam 36842
E012 M Lakshmi Priya Female Manager Kurnool 37122
E013 K Amarnath Male Jr.Associate Adilabad 37157
E014 Inayath Ulla Khan Male Sr.Associate Hyderabad 37192
E015 AnbuKumar B Male Sr.Associate Delhi 37227
E016 Swetha Mandal Female Jr.Associate Kurnool 37262
E017 Vijay Kumar D Hegde Male Jr.Associate Adilabad 37297
E018 Girish Shiralkar Male Sr.Associate Khammam 37332
E019 Dasari Ratna Kishore Male Asst Manager Khammam 37367
E020 Radhika Female Sr.Associate Adilabad 37402
E021 Rashmi Female Jr.Associate Delhi 37437
E022 Manoj Patro Male Asst Manager Khammam 37472
E023 G.S Dilip Reddy Male Asst Manager Hyderabad 37507
E024 Sami Ahmad Male Jr.Associate Adilabad 37542
E025 Dharmesh CM Male Asst Manager Khammam 37577
E026 P.SriShanthi Female Jr.Associate Vizaq 37612
E027 Shilpa Kedia Female Asst Manager Khammam 37647
E028 R Vijay Chandra Male Sr.Associate Khammam 37682
E029 Vijay Male Asst Manager Kurnool 37717
E030 A.Vinay Reddy Male Sr.Associate Kurnool 37752
E031 Rodney D'Souza Male Jr.Associate Medak 37787
E032 Machhindra H Nehare Male Jr.Associate Hyderabad 37822
E033 S Jonathan Issac Male Asst Manager Khammam 37857
E034 Chetan Munesh Male Asst Manager Vizaq 37892
E035 Surya Kumar H Male Jr.Associate Medak 37927
E036 Sandhya Female Manager Adilabad 39817
E037 M. Lakshmi Jai Deepika Female Manager Kurnool 39852
E038 Bhuvana R Female Jr.Associate Medak 39887
E039 Ashwini K Female Manager Adilabad 39922
E040 Akula Balaji Male Jr.Associate Khammam 37962
E041 K Madhusudan Male Asst Manager Guntur 37997
E042 Digvijay G.K Male Asst Manager Kurnool 38032
E043 Vinod Huliyappa Male Sr.Associate Hyderabad 38067
E044 Kailash Kumar Chawda Male Asst Manager Guntur 38102
E045 Anuradha Vishnu Female Sr.Associate Kurnool 38137
E046 Sairaj G Kshirsagar Male Jr.Associate Khammam 36527
E047 Sundararaman R Male Sr.Associate Vizaq 36562
E048 Balaji Kilari Male Asst Manager Adilabad 38172
E049 Sriram Nag Dasaka Male Sr.Associate Guntur 38207
E050 G Ramesh Male Asst Manager Kurnool 38242
E051 SaiKrishna B Male Asst Manager Khammam 38277
E052 Y Sreeramjee Male Asst Manager Khammam 38312
E053 J Vinod Kumar Male Sr.Associate Adilabad 38347
E054 Suhasini Dikshit Female Asst Manager Khammam 38382
E055 Bruno Fernandes Male Asst Manager Hyderabad 38417
E056 Gokul J Male Sr.Associate Khammam 38662
E057 R.Swathi Female Manager Kurnool 38697
E058 S Lokesh Kumar Male Manager Khammam 38732
E059 Matangi Sulochana Female Sr.Associate Kurnool 38767
E060 AnilKumar N Male Manager Hyderabad 38802
E061 Padmashree Badrinath Female Manager Adilabad 38837
E062 Rameshkumar M. Male Manager Kurnool 38872
E063 A. Helen Freeda Female Sr.Associate Guntur 38907
E064 RajaShekara Bhat Male Manager Kurnool 38942
E065 Salini R Female Manager Kurnool 38977
E066 Gaurav Datta Roy Male Jr.Associate Adilabad 39012
E067 E Manjunath Male Manager Medak 39047
E068 Balaji Venkateshu Male Asst Manager Kurnool 38452
E069 Satya G.V.K Male Jr.Associate Adilabad 38487
E070 Anasooya Bhat Female Asst Manager Kurnool 38522
E071 Swarn Kamal Male Jr.Associate Hyderabad 38557
E072 Madhu Kiran K Male Asst Manager Khammam 38592
E073 B.S.Raghavendra Male Asst Manager Adilabad 38627
E074 R. Vaishnavi Female Manager Adilabad 39082
E075 Harish Muddan Nagaraj Male Manager Hyderabad 39117
E076 Satya Moorthy K Male Manager Kurnool 39152
E077 Sathya Kumar Male Manager Adilabad 39187
E078 S Lokesh Kumar Male Jr.Associate Khammam 36597
E079 Avila Pinto Female Sr.Associate Kurnool 36632
E080 Deepa Kulkarni Female Jr.Associate Hyderabad 36667
E081 K Shiva Kumar Male Jr.Associate Guntur 36702
E082 Mohd Salar Male Sr.Associate Adilabad 39222
E083 Sajna Manickan Female Manager Kurnool 39257
E084 Udaya Chandrika A Male Manager Guntur 39292
E085 Murali S.P Male Manager Medak 39327
E086 Mithun Aiyappa Male Sr.Associate Khammam 39362
E087 M.Maheswari Female Manager Hyderabad 39397
E088 Amarneethi R Male Manager Hyderabad 39432
E089 K.V.Maheshwar Male Manager Guntur 39642
E090 Radha Kumari Female Asst Manager Vizaq 39677
E091 Preethi. G Female Manager Vizaq 39712
E092 Vijay Kumar D Hegde Male Manager Guntur 39467
E093 Sujith Kumar SP Male Manager Kurnool 39502
E094 Suvas RaviShankar Male Asst Manager Adilabad 39537
E095 Raja Shekar rao Male Manager Hyderabad 39572
E096 Willam Martis Male Manager Hyderabad 39607
E097 Joanne Carlo Female Manager Kurnool 39747
E098 Rohit Suresh Male Asst Manager Khammam 39782
E099 Saritha Kumari Female Manager Khammam 39957
E100 Gayatri Krori Female Jr.Associate Kurnool 39992
Salary
23200
13724
45432
15724
45433
65253
67563
76332
56532
12124
76754
67643
24724
78564
26724
27724
28724
29724
30724
31724
32724
33724
34724
35724
36178
36632
37086
37540
37994
38448
38902
39356
39810
40264
40718
65234
65688
66142
66596
41172
41626
42080
42534
42988
43442
10000
10454
43896
44350
44804
45258
45712
46166
46620
47074
50252
50706
51160
51614
52068
52522
52976
53430
53884
54338
54792
55246
47528
47982
48436
48890
49344
49798
55700
56154
56608
57062
10908
11362
11816
12270
57516
57970
58424
58878
59332
59786
60240
62964
63418
63872
60694
61148
61602
62056
62510
64326
64780
67050
67504
Order ID Order Date Ship Date Ship Mode Customer ID
CA-2014-AB10015140-41954 11/11/2014 11/13/2014 First Class AB-100151402
IN-2014-JR162107-41675 2/5/2014 2/7/2014 Second Class JR-162107
IN-2014-CR127307-41929 10/17/2014 10/18/2014 First Class CR-127307
ES-2014-KM1637548-41667 1/28/2014 1/30/2014 First Class KM-1637548
SG-2014-RH9495111-41948 11/5/2014 11/6/2014 Same Day RH-9495111
IN-2014-JM156557-41818 6/28/2014 7/1/2014 Second Class JM-156557
IN-2012-TS2134092-41219 11/6/2012 11/8/2012 First Class TS-2134092
IN-2013-MB1808592-41378 4/14/2013 4/18/2013 Standard Class MB-1808592
CA-2014-AB10015140-41954 11/11/2014 11/13/2014 First Class AB-100151402
CA-2012-AB10015140-40974 3/6/2012 3/7/2012 First Class AB-100151404
CA-2012-AB10015140-40974 3/6/2012 3/7/2012 First Class AB-100151404
ID-2013-AJ107801-41383 4/19/2013 4/22/2013 First Class AJ-107801
SA-2012-MM7260110-41269 12/26/2012 12/28/2012 Second Class MM-7260110
MX-2013-VF2171518-41591 11/13/2013 11/13/2013 Same Day VF-2171518
IN-2014-PF1912027-41796 6/6/2014 6/8/2014 Second Class PF-1912027
ES-2015-BP1118545-42216 7/31/2015 8/3/2015 Second Class BP-1118545
CA-2012-AB10015140-40958 2/19/2012 2/25/2012 Standard Class AB-100151402
ES-2015-PJ1883564-42255 9/8/2015 9/14/2015 Standard Class PJ-1883564
IN-2015-JS156857-42035 1/31/2015 2/1/2015 First Class JS-156857
TZ-2015-RH9555129-42343 12/5/2015 12/7/2015 Second Class RH-9555129
PL-2013-AB600103-41494 8/8/2013 8/10/2013 First Class AB-600103
CA-2012-AB10015140-40974 3/6/2012 3/7/2012 First Class AB-100151404
IN-2012-JK1532527-41030 5/1/2012 5/2/2012 First Class JK-1532527
ES-2014-LB16795139-41697 2/27/2014 3/1/2014 Second Class LB-16795139
US-2015-NP1832582-42216 7/31/2015 8/1/2015 First Class NP-1832582
MX-2015-VD2167039-42252 9/5/2015 9/8/2015 First Class VD-2167039
IN-2012-PB19210127-41259 12/16/2012 12/19/2012 First Class PB-19210127
ES-2012-EB1411048-40981 3/13/2012 3/16/2012 Second Class EB-1411048
CA-2012-AH10030140-41020 4/21/2012 4/23/2012 Second Class AH-100301406
IN-2013-BP1123058-41329 2/24/2013 2/24/2013 Same Day BP-1123058
US-2012-RR1952536-41270 12/27/2012 12/29/2012 Second Class RR-1952536
ES-2013-BS1136545-41472 7/17/2013 7/19/2013 First Class BS-1136545
CA-2013-AH10030140-41635 12/27/2013 12/31/2013 Standard Class AH-100301404
IN-2012-DP131057-41215 11/2/2012 11/4/2012 Second Class DP-131057
CA-2013-AH10030140-41635 12/27/2013 12/31/2013 Standard Class AH-100301404
CG-2012-AH1003033-41165 9/13/2012 9/14/2012 First Class AH-1003033
CA-2012-AH10030140-41041 5/12/2012 5/18/2012 Standard Class AH-100301404
CA-2012-AH10030140-41273 12/30/2012 12/31/2012 First Class AH-100301406
ES-2015-PO18865139-42018 1/14/2015 1/18/2015 Standard Class PO-18865139
IN-2012-DL128657-40918 1/10/2012 1/11/2012 First Class DL-128657
ID-2014-JB1600059-41873 8/22/2014 8/26/2014 Standard Class JB-1600059
IN-2015-BF1100558-42319 11/11/2015 11/15/2015 Standard Class BF-1100558
IN-2015-VG2180558-42273 9/26/2015 9/28/2015 Second Class VG-2180558
ES-2013-GT14710139-41621 12/13/2013 12/17/2013 Standard Class GT-14710139
IT-2012-ZC2191048-41174 9/22/2012 9/24/2012 First Class ZC-2191048
CA-2014-AH10030140-41719 3/21/2014 3/26/2014 Second Class AH-100301408
IT-2014-EB1384045-41706 3/8/2014 3/8/2014 Same Day EB-1384045
IN-2015-AP1091527-42244 8/28/2015 8/29/2015 First Class AP-1091527
IN-2015-SW2027558-42125 5/1/2015 5/1/2015 Same Day SW-2027558
MX-2015-JH15820141-42356 12/18/2015 12/20/2015 Second Class JH-15820141
US-2012-AH10030140-41206 10/24/2012 10/27/2012 First Class AH-100301404
IR-2015-TG1164060-42265 9/18/2015 9/21/2015 First Class TG-1164060
CA-2012-AH10030140-41273 12/30/2012 12/31/2012 First Class AH-100301406
IN-2012-PB19210127-41259 12/16/2012 12/19/2012 First Class PB-19210127
MZ-2014-DG330087-41991 12/18/2014 12/18/2014 Same Day DG-330087
IN-2013-SG2047058-41424 5/30/2013 5/31/2013 First Class SG-2047058
CA-2012-AH10030140-41020 4/21/2012 4/23/2012 Second Class AH-100301406
IN-2013-GP1474058-41419 5/25/2013 5/28/2013 Second Class GP-1474058
IN-2015-MW182207-42221 8/5/2015 8/6/2015 First Class MW-182207
CA-2012-AH10030140-41041 5/12/2012 5/18/2012 Standard Class AH-100301404
IN-2015-CS1246011-42074 3/11/2015 3/13/2015 Second Class CS-1246011
CA-2015-AH10030140-42357 12/19/2015 12/23/2015 Standard Class AH-100301406
ES-2015-MS1798048-42227 8/11/2015 8/16/2015 Second Class MS-1798048
IT-2014-KC1667548-41882 8/31/2014 9/3/2014 First Class KC-1667548
IN-2015-DB1340527-42022 1/18/2015 1/23/2015 Standard Class DB-1340527
CA-2015-AS10045140-42007 1/3/2015 1/5/2015 First Class AS-100451408
IT-2015-DK13090120-42345 12/7/2015 12/8/2015 First Class DK-13090120
IN-2015-CS1184558-42354 12/16/2015 12/19/2015 First Class CS-1184558
MX-2015-EM1420082-42328 11/20/2015 11/20/2015 Same Day EM-1420082
UP-2012-DW3480137-41221 11/8/2012 11/10/2012 First Class DW-3480137
IN-2014-AS1022527-41797 6/7/2014 6/9/2014 First Class AS-1022527
MX-2012-ST2053093-41234 11/21/2012 11/22/2012 First Class ST-2053093
CG-2014-BW106533-41727 3/29/2014 3/31/2014 Second Class BW-106533
IN-2015-LA1678059-42242 8/26/2015 8/27/2015 First Class LA-1678059
ES-2013-AB10150139-41537 9/20/2013 9/22/2013 Second Class AB-10150139
IN-2015-JH158207-42140 5/16/2015 5/18/2015 Second Class JH-158207
CA-2015-AS10045140-42218 8/2/2015 8/8/2015 Standard Class AS-100451402
ES-2014-BE1141048-41967 11/24/2014 11/25/2014 First Class BE-1141048
IN-2012-SZ2003527-41221 11/8/2012 11/10/2012 Second Class SZ-2003527
IN-2012-RM1937558-41209 10/27/2012 10/27/2012 Same Day RM-1937558
ES-2015-HG1484545-42327 11/19/2015 11/23/2015 Standard Class HG-1484545
MO-2015-DP310586-42305 10/28/2015 10/30/2015 Second Class DP-310586
CA-2014-AS10045140-41908 9/26/2014 9/28/2014 First Class AS-100451404
US-2015-AS10045140-42252 9/5/2015 9/6/2015 First Class AS-100451404
Customer Name Segment Product ID Category Sales
Aaron Bergman Consumer TEC-PH-5816 Technology $221.98
Justin Ritter Corporate FUR-CH-5379 Furniture $3,709.39
Craig Reiter Consumer TEC-PH-5356 Technology $5,175.17
Katherine Murray Home Office TEC-PH-5267 Technology $2,892.51
Rick Hansen Consumer TEC-CO-6011 Technology $2,832.96
Jim Mitchum Corporate TEC-PH-5842 Technology $2,862.68
Toby Swindell Consumer FUR-CH-5378 Furniture $1,822.08
Mick Brown Consumer FUR-TA-3764 Furniture $5,244.84
Aaron Bergman Consumer FUR-BO-5957 Furniture $341.96
Aaron Bergman Consumer FUR-CH-4421 Furniture $48.71
Aaron Bergman Consumer OFF-AR-5309 Office Supplies $17.94
Anthony Jacobs Corporate FUR-TA-3420 Furniture $4,626.15
Magdelene Morse Consumer TEC-PH-3807 Technology $2,616.96
Vicky Freymann Home Office FUR-CH-4530 Furniture $2,221.80
Peter Fuller Consumer OFF-AP-4959 Office Supplies $3,701.52
Ben Peterman Corporate OFF-AP-3575 Office Supplies $1,869.59
Aaron Bergman Consumer OFF-ST-3078 Office Supplies $12.62
Patrick Jones Corporate OFF-AP-4743 Office Supplies $7,958.58
Jim Sink Corporate TEC-CO-3597 Technology $2,565.59
Ritsa Hightower Consumer OFF-AP-4967 Office Supplies $3,409.74
Ann Blume Corporate FUR-TA-4644 Furniture $1,977.72
Aaron Bergman Consumer OFF-ST-3744 Office Supplies $242.94
Jason Klamczynski Corporate FUR-CH-5774 Furniture $2,754.00
Laurel Beltran Home Office OFF-AP-4960 Office Supplies $5,273.70
Naresj Patel Consumer TEC-PH-5268 Technology $1,713.84
Valerie Dominguez Consumer FUR-TA-4643 Furniture $2,106.50
Phillip Breyer Corporate FUR-TA-5060 Furniture $1,715.16
Eugene Barchas Consumer OFF-AP-4743 Office Supplies $3,069.74
Aaron Hawkins Corporate OFF-FA-6129 Office Supplies $247.84
Benjamin Patterson Consumer FUR-CH-5443 Furniture $1,878.72
Rick Reed Corporate TEC-PH-5841 Technology $1,696.64
Bill Shonely Corporate TEC-MA-5503 Technology $2,402.87
Aaron Hawkins Corporate TEC-PH-4389 Technology $668.16
Dave Poirier Corporate OFF-AP-3579 Office Supplies $2,526.93
Aaron Hawkins Corporate OFF-ST-4291 Office Supplies $323.10
Aaron Hawkins Corporate TEC-PH-3148 Technology $3,817.26
Aaron Hawkins Corporate FUR-CH-4840 Furniture $279.46
Aaron Hawkins Corporate TEC-AC-6340 Technology $34.77
Patrick O'Donnell Consumer TEC-CO-3598 Technology $4,141.02
Dan Lawera Consumer TEC-PH-5356 Technology $2,875.10
Joy Bell- Consumer TEC-PH-5268 Technology $3,200.60
Barry Franz Home Office TEC-PH-5269 Technology $4,518.78
Vivek Grady Corporate FUR-BO-5951 Furniture $5,667.87
Greg Tran Consumer TEC-PH-5267 Technology $5,785.02
Zuschuss Carroll Consumer OFF-AP-3874 Office Supplies $3,018.62
Aaron Hawkins Corporate FUR-FU-4072 Furniture $86.45
Ellis Ballard Corporate FUR-CH-5441 Furniture $2,092.50
Arthur Prichep Consumer FUR-CH-5380 Furniture $2,761.20
Scott Williamson Consumer TEC-MA-5007 Technology $2,174.13
John Huston Consumer FUR-CH-4531 Furniture $3,473.14
Aaron Hawkins Corporate OFF-BI-4372 Office Supplies $49.41
Trudy Glocke Consumer TEC-CO-3678 Technology $2,108.64
Aaron Hawkins Corporate OFF-LA-3231 Office Supplies $18.90
Phillip Breyer Corporate FUR-BO-5762 Furniture $2,197.50
Deirdre Greer Corporate TEC-PH-5269 Technology $2,582.16
Sheri Gordon Consumer TEC-CO-4590 Technology $1,526.52
Aaron Hawkins Corporate OFF-BI-2937 Office Supplies $9.91
Guy Phonely Corporate FUR-TA-3766 Furniture $1,745.34
Mitch Webber Consumer OFF-AP-3577 Office Supplies $4,191.51
Aaron Hawkins Corporate OFF-PA-4014 Office Supplies $8.00
Chuck Sachs Consumer FUR-BO-5760 Furniture $3,063.27
Aaron Hawkins Corporate OFF-AR-3276 Office Supplies $18.70
Michael Stewart Corporate TEC-PH-5839 Technology $4,473.00
Kimberly Carter Corporate TEC-PH-3130 Technology $1,502.01
Denny Blanton Consumer FUR-CH-5774 Furniture $5,049.00
Aaron Smayling Corporate TEC-MA-3788 Technology $695.70
Dave Kipp Consumer FUR-BO-5760 Furniture $2,188.05
Cari Sayre Corporate FUR-TA-3779 Furniture $1,920.36
Evan Minnotte Home Office TEC-PH-5839 Technology $1,704.00
Dianna Wilson Home Office FUR-TA-3771 Furniture $1,858.68
Alan Schoenberger Corporate FUR-CH-4530 Furniture $3,298.26
Shui Tom Consumer OFF-AP-4497 Office Supplies $2,443.48
Barry Weirich Consumer FUR-CH-4530 Furniture $3,808.80
Laura Armstrong Corporate FUR-TA-3422 Furniture $3,427.15
Aimee Bixby Consumer TEC-PH-5355 Technology $3,441.69
John Huston Consumer TEC-PH-3147 Technology $2,863.35
Aaron Smayling Corporate TEC-MA-3329 Technology $1,439.98
Bobby Elias Consumer TEC-CO-3599 Technology $1,487.40
Sam Zeldin Home Office TEC-CO-6010 Technology $3,200.04
Raymond Messe Consumer FUR-CH-5380 Furniture $2,301.00
Harry Greene Consumer FUR-CH-4654 Furniture $5,729.35
Dave Poirier Corporate TEC-CO-3710 Technology $5,301.24
Aaron Smayling Corporate FUR-BO-3176 Furniture $477.67
Aaron Smayling Corporate OFF-BI-3324 Office Supplies $88.07
Exercise 16

EMP CODE EmpName Gender Designation District DOJ Salary

HBA Yogesh Karwa Male Manager Madurai 2000/07/30 23200
E002 Gaurav Keshari Male Manager Kurnool 2000/12/17 13724
E003 M.V.Krishna Murthy Male Asst Manager Chennai 2001/01/21 45432
E004 Vivek D Dand Male Asst Manager Kurnool 2001/02/25 15724
E005 M Khaja Moinuddin Male Jr.Associate Vizaq 2001/04/01 45433
E006 Naveen Chadra Madap Male Jr.Associate Madurai 2001/05/06 65253
E007 S Kanaka Durga Female Sr.Associate Kurnool 2001/06/10 67563
E008 BalaSubrahmanyam Nanduri Male Sr.Associate Chennai 2001/07/15 76332
E009 V Srikantha Reddy Male Manager Hyderabad 2000/09/03 56532
E010 N.G Naresh Male Asst Manager Chennai 2000/10/08 12124
E011 Susma Kranthi Patale Female Asst Manager Madurai 2000/11/12 76754
E012 M Lakshmi Priya Female Manager Kurnool 2001/08/19 67643
E013 K Amarnath Male Jr.Associate Chennai 2001/09/23 24724
E014 Inayath Ulla Khan Male Sr.Associate Hyderabad 2001/10/28 78564
E015 Harish Muddan Nagaraj Male Sr.Associate Delhi 2001/12/02 26724
E016 Swetha Mandal Female Jr.Associate Kurnool 2002/01/06 27724
E017 Vijay Kumar D Hegde Male Jr.Associate Chennai 2002/02/10 28724
E018 Girish Shiralkar Male Sr.Associate Madurai 2002/03/17 29724
E019 Dasari Ratna Kishore Male Asst Manager Madurai 2002/04/21 30724
E020 Radhika Female Sr.Associate Chennai 2002/05/26 31724
E021 Rashmi Female Jr.Associate Delhi 2002/06/30 32724
E022 Manoj Patro Male Asst Manager Madurai 2002/08/04 33724
E023 G.S Dilip Reddy Male Asst Manager Hyderabad 2002/09/08 34724
E024 Sami Ahmad Male Jr.Associate Chennai 2002/10/13 35724
E025 Dharmesh CM Male Asst Manager Madurai 2002/11/17 36178
E026 P.SriShanthi Female Jr.Associate Vizaq 2002/12/22 36632
E027 Shilpa Kedia Female Asst Manager Madurai 2003/01/26 37086
E028 R Vijay Chandra Male Sr.Associate Madurai 2003/03/02 37540
E029 Vijay Male Asst Manager Kurnool 2003/04/06 37994
E030 A.Vinay Reddy Male Sr.Associate Kurnool 2003/05/11 38448
E031 Rodney D'Souza Male Jr.Associate Nellore 2003/06/15 38902
E032 Machhindra H Nehare Male Jr.Associate Hyderabad 2003/07/20 39356
E033 S Jonathan Issac Male Asst Manager Madurai 2003/08/24 39810
E034 Chetan Munesh Male Asst Manager Vizaq 2003/09/28 40264
E035 Surya Kumar H Male Jr.Associate Nellore 2003/11/02 40718
E036 Sandhya Female Manager Chennai 2009/01/04 65234
E037 M. Lakshmi Jai Deepika Female Manager Kurnool 2009/02/08 65688
E038 Bhuvana R Female Jr.Associate Nellore 2009/03/15 66142
E039 Ashwini K Female Manager Chennai 2009/04/19 66596
E040 Akula Balaji Male Jr.Associate Madurai 2003/12/07 41172
E041 K Madhusudan Male Asst Manager Guntur 2004/01/11 41626
E042 Digvijay G.K Male Asst Manager Kurnool 2004/02/15 42080
E043 Vinod Huliyappa Male Sr.Associate Hyderabad 2004/03/21 42534
E044 Kailash Kumar Chawda Male Asst Manager Guntur 2004/04/25 42988
E045 Anuradha Vishnu Female Sr.Associate Kurnool 2004/05/30 43442
E046 Sairaj G Kshirsagar Male Jr.Associate Madurai 2000/01/02 10000
E047 Sundararaman R Male Sr.Associate Vizaq 2000/02/06 10454
E048 Balaji Kilari Male Asst Manager Chennai 2004/07/04 43896
E049 Sriram Nag Dasaka Male Sr.Associate Guntur 2004/08/08 44350
E050 G Ramesh Male Asst Manager Kurnool 2004/09/12 44804
E051 SaiKrishna B Male Asst Manager Madurai 2004/10/17 45258
E052 Y Sreeramjee Male Asst Manager Madurai 2004/11/21 45712
E053 J Vinod Kumar Male Sr.Associate Chennai 2004/12/26 46166
E054 Suhasini Dikshit Female Asst Manager Madurai 2005/01/30 46620
E055 Bruno Fernandes Male Asst Manager Hyderabad 2005/03/06 47074
E056 Gokul J Male Sr.Associate Madurai 2005/11/06 50252
E057 R.Swathi Female Manager Kurnool 2005/12/11 50706
E058 S Lokesh Kumar Male Manager Madurai 2006/01/15 51160
E059 Matangi Sulochana Female Sr.Associate Kurnool 2006/02/19 51614
E060 AnilKumar N Male Manager Hyderabad 2006/03/26 52068
E061 Padmashree Badrinath Female Manager Chennai 2006/04/30 52522
E062 Rameshkumar M. Male Manager Kurnool 2006/06/04 52976
E063 A. Helen Freeda Female Sr.Associate Guntur 2006/07/09 53430
E064 RajaShekara Bhat Male Manager Kurnool 2006/08/13 53884
E065 Salini R Female Manager Kurnool 2006/09/17 54338
E066 Gaurav Datta Roy Male Jr.Associate Chennai 2006/10/22 54792
E067 E Manjunath Male Manager Nellore 2006/11/26 55246
E068 Balaji Venkateshu Male Asst Manager Kurnool 2005/04/10 47528
E069 Satya G.V.K Male Jr.Associate Chennai 2005/05/15 47982
E070 Anasooya Bhat Female Asst Manager Kurnool 2005/06/19 48436
E071 Swarn Kamal Male Jr.Associate Hyderabad 2005/07/24 48890
E072 Madhu Kiran K Male Asst Manager Madurai 2005/08/28 49344
E073 B.S.Raghavendra Male Asst Manager Chennai 2005/10/02 49798
E074 R. Vaishnavi Female Manager Chennai 2006/12/31 55700
E075 Harish Muddan Nagaraj Male Manager Hyderabad 2007/02/04 56154
E076 Satya Moorthy K Male Manager Kurnool 2007/03/11 56608
E077 Sathya Kumar Male Manager Chennai 2007/04/15 57062
E078 S Lokesh Kumar Male Jr.Associate Madurai 2000/03/12 10908
E079 Avila Pinto Female Sr.Associate Kurnool 2000/04/16 11362
E080 Deepa Kulkarni Female Jr.Associate Hyderabad 2000/05/21 11816
E081 K Shiva Kumar Male Jr.Associate Guntur 2000/06/25 12270
E082 Mohd Salar Male Sr.Associate Chennai 2007/05/20 57516
E083 Sajna Manickan Female Manager Kurnool 2007/06/24 57970
E084 Udaya Chandrika A Male Manager Guntur 2007/07/29 58424
E085 Murali S.P Male Manager Nellore 2007/09/02 58878
E086 Mithun Aiyappa Male Sr.Associate Madurai 2007/10/07 59332
E087 M.Maheswari Female Manager Hyderabad 2007/11/11 59786
E088 Amarneethi R Male Manager Hyderabad 2007/12/16 60240
E089 K.V.Maheshwar Male Manager Guntur 2008/07/13 62964
E090 Radha Kumari Female Asst Manager Vizaq 2008/08/17 63418
E091 Preethi. G Female Manager Vizaq 2008/09/21 63872
E092 Vijay Kumar D Hegde Male Manager Guntur 2008/01/20 60694
E093 Sujith Kumar SP Male Manager Kurnool 2008/02/24 61148
E094 Suvas RaviShankar Male Asst Manager Chennai 2008/03/30 61602
E095 Raja Shekar rao Male Manager Hyderabad 2008/05/04 62056
E096 Willam Martis Male Manager Hyderabad 2008/06/08 62510
E097 Joanne Carlo Female Manager Kurnool 2008/10/26 64326
E098 Rohit Suresh Male Asst Manager Madurai 2008/11/30 64780
E099 Saritha Kumari Female Manager Madurai 2009/05/24 67050
E100 Gayatri Krori Female Jr.Associate Kurnool 2009/06/28 67504