Employee details

S.no Name Emp No Designation Salary blood broup Phone number

1 Joe 1011 CEO 10000 O+ve 289749782
2 John 2011 Software developer 15000 B++ 382741987
3 Marry 1028 Tester 100000 A-ve 222147868
4 Mark 1072 Finance 20000 AB+ve 656398101
5 Susan 2874 Finance 15000 A-ve 164192719
6 Jennifer 2084 Tester 29000 B+ve 688578990
7 Mike 2917 Marketing 19000 AB+ve 157378911
8 Tim 2917 Marketing 12000 AB-ve 538975791
9 Jeffery 2962 Software development 10000 O-ve 745932616
10 Morgan 1972 Tester 29000 O+ve 274729436
 Text Lower Upper

Jack jack JACK

Jennifer jennifer JENNIFER
Brock brock BROCK
Emily emily EMILY
Martha martha MARTHA
Clark clark CLARK
Tony tony TONY
Ben ben BEN
Alfred alfred ALFRED
Steve steve STEVE
Barnes barnes BARNES
Banner banner BANNER
Fred fred FRED
Peter peter PETER
S.no Name Emp No Designation Salary blood broup Phone number
1 Joe 1011 CEO 10000 O+ve 289749782
2 John 2011 Software developer 15000 B++ 382741987
3 Marry 1028 Tester 100000 A-ve 222147868
4 Mark 1072 Finance 20000 AB+ve 656398101
5 Susan 2874 Finance 15000 A-ve 164192719
6 Jennifer 2084 Tester 29000 B+ve 688578990
7 Mike 2917 Marketing 19000 AB+ve 157378911
8 Tim 2917 Marketing 12000 AB-ve 538975791
9 Jeffery 2962 Software development 10000 O-ve 745932616
10 Morgan 1972 Tester 29000 O+ve 274729436
Region Category State Sub-category Sales Qunatity
West Furniture California Furnishings ₹ 48.86 7
West Office supplies California Art ₹ 7.26 4
West Technology California Phones ₹ 907.15 5
West Office supplies California Phones ₹ 67.98 6
West Office supplies California Phones ₹ 90.76 8
West Furniture California Phones ₹ 45.70 4
West Technology Taxes Phones ₹ 88.00 5
West Office supplies Taxes Paper ₹ 23.45 7
West Office supplies Taxes Paper ₹ 76.56 2
West Office supplies Taxes Art ₹ 88.00 3
West Technology Taxes Tables ₹ 90.00 4
West Office supplies Taxes Bookcase ₹ 34.00 9
West Furniture Taxes Chairs ₹ 67.80 2
South Furniture Taxes Paper ₹ 99.00 1
South Furniture Indiana Tables ₹ 102.45 3
South Furniture Indiana Tables ₹ 54.67 4
South Office supplies Indiana Tables ₹ 80.56 5
South Office supplies Indiana Tables ₹ 42.42 6
South Office supplies Indiana Storages ₹ 56.76 7
South Office supplies Indiana Storages ₹ 77.00 8
South Furniture Noirth carolina Paper ₹ 84.00 4
South Furniture Noirth carolina Texas ₹ 3.00 5
South Furniture Noirth carolina Texas ₹ 44.00 7
₹ 100.00
₹ 1,000.00
 Col1 Col 2 Result
Ford india Maruti Not Found 0
Tesla Mahindra and Mahindra Mahindra and Mahindra FALSE
Tata Hyundai india Hyundai india FALSE
Ferrari Ferrari Ferrari TRUE
Lamborgini Lamborgini Lamborgini TRUE
Porsche Porsche Porsche TRUE
Maruti suzuki Maruti suzuki Maruti suzuki TRUE
Renault maruti suzuki Maruti suzuki FALSE
Mahindra and Mahindra Mahindra and Mahindra Mahindra and Mahindra TRUE
Hyundai india Hyundai india Hyundai india TRUE
Honda india Result Not Found FALSE
Maruti suzuki Not Found FALSE
Renalut Not Found FALSE
Mahindra and Mahindra Not Found FALSE
Hyundai india Not Found FALSE

Col1 Col2 Col3 Col4

Ford india Endevour Ford Ford india
Tesla Model X Tesla Tesla
Tata Safari Tata Tata
Ferrari F400 Ferrari Ferrari
Lamborgini Spyder Lamborgini Lamborgini
Porsche GT3 Porsche Porsche
Maruti suzuki Swift Maruti Maruti suzuki
Renault Duster Renault Renault
Mahindra and Mahindra Scorpio Mahindra Mahindra and Mahindra
Hyundai india Verna Hyundai Hyundai india
Honda india Amaze Honda Honda india
 Result
NotFound
NotFound
NotFound
Found
Found
Found
Found
NotFound
Found
Found
NotFound
NotFound
NotFound
NotFound
NotFound
 North Q1_2021 Q2_2021 Q3_2021 Q4_2021 Total_2021 Q1_2022 Q2_2022 Q3_2022 Q4_2022
North Store 1 1000 1402 1029 1000 4431 1000 1402 1029 4460
North Store 2 1028 1029 1298 1028 4382 1029 1298 1298 4382
North Store 3 1029 1982 1982 1029 5248 1029 1982 1982 5427
Total 3057 4626 2 3057 14061 3057 4626 3057 14269
West Store 1 1402 1402 1029 1000 4833 1000 1402 1029 4833
West Store 2 1298 1298 1208 1029 4652 1120 1432 1208 4701
West Store 3 1982 1982 1982 1029 6201 1126 1982 1982 4483
Total 4682 4682 4219 3057 15686 3257 4682 4219 14017
South Store 1 1029 1402 1028 1000 4460 1000 1402 1028 4431
South Store 2 1028 1298 1208 1028 4382 1028 1298 1208 4382
South Store 3 1029 1982 1982 1029 5248 1029 1982 1982 5248
Total 3265 4682 3265 3057 14269 3057 4682 3265 14269
East Store 1 1102 1243 1208 1000 4374 1402 1243 1208 4833
East Store 2 1120 1298 1029 1028 4701 1213 1298 1029 4701
East Store 3 1120 1120 1982 1029 6201 1120 1982 1982 6201
Total 3435 3801 3257 3057 15586 4682 3801 3257 15586
Total_2022
4460
4382
5427
14269
4833
4701
4483
14017
4431
4382
5248
14269
4833
4701
6201
15586
Employee_ID Employee_Name Designaton Departmant Salary
10034 Chris Associate IT support 20000
10017 Clark Intern Admin 10000
10037 Dominic Contract IT suppot 50000

10015 Emily Manager Knowlge 35000

10024 Fred Intern Testing 10000
10034 Chris Associate IT support 20000

10017 Clark Intern Admin 10000

10037 Dominic Contract IT suppot 50000
10015 Emily Manager Knowlge 35000

10024 Fred Intern Testing 10000

10034 Chris Associate IT support 20000
steve
10017 Clark Intern Admin 10000
10037 Dominic Contract IT suppot 50000
10015 Emily Manager Knowlge 35000
10024 Fred Intern Testing 10000

Testing

10035 Clark Intern Admin 10000

10012 Dominic Contract IT suppot 50000
10041 Emily Manager Knowlge 35000
10013 Fred Intern Testing 10000
10027 idris alba senior contract 40000

29871

10038 letty Intern Hr 10000

10098 Luke hobbs Contarct analytics 65000
10078 Mack Intern Knowledge transfer 12000
10076 Martha Contract analytics 30000
10023 Morgan Trainee admin 10000
Employee_DOB Employee_DOB count
5/19/1995 5/3/2020 7
12/12/1996 5/6/2020 7
8/12/1996 6/6/2018 7
0
4/9/1994 5/6/2018 7
1/1/1900 5/3/2020 7
5/19/1995 5/3/2020 7
0
12/12/1996 5/6/2020 7
8/12/1996 6/6/2018 7
4/9/1994 5/6/2018 7
0
1/1/1900 5/3/2020 7
5/19/1995 5/3/2020 7
1
12/12/1996 5/6/2020 7
8/12/1996 6/6/2018 7
4/9/1994 5/6/2018 7
1/1/1900 5/3/2020 7
0
1
0
12/12/1996 5/6/2020 7
8/12/1996 6/6/2018 7
4/9/1994 5/6/2018 7
1/1/1900 5/3/2020 7
3/3/1994 6/6/2018 7
0
1
0
9/23/1994 5/6/2020 7
26-Sep 6/6/2018 7
4/3/1995 5/6/2018 7
1/1/1995 5/3/2020 7
12/13/1994 6/6/2018 7
 Number Barcode
10023456 (10023456)
10023457 (10023457)
10023458 (10023458)
10023459 (10023459)
10023460 (10023460)
10023461 (10023461)
10023462 (10023462)
10023463 (10023463)
10023464 (10023464)
10023465 (10023465)
10023466 (10023466)
Region Category State
West Furniture California
West Office supplies California
West Technology California
West Office supplies California
West Office supplies California
West Furniture California
West Technology Taxes
West Office supplies Taxes
West Office supplies Taxes
West Office supplies Taxes
West Technology Taxes
West Office supplies Taxes
West Furniture Taxes
South Furniture Taxes
South Furniture Indiana
South Furniture Indiana
South Office supplies Indiana
South Office supplies Indiana
South Office supplies Indiana
South Office supplies Indiana
South Furniture Noirth carolina
South Furniture Noirth carolina
South Furniture Noirth carolina
Sub-category Sales Qunatity
Furnishings ₹ 48.86 7
Art ₹ 7.26 4
Phones ₹ 907.15 5
Phones ₹ 67.98 6
Phones ₹ 90.76 8
Phones ₹ 45.70 4
Phones ₹ 88.00 5
Paper ₹ 23.45 7
Paper ₹ 76.56 2
Art ₹ 88.00 3
Tables ₹ 90.00 4
Bookcase ₹ 34.00 9
Chairs ₹ 67.80 2
Paper ₹ 99.00 1
Tables ₹ 102.45 3
Tables ₹ 54.67 4
Tables ₹ 80.56 5
Tables ₹ 42.42 6
Storages ₹ 56.76 7
Storages ₹ 77.00 8
Paper ₹ 84.00 4
Texas ₹ 3.00 5
Texas ₹ 44.00 7
Amount Amount in words
10.2
22.2
53.25
12.34
110.34

John
Jan Feb March
4000 8952 6592
10000 2659 3594
5000 1000 9892
6000 9525 8596
9500 6532 2658
8900 9562 3652
3650 5952 5986
4568 6528 3651
9000 2894 6956
 Product Name Product Code Product Serial Number Assembly Code
UltraFast Laptop PDL001 SNL-UFL-202401 101- ASM-LAP
QuantumSmartpho
PDL002 SNL-QSP-202402 102-ASM-PHN
ne
EcoAir Conditioner PDL003 SNL-EAC-202403 103-ASM-AC
PrecisionHeadphon
PDL004 SNL-PHP-202404 104-ASM-HP
es
MaxView Monitor PDL005 SNL-MVM-202405 105-ASM-MON

HyperDrive SSD PDL006 SNL-HDS-202406 106-ASM-SSD

OmniSound
PDL007 SNL-OSS-202407 107-ASM-SPK
Speaker
FlexCharge
PDL008 SNL-FCA-202408 108-ASM-ADP
Adapter
AquaShield Water
PDL009 SNL-ASW-202409 109-ASM-WPU
Purifier
SolarGen Solar
PDL010 SNL-SGS-202410 110-ASM-SP
Panel
Product code Product serial number Assembley code
101 ASM LAP
102 ASM PHN
103 ASM AC

104 ASM HP

105 ASM MON

106 ASM SSD

107 ASM SPK

ASM ADP
108

ASM WPU
109

110 ASM SP
 simplilearn

Existing file

Navigating cell

Navigating cell

Sticky note

Emial to colleague

Email to colleague
Navigate me to here

Navigating cell
S.No Name Roll No Class Blood Group
1 Student_1 RN001 6B AB-
2 Student_2 RN002 7A B-
3 Student_3 RN003 7A AB+
4 Student_4 RN004 8B A-
5 Student_5 RN005 6B A+
6 Student_6 RN006 8B B-
7 Student_7 RN007 7B AB+
8 Student_8 RN008 8A A+
9 Student_9 RN009 6A O+
10 Student_10 RN010 7B AB-
11 Student_11 RN011 6B AB-
12 Student_12 RN012 8A A+
13 Student_13 RN013 6B B-
14 Student_14 RN014 6A O+
15 Student_15 RN015 8A O-
16 Student_16 RN016 8A O-
17 Student_17 RN017 8A O+
18 Student_18 RN018 6B O-
19 Student_19 RN019 6B A-
20 Student_20 RN020 6A B+
21 Student_21 RN021 8B A-
22 Student_22 RN022 8A A+
23 Student_23 RN023 6B B-
24 Student_24 RN024 6B A+
25 Student_25 RN025 8B AB-
26 Student_26 RN026 8B O+
27 Student_27 RN027 8B A+
28 Student_28 RN028 7A B+
29 Student_29 RN029 7A O+
30 Student_30 RN030 7A B-
31 Student_31 RN031 7B A-
32 Student_32 RN032 6B B-
33 Student_33 RN033 6A AB+
34 Student_34 RN034 6A AB-
35 Student_35 RN035 7A B+
36 Student_36 RN036 7A AB-
37 Student_37 RN037 6A B-
38 Student_38 RN038 6A O-
39 Student_39 RN039 7A A+
40 Student_40 RN040 6B B-
41 Student_41 RN041 6B B-
42 Student_42 RN042 6A AB+
43 Student_43 RN043 6B O-
44 Student_44 RN044 6A B-
45 Student_45 RN045 7A O+
46 Student_46 RN046 6B A-
47 Student_47 RN047 8A AB-
48 Student_48 RN048 7B AB+
49 Student_49 RN049 6A AB-
50 Student_50 RN050 8A B-
Maths Science Computers Statistics Social Science GK Marks Obtained
38 54 46 62 53 81 334
61 63 95 42 60 91 412
76 57 53 84 40 37 347
78 56 63 46 52 38 333
35 61 64 94 36 99 389
97 35 93 93 90 51 459
69 48 41 77 38 52 325
48 98 43 68 66 78 401
76 51 ui 61 38 92 384
77 97 43 55 75 63 410
71 95 42 94 69 71 442
66 50 35 62 86 65 364
76 55 62 38 86 79 396
76 59 57 50 67 69 378
44 97 88 92 52 81 454
58 54 39 72 35 70 328
66 85 89 78 46 98 462
92 40 100 85 73 90 480
40 49 63 55 46 42 295
95 36 100 65 96 65 457
81 80 84 74 72 42 433
87 63 68 96 61 73 448
61 43 69 60 96 90 419
69 79 92 85 87 39 451
45 67 81 35 62 76 366
72 73 75 65 95 44 424
79 97 62 40 67 61 406
89 80 66 83 94 69 481
84 35 39 45 45 45 293
80 50 48 91 65 45 379
84 95 84 55 94 37 449
67 95 100 36 39 83 420
90 66 80 41 60 72 409
77 98 58 100 96 81 510
45 76 41 53 95 89 399
67 35 41 52 53 41 289
67 35 98 82 37 47 366
88 36 43 87 70 72 396
100 35 38 59 54 70 356
56 56 76 83 86 83 440
51 79 80 55 91 36 392
50 51 66 80 58 75 380
51 46 92 65 65 65 384
41 62 66 49 87 71 376
67 90 61 73 91 88 470
92 77 98 51 59 76 453
75 59 73 37 43 40 327
83 83 54 60 55 76 411
36 58 43 91 81 59 368
70 63 94 55 99 43 424
Total Marks Percentage Round-off percentage
600 55.67 55.7
600 68.67 68.7
600 57.83 57.9
600 55.5 55.5
600 64.83 64.9
600 76.5 76.5
600 54.17 54.2
600 66.83 66.9
600 64 64
600 68.33 68.4
600 73.67 73.7
600 60.67 60.7
600 66 66
600 63 63
600 75.67 75.7
600 54.67 54.7
600 77 77
600 80 80
600 49.17 49.2
600 76.17 76.2
600 72.17 72.2
600 74.67 74.7
600 69.83 69.9
600 75.17 75.2
600 61 61
600 70.67 70.7
600 67.67 67.7
600 80.17 80.2
600 48.83 48.9
600 63.17 63.2
600 74.83 74.9
600 70 70
600 68.17 68.2
600 85 85
600 66.5 66.5
600 48.17 48.2
600 61 61
600 66 66
600 59.33 59.4
600 73.33 73.4
600 65.33 65.4
600 63.33 63.4
600 64 64
600 62.67 62.7
600 78.33 78.4
600 75.5 75.5
600 54.5 54.5
600 68.5 68.5
600 61.33 61.4
600 70.67 70.7
Employee Name Team Name Task 1 Status Task 2 StatusTask 3 Status
John Doe Development Completed 1
Jane Smith Marketing Not completed FALSE
Alan Brown Sales Not completed FALSE
Emily White HR Completed 1
Chris Black IT Support Not completed FALSE
Sarah Green Finance Not completed FALSE

John Doe Development Done

Jane Smith Marketing Not done
Alan Brown Sales Not done
Emily White HR Done
Chris Black IT Support Not done
Sarah Green Finance Not done
 Index Scores Deviation Deviation^2
1 85
2 90
3 78
4 92
5 88

Deviation
Index Scores Deviation ^2
1 85 -1.6 2.56
2 90 3.4 11.56
3 78 -8.6 73.96
4 92 5.4 29.16
5 88 1.4 1.96
Sum 433 2.84217094E-14 119.2
Count 5 5 5
Mean 86.6
Variance 29.8
Standard deviation 5.458938
 Department Look-up position
Sales Operations 6
Marketing
IT Look-up Position
HR Finance 5
Finance
Operations
Customer Service
Research & Development
Legal
Employee_ID Employee_Name Designaton Departmant Salary Employee_DOB
10015 Emily Manager Knowlge 35000 4/9/1994
10015 Emily Manager Knowlge 35000 4/9/1994
10015 Emily Manager Knowlge 35000 4/9/1994
10037 Dominic Contract IT suppot 50000 8/12/1996
10037 Dominic Contract IT suppot 50000 8/12/1996
10037 Dominic Contract IT suppot 50000 8/12/1996
10034 Chris Associate IT support 20000 5/19/1995
10024 Fred Intern Testing 10000 1/1/1900
10034 Chris Associate IT support 20000 5/19/1995
10024 Fred Intern Testing 10000 1/1/1900
10034 Chris Associate IT support 20000 5/19/1995
10024 Fred Intern Testing 10000 1/1/1900
10017 Clark Intern Admin 10000 12/12/1996
10017 Clark Intern Admin 10000 12/12/1996
10017 Clark Intern Admin 10000 12/12/1996
Employee_DOJ
5/6/2018
5/6/2018
5/6/2018
6/6/2018
6/6/2018

6/6/2018
5/3/2020
5/3/2020
5/3/2020
5/3/2020
5/3/2020
5/3/2020
5/6/2020
5/6/2020
5/6/2020