Total Sales of prod

Product Sum Total Sales

Headset 129914 700000
Laptop 169428 600000
Monitor 101333
500000
Phone 138379
Tablet 98407 400000
Total Result 637461
300000

200000

100000

Region Sum Total Sales 0

Headset Laptop Monitor Phone
East 168345
North 134563
South 196316
West 138237
Total Result 637461
 Total Sales of product by region

Sum Total Sales

adset Laptop Monitor Phone Tablet Total

Result
 Data
Department Total Sales Total Target
Finance 39000.00 160000
HR 42000.00 121000
IT 54000.00 356000
Sales 89000.00 441000
Total Result 224000.00 1078000
Data
Employee Total Sales Total Target
Alex 26000.00 164000
David 15000.00 67000
Emma 24000.00 91000
Grace 30000.00 138000
Jack 17000.00 108000
John 12000.00 12000
Liam 32000.00 224000
Mike 18000.00 30000
Sarah 22000.00 52000
Sophia 28000.00 192000
Total Result 224000.00 1078000

Employee Total Sales

Alex 26000.00
Emma 24000.00
Grace 30000.00
Liam 32000.00
Sophia 28000.00
Total Result 140000.00

Employee Total Sales

David 15000.00
Jack 17000.00
John 12000.00
Total Result 44000.00

Data
Product Total Sales Contribution of Each product in total sales
Laptops 57000.00 25.45%
Phones 70000.00 31.25%
Printers 49000.00 21.88%
Tablets 48000.00 21.43%
Total Result 224000.00 100.00%

Region Total Sales

East 64000.00
North 52000.00
South 41000.00
West 67000.00
Total Result 224000.00

(empty) Month
Region Jan Feb Mar Apr May Total Result
East
North
South
West
Total Result

Data
Month Sum of Sales Sum of Cumalative Sales
Jan 30000.00
Feb 37000.00 #VALUE!
Mar 41000.00 #VALUE!
Apr 56000.00 #VALUE!
May 60000.00 #VALUE!
Total Result 224000.00

Employee Department Max of Sales

Alex 26000.00
IT 26000.00
David 15000.00
Sales 15000.00
Emma 24000.00
HR 24000.00
Grace 30000.00
Sales 30000.00
Jack 17000.00
Finance 17000.00
John 12000.00
Sales 12000.00
Liam 32000.00
Sales 32000.00
Mike 18000.00
HR 18000.00
Sarah 22000.00
Finance 22000.00
Sophia 28000.00
IT 28000.00
Total Result 32000.00
Employee Department Sum of Sales
Alex 26000.00
IT 26000.00
David 15000.00
Sales 15000.00
Emma 24000.00
HR 24000.00
Grace 30000.00
Sales 30000.00
Jack 17000.00
Finance 17000.00
John 12000.00
Sales 12000.00
Liam 32000.00
Sales 32000.00
Mike 18000.00
HR 18000.00
Sarah 22000.00
Finance 22000.00
Sophia 28000.00
IT 28000.00
Total Result 224000.00
Alex 22000
South 22000
Emma 20000
East 20000
Grace 25000
North 25000
Liam 30000
West 30000
Sarah 20000
North 20000
Sophia 25000
East 25000
Total Result 142000
80000

Sum of OrdersProduct 70000

Region Laptops Phones Printers TabletsTotal Result
60000
East 10000 45000 55000
North 25000 20000 45000 50000
South 16000 22000 38000
West 14000 48000 62000 40000
Total Result 51000 59000 48000 42000 200000
30000

20000
Data
Product Total Sales Total Orders 10000

0
Product Lapt
 20000

10000

Laptops 57000.00 51000 0

Phones 70000.00 59000 Product Lapt
Printers 49000.00 48000
Tablets 48000.00 42000
Total Result 224000.00 200000
This shape represents a slicer.
Sum of Sales Region Slicers are supported in Excel
2010 or later.
Department North Total Result
Finance 22000.00 22000.00 If the shape was modified in
Total Result 22000.00 22000.00 an earlier version of Excel, or
if the workbook was saved in
Excel 2003 or earlier, the
slicer cannot be used.
80000 70000

70000 60000

60000
50000
50000
40000
40000 Data
30000 Column C
30000
20000
20000

10000 10000

0 0
Product Laptops Phones Printers Tablets
 20000
20000

10000 10000

0 0
Product Laptops Phones Printers Tablets

This shape represents a slicer.

Slicers are supported in Excel
2010 or later.

If the shape was modified in

an earlier version of Excel, or
if the workbook was saved in
Excel 2003 or earlier, the
slicer cannot be used.
Marks Grade
0-40 1
40-50 2
50-60 3
60-80 4
80-100 5
Roll No Eng hindi science maths sst
110 45 56 67 78 89
grade 2 3 4 4 5

1 NAME GENDER CLASS CATEGORY FEES

7 Jinal F TY Open 5000
8 Kavita F SY Open 4000
11 Abhay M TY Open 5000
15 Rima F TY Open 5000
16 GajendM SY Open 4000
EmpID Employee Department Region Product Month Sales Target Orders
Employee& Department
E101 John Sales East Laptops Jan 12000.00 10000 15 John Sales John Sales
E102 Mike HR West Phones Jan 18000.00 14000 20
E103 Sarah Finance North Tablets Feb 22000.00 20000 25
E104 David Sales South Laptops Feb 15000.00 16000 10
E105 Emma HR East Phones Mar 24000.00 20000 30
E106 Jack Finance West Printers Mar 17000.00 18000 12
E107 Grace Sales North Laptops Apr 30000.00 25000 40
E108 Alex IT South Tablets Apr 26000.00 22000 22
E109 Sophia IT East Phones May 28000.00 25000 35
E110 Liam Sales West Printers May 32000.00 30000 50

Liam
Sa* #NAME? Liam
22000 54000
###
### ### #NAME?
### #NAME?
### #NAME? #NAME?
### #NAME? #NAME?
### #NAME? #NAME?
### #NAME? #NAME?
### #NAME?
### #NAME? #NAME?
### #NAME? #NAME?
### #NAME? #NAME?
 10 John
7 Mike
6 Sarah
9 David
5 Emma
8 Jack
2 Grace
4 Alex
3 Sophia
1 Liam

#NAME? #NAME? #NAME?

#NAME? #NAME?
#NAME?

#NAME? Laptops
#NAME?
#NAME?
#NAME?

#NAME?
#NAME?
#NAME?
Sum of TotalSales Year
Month 2022 2023 Total Result
January 22346 26413 48759
February 6913 30601 37514
March 34505 37645 72150
April 23451 41135 64586
May 20930 25706 46636 Chart Title
June 27141 42243 69384 400000
July 13210 28970 42180
350000
August 31183 42838 74021
300000
September 24146 36114 60260
October 44082 12541 56623 250000
November 12012 20502 32514 200000
December 32834 32834 150000
Total Result 292753 344708 637461 100000
50000
0
ry ry ch ril ay ne uly ust ber ber ber ber su
nua rua ar Ap M Ju J ug m to m m e
Ja Feb M A pte Oc ve ce l R
e N o De ta
S T o
 Chart Title

Year 2022
2023

y ne July ust ber ber ber ber sult

Ju g o e
Au ptem Oct vem cem l R
e N o De ta
S T o
 OrderID Region Product Category SalesPerson OrderDate Year Month
O1000 North Monitor Electronics SP2 2022-01-01 2022 January
O1001 North Headset Accessories SP15 2022-01-08 2022 January
O1002 East Monitor Accessories SP2 2022-01-15 2022 January
O1003 South Headset Accessories SP12 2022-01-22 2022 January
O1004 South Tablet Accessories SP9 2022-01-29 2022 January
O1005 South Headset Accessories SP3 2022-02-05 2022 February
O1006 North Laptop Electronics SP5 2022-02-12 2022 February
O1007 North Laptop Electronics SP5 2/18/2022 2022 February
O1008 West Headset Electronics SP10 2022-02-26 2022 February
O1009 North Tablet Accessories SP4 2022-03-05 2022 March
O1010 North Tablet Accessories SP12 2022-03-12 2022 March
O1011 North Laptop Electronics SP6 2022-03-19 2022 March
O1012 South Tablet Electronics SP4 2022-03-26 2022 March
O1013 South Monitor Electronics SP11 2022-04-02 2022 April
O1014 North Phone Electronics SP11 2022-04-09 2022 April
O1015 South Monitor Accessories SP14 2022-04-16 2022 April
O1016 West Laptop Electronics SP5 2022-04-23 2022 April
O1017 South Tablet Accessories SP9 2022-04-30 2022 April
O1018 West Headset Electronics SP8 2022-05-07 2022 May
O1019 East Phone Accessories SP5 2022-05-14 2022 May
O1020 North Headset Accessories SP15 2022-05-21 2022 May
O1021 South Laptop Electronics SP15 2022-05-28 2022 May
O1022 West Tablet Electronics SP14 2022-06-04 2022 June
O1023 East Headset Accessories SP1 2022-06-11 2022 June
O1024 East Headset Electronics SP2 2022-06-18 2022 June
O1025 South Phone Electronics SP11 2022-06-25 2022 June
O1026 South Phone Electronics SP7 2022-07-02 2022 July
O1027 East Tablet Electronics SP14 2022-07-09 2022 July
O1028 North Phone Electronics SP5 2022-07-16 2022 July
O1029 North Headset Electronics SP1 2022-07-23 2022 July
O1030 West Headset Accessories SP1 2022-07-30 2022 July
O1031 North Laptop Accessories SP6 2022-08-06 2022 August
O1032 East Headset Accessories SP13 2022-08-13 2022 August
O1033 East Tablet Electronics SP3 2022-08-20 2022 August
O1034 East Monitor Accessories SP11 2022-08-27 2022 August
O1035 North Laptop Electronics SP5 2022-09-03 2022 September
O1036 West Laptop Electronics SP3 2022-09-10 2022 September
O1037 North Tablet Accessories SP12 2022-09-17 2022 September
O1038 West Tablet Electronics SP8 2022-09-24 2022 September
O1039 North Phone Accessories SP9 2022-10-01 2022 October
O1040 East Laptop Accessories SP12 2022-10-08 2022 October
O1041 East Phone Accessories SP7 2022-10-15 2022 October
O1042 South Headset Accessories SP9 2022-10-22 2022 October
O1043 North Laptop Accessories SP1 2022-10-29 2022 October
O1044 North Laptop Accessories SP2 2022-11-05 2022 November
O1045 South Monitor Electronics SP2 2022-11-12 2022 November
O1046 East Laptop Electronics SP15 2022-11-19 2022 November
O1047 North Headset Accessories SP12 2022-11-26 2022 November
O1048 South Phone Electronics SP15 2022-12-03 2022 December
O1049 North Phone Electronics SP3 2022-12-10 2022 December
O1050 West Monitor Electronics SP9 2022-12-17 2022 December
O1051 East Headset Accessories SP1 2022-12-24 2022 December
O1052 West Phone Electronics SP14 2022-12-31 2022 December
O1053 East Tablet Electronics SP6 2023-01-07 2023 January
O1054 South Headset Accessories SP10 2023-01-14 2023 January
O1055 East Headset Electronics SP9 2023-01-21 2023 January
O1056 East Monitor Electronics SP3 2023-01-28 2023 January
O1057 South Phone Electronics SP7 2023-02-04 2023 February
O1058 East Headset Electronics SP3 2023-02-11 2023 February
O1059 North Phone Electronics SP1 2023-02-18 2023 February
O1060 South Tablet Electronics SP5 2023-02-25 2023 February
O1061 South Monitor Electronics SP6 2023-03-04 2023 March
O1062 South Tablet Accessories SP15 2023-03-11 2023 March
O1063 West Monitor Electronics SP15 2023-03-18 2023 March
O1064 West Headset Electronics SP13 2023-03-25 2023 March
O1065 East Monitor Electronics SP14 2023-04-01 2023 April
O1066 South Laptop Electronics SP1 2023-04-08 2023 April
O1067 East Phone Accessories SP15 2023-04-15 2023 April
O1068 North Phone Accessories SP6 2023-04-22 2023 April
O1069 South Laptop Accessories SP4 2023-04-29 2023 April
O1070 North Tablet Electronics SP11 2023-05-06 2023 May
O1071 East Laptop Accessories SP4 2023-05-13 2023 May
O1072 West Headset Electronics SP11 2023-05-20 2023 May
O1073 East Headset Accessories SP2 2023-05-27 2023 May
O1074 North Phone Accessories SP6 2023-06-03 2023 June
O1075 South Headset Electronics SP13 2023-06-10 2023 June
O1076 East Phone Accessories SP9 2023-06-17 2023 June
O1077 South Laptop Accessories SP15 2023-06-24 2023 June
O1078 West Laptop Accessories SP14 2023-07-01 2023 July
O1079 West Laptop Electronics SP7 2023-07-08 2023 July
O1080 West Phone Electronics SP10 2023-07-15 2023 July
O1081 South Laptop Accessories SP12 2023-07-22 2023 July
O1082 East Laptop Electronics SP3 2023-07-29 2023 July
O1083 South Tablet Electronics SP15 2023-08-05 2023 August
O1084 South Laptop Electronics SP15 2023-08-12 2023 August
O1085 East Headset Accessories SP4 2023-08-19 2023 August
O1086 West Phone Electronics SP14 2023-08-26 2023 August
O1087 West Tablet Accessories SP3 2023-09-02 2023 September
O1088 East Monitor Electronics SP13 2023-09-09 2023 September
O1089 South Phone Electronics SP13 2023-09-16 2023 September
O1090 South Headset Accessories SP3 2023-09-23 2023 September
O1091 West Phone Accessories SP15 2023-09-30 2023 September
O1092 North Headset Electronics SP7 2023-10-07 2023 October
O1093 North Headset Accessories SP1 2023-10-14 2023 October
O1094 North Monitor Accessories SP3 2023-10-21 2023 October
O1095 South Phone Electronics SP12 2023-10-28 2023 October
O1096 South Monitor Accessories SP15 2023-11-04 2023 November
O1097 West Monitor Electronics SP6 2023-11-11 2023 November
O1098 North Phone Electronics SP13 2023-11-18 2023 November
τ West Laptop Accessories SP15 2023-11-25 2023 November
 Weekday Quantity UnitPrice TotalSales Concat Column1 Product type
Saturday 7 1477 10339 Monitor - $1477 #NAME? Accessories
Saturday 4 735 2940 Headset - $735 #NAME? Accessories
Saturday 5 560 2800 Monitor - $560 #NAME? Accessories
Saturday 3 1751 5253 Headset - $1751 #NAME? Accessories
Saturday 2 507 1014 Tablet - $507 #NAME? Electronics
Saturday 7 401 2807 Headset - $401 #NAME? Accessories
Saturday 1 150 150 Laptop - $150 #NAME? Electronics
Friday 8 194 1552 Laptop - $194 #NAME? Electronics
Saturday 4 601 2404 Headset - $601 #NAME? Accessories
Saturday 4 1073 4292 Tablet - $1073 #NAME? Electronics
Saturday 8 1351 10808 Tablet - $1351 #NAME? Electronics
Saturday 6 1840 11040 Laptop - $1840 #NAME? Electronics
Saturday 5 1673 8365 Tablet - $1673 #NAME? Electronics
Saturday 4 249 996 Monitor - $249 #NAME? Accessories
Saturday 4 1032 4128 Phone - $1032 #NAME? Electronics
Saturday 1 948 948 Monitor - $948 #NAME? Accessories
Saturday 4 1914 7656 Laptop - $1914 #NAME? Electronics
Saturday 7 1389 9723 Tablet - $1389 #NAME? Electronics
Saturday 6 1278 7668 Headset - $1278 #NAME? Accessories
Saturday 5 498 2490 Phone - $498 #NAME? Electronics
Saturday 2 1571 3142 Headset - $1571 #NAME? Accessories
5 1526 7630 Laptop - $1526 #NAME? Electronics
Saturday 6 886 5316 Tablet - $886 #NAME? Electronics
Saturday 9 1112 10008 Headset - $1112 #NAME? Accessories
7 918 6426 Headset - $918 #NAME? Accessories
Saturday 9 599 5391 Phone - $599 #NAME? Electronics
6 402 2412 Phone - $402 #NAME? Electronics
1 1443 1443 Tablet - $1443 #NAME? Electronics
2 1508 3016 Phone - $1508 #NAME? Electronics
Saturday 5 111 555 Headset - $111 #NAME? Accessories
3 1928 5784 Headset - $1928 #NAME? Accessories
10 1637 16370 Laptop - $1637 #NAME? Electronics
5 1862 9310 Headset - $1862 #NAME? Accessories
1 1677 1677 Tablet - $1677 #NAME? Electronics
2 1913 3826 Monitor - $1913 #NAME? Accessories
Saturday 10 318 3180 Laptop - $318 #NAME? Electronics
Saturday 7 1694 11858 Laptop - $1694 #NAME? Electronics
Saturday 6 970 5820 Tablet - $970 #NAME? Electronics
Saturday 6 548 3288 Tablet - $548 #NAME? Electronics
Saturday 7 460 3220 Phone - $460 #NAME? Electronics
Saturday 10 1746 17460 Laptop - $1746 #NAME? Electronics
Saturday 9 1525 13725 Phone - $1525 #NAME? Electronics
Saturday 2 1160 2320 Headset - $1160 #NAME? Accessories
Saturday 7 1051 7357 Laptop - $1051 #NAME? Electronics
Saturday 10 202 2020 Laptop - $202 #NAME? Electronics
Saturday 4 1241 4964 Monitor - $1241 #NAME? Accessories
Saturday 5 610 3050 Laptop - $610 #NAME? Electronics
Saturday 1 1978 1978 Headset - $1978 #NAME? Accessories
Saturday 7 1837 12859 Phone - $1837 #NAME? Electronics
Saturday 1 348 348 Phone - $348 #NAME? Electronics
Saturday 9 1034 9306 Monitor - $1034 #NAME? Accessories
Saturday 9 373 3357 Headset - $373 #NAME? Accessories
Saturday 4 1741 6964 Phone - $1741 #NAME? Electronics
Saturday 6 1051 6306 Tablet - $1051 #NAME? Electronics
Saturday 7 1467 10269 Headset - $1467 #NAME? Accessories
Saturday 2 1187 2374 Headset - $1187 #NAME? Accessories
Saturday 6 1244 7464 Monitor - $1244 #NAME? Accessories
Saturday 10 1319 13190 Phone - $1319 #NAME? Electronics
Saturday 6 749 4494 Headset - $749 #NAME? Accessories
Saturday 2 1646 3292 Phone - $1646 #NAME? Electronics
Saturday 5 1925 9625 Tablet - $1925 #NAME? Electronics
Saturday 9 1006 9054 Monitor - $1006 #NAME? Accessories
Saturday 5 1354 6770 Tablet - $1354 #NAME? Electronics
Saturday 7 1769 12383 Monitor - $1769 #NAME? Accessories
Saturday 6 1573 9438 Headset - $1573 #NAME? Accessories
Saturday 7 1926 13482 Monitor - $1926 #NAME? Accessories
Saturday 5 1133 5665 Laptop - $1133 #NAME? Electronics
Saturday 9 973 8757 Phone - $973 #NAME? Electronics
Saturday 3 1801 5403 Phone - $1801 #NAME? Electronics
Saturday 4 1957 7828 Laptop - $1957 #NAME? Electronics
Saturday 7 1222 8554 Tablet - $1222 #NAME? Electronics
Saturday 7 1013 7091 Laptop - $1013 #NAME? Electronics
Saturday 3 1937 5811 Headset - $1937 #NAME? Accessories
Saturday 10 425 4250 Headset - $425 #NAME? Accessories
Saturday 10 1623 16230 Phone - $1623 #NAME? Electronics
Saturday 5 1864 9320 Headset - $1864 #NAME? Accessories
Saturday 7 1072 7504 Phone - $1072 #NAME? Electronics
Saturday 9 1021 9189 Laptop - $1021 #NAME? Electronics
Saturday 1 630 630 Laptop - $630 #NAME? Electronics
Saturday 5 1639 8195 Laptop - $1639 #NAME? Electronics
Saturday 5 606 3030 Phone - $606 #NAME? Electronics
Saturday 4 1820 7280 Laptop - $1820 #NAME? Electronics
Saturday 7 1405 9835 Laptop - $1405 #NAME? Electronics
Saturday 10 667 6670 Tablet - $667 #NAME? Electronics
Saturday 10 1668 16680 Laptop - $1668 #NAME? Electronics
Saturday 6 1692 10152 Headset - $1692 #NAME? Accessories
Saturday 8 1167 9336 Phone - $1167 #NAME? Electronics
Saturday 8 1092 8736 Tablet - $1092 #NAME? Electronics
Saturday 8 1383 11064 Monitor - $1383 #NAME? Accessories
Saturday 4 589 2356 Phone - $589 #NAME? Electronics
Saturday 9 662 5958 Headset - $662 #NAME? Accessories
Saturday 8 1000 8000 Phone - $1000 #NAME? Electronics
Saturday 3 258 774 Headset - $258 #NAME? Accessories
Saturday 2 1561 3122 Headset - $1561 #NAME? Accessories
Saturday 5 685 3425 Monitor - $685 #NAME? Accessories
Saturday 9 580 5220 Phone - $580 #NAME? Electronics
Saturday 10 656 6560 Monitor - $656 #NAME? Accessories
Saturday 6 787 4722 Monitor - $787 #NAME? Accessories
Saturday 2 754 1508 Phone - $754 #NAME? Electronics
Saturday 4 1928 7712 Laptop - $1928 #NAME? Electronics
 Text Join
Monitor Electronics 1477 #NAME?
Headset Accessories #NAME?
Monitor Accessories Total Sales #NAME?
Headset Accessories 17460 SP12 #NAME?
Tablet Accessories
Headset Accessories
Laptop Electronics Laptop Laptop Laptop
Laptop Electronics
Headset Electronics
Tablet Accessories #NAME?
Tablet Accessories #NAME? #NAME? #NAME?
Laptop Electronics #NAME? #NAME? #NAME?
Tablet Electronics #NAME? #NAME? #NAME?
Monitor Electronics #NAME? #NAME? #NAME?
Phone Electronics
Monitor Accessories
Laptop Electronics 150 Laptop
Tablet Accessories
Headset Electronics 7
Phone Accessories
Headset Accessories #NAME? #NAME? Total Sales
Laptop Electronics #NAME? #NAME? #NAME? #NAME?
Tablet Electronics #NAME? #NAME? #NAME? #NAME?
Headset Accessories #NAME? #NAME? #NAME? #NAME?
Headset Electronics #NAME? #NAME? #NAME? #NAME?
Phone Electronics #NAME? #NAME? #NAME? #NAME?
Phone Electronics #NAME? #NAME? #NAME?
Tablet Electronics #NAME? #NAME?
Phone Electronics #NAME? #NAME?
Headset Electronics #NAME? #NAME? #NAME?
Headset Accessories #NAME? #NAME?
Laptop Accessories #NAME? #NAME?
Headset Accessories 134563 #NAME? #NAME?
Tablet Electronics #NAME? #NAME?
Monitor Accessories #NAME? #NAME?
Laptop Electronics #NAME? #NAME?
Laptop Electronics
Tablet Accessories
Tablet Electronics #NAME?
Phone Accessories
Laptop Accessories
Phone Accessories
Headset Accessories
Laptop Accessories
Laptop Accessories
Monitor Electronics
Laptop Electronics
Headset Accessories
Phone Electronics
Phone Electronics
Monitor Electronics
Headset Accessories
Phone Electronics
Tablet Electronics
Headset Accessories
Headset Electronics
Monitor Electronics
Phone Electronics
Headset Electronics
Phone Electronics
Tablet Electronics
Monitor Electronics
Tablet Accessories
Monitor Electronics
Headset Electronics
Monitor Electronics
Laptop Electronics
Phone Accessories
Phone Accessories
Laptop Accessories
Tablet Electronics
Laptop Accessories
Headset Electronics
Headset Accessories
Phone Accessories
Headset Electronics
Phone Accessories
Laptop Accessories
Laptop Accessories
Laptop Electronics
Phone Electronics
Laptop Accessories
Laptop Electronics
Tablet Electronics
Laptop Electronics
Headset Accessories
Phone Electronics
Tablet Accessories
Monitor Electronics
Phone Electronics
Headset Accessories
Phone Accessories
Headset Electronics
Headset Accessories
Monitor Accessories
Phone Electronics
Monitor Accessories
Monitor Electronics
Phone Electronics
Laptop Accessories
 #NAME?
#NAME?
39140 30799 56602 #NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?

Commission
#NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
 Salesperson Region Product Month Sales
John North Shoes Jan 12000 North Shoes
Sara North Bags Feb 18000
Mike East Shoes Jan 15000
West Clothes Jan 8000
East Bags Mar 20000
West Shoes Feb 14000
South Clothes Mar 22000
North Clothes Feb 17000
East Shoes Mar 25000
West Bags Jan 30000

Tigerine

Month total Sales [Link] Orders AOV

Jan 45,000,000 1500 30,000
Feb 52,500,000 1725 30,000
Target (March) 100,000,000 3333 30,000

100,000,000 3030.30303 33000

Salesperson Region Product Month Sales Concat 181000

John North Shoes Jan 12000 [Link]@[Link] 30000
John North Bags Feb 18000 [Link]@[Link] 37000
Sara East Shoes Jan 15000 [Link]@[Link] 60000
Mike West Clothes Jan 8000 [Link]@[Link] 39000
Sara East Bags Mar 20000 [Link]@[Link]
Mike West Shoes Feb 14000 [Link]@[Link]
John South Clothes Mar 22000 [Link]@[Link]
Sara North Clothes Feb 17000 [Link]@[Link]
Mike East Shoes Mar 25000 [Link]@[Link]
John West Bags Jan 30000 [Link]@[Link]
181000 41000

12000 nala pala tricolour 1 Name nala

18000 nala pala White and grey 2.5 color White and grey
nala pala White and grey 3.5 #NAME?
0 dura cat Tigerine 7
fur bat Grey 11
16500 jane jat Black and white 4 name
#DIV/0! pooh ka Black 6 age

Name
colour
8/25/2025 #N/A
11:15

Name
11-Jun-25 color

#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
White and grey

nala
2

#NAME?

nala
white and grey

#NAME?

nala
White and grey
#NAME?
ID Name Dept Region Month Sales Target Join Date Year Month
1 Mike Sales East Jan $ 1,200.00 1000 1/1/2022 2022.00 January
2 John Marketing West Jan $ 800.00 900 2/15/2021 2021.00 February
3 Sara Operations East Feb $ 1,500.00 1200 3/10/2020 2020.00 March
4 Anita HR North Mar $ 600.00 700 4/25/2019 2019.00 April
5 Alex Sales South Jan $ 2,000.00 1500 5/11/2018 2018.00 May
6 David Operations East Feb $ 1,700.00 1600 6/9/2017 2017.00 June
7 Emma Marketing West Apr $ 900.00 1000 7/13/2022 2022.00 July
8 Rahul Sales East Feb $ 2,200.00 2000 8/14/2021 2021.00 August
9 Priya HR North Jan $ 700.00 800 9/20/2020 2020.00 September
10 Steve Operations South Mar $ 1,300.00 1200 10/30/2019 2019.00 October
11 Nisha Sales East Apr $ 2,500.00 2200 11/15/2018 2018.00 November
12 Omar Marketing West Feb $ 1,100.00 1000 12/18/2021 2021.00 December
13 Tina HR North Jan $ 750.00 850 1/2/2017 2017.00 January
14 Raj Operations South Feb $ 1,900.00 1800 2/19/2020 2020.00 February
15 Chloe Sales East Mar $ 2,100.00 2000 3/23/2019 2019.00 March
16 Aryan Marketing West Jan $ 950.00 1000 4/12/2022 2022.00 April
17 Sophia HR North Apr $ 800.00 900 5/21/2018 2018.00 May
18 Liam Operations South Mar $ 1,750.00 1600 6/17/2021 2021.00 June
19 Arjun Sales East Feb $ 2,400.00 2200 7/5/2020 2020.00 July
20 Zoe Marketing West Mar $ 1,000.00 950 8/8/2019 2019.00 August
28150
1407.5

#NAME? ###
#NAME? ### 2020 7 #NAME? 1
#NAME? ###
#NAME? ###
#NAME? ### 1
#NAME? ### 20
#NAME? ###
#NAME? ###
#NAME? ###
#NAME?
#NAME?
#NAME?
#NAME?
Experience Age Bonus Grade Name and Dept Email Id
#NAME? 29 200 B Mike Sales [Link]@[Link]
35 150 C John Marketing 7
31 250 A Sara Operations 4
42 100 B Anita HR
28 300 A Alex Sales 12400
33 350 A David Operations 7800
26 120 C Emma Marketing 0
30 400 A Rahul Sales
40 180 B Priya HR
37 200 B Steve Operations
32 450 A Nisha Sales
27 160 B Omar Marketing
44 140 C Tina HR
36 300 A Raj Operations
34 420 A Chloe Sales
25 100 C Aryan Marketing
38 130 B Sophia HR
29 280 A Liam Operations
31 500 A Arjun Sales
33 150 B Zoe Marketing

#NAME? 4 #NAME? #NAME? #NAME?

#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
 Name Sales Target Employee Department Region Month Sales
Mike 1200 1000 John HR East Jan 12000
John 800 900 Mary Finance West Jan 18000
Sara 1500 1200 Alex IT North Feb 15000
Anita 600 700 Sara Operations East Feb 10000
Alex 2000 1500 Mike HR South Mar 20000
David 1700 1600 Emma Finance North Mar 9000
Emma 900 1000 Jack IT West Apr 25000
Rahul 2200 2000 David Operations East Apr 14000
Priya 700 800 Sophia HR South May 30000
Steve 1300 1200 Liam Finance North May 16000
Nisha 2500 2200
Omar 1100 1000 Employee Department Region Month Sales
Tina 750 850 John HR East Jan 12000
Raj 1900 1800 Mary Finance West Jan 18000
Chloe 2100 2000 Alex IT North Feb 15000
Aryan 950 1000 Sara Operations East Feb 10000
Sophia 800 900 Mike HR South Mar 20000
Liam 1750 1600 Emma Finance North Mar 9000
Arjun 2400 2200 Jack IT West Apr 25000
Zoe 1000 950 David Operations East Apr 14000
Sophia HR South May 30000
Liam Finance North May 16000

Employee Department Region Month Sales

John HR East Jan 12000
Mary Finance West Jan 18000
Alex IT North Feb 15000
Sara Operations East Feb 10000
Mike HR South Mar 20000
Emma Finance North Mar 9000
Jack IT West Apr 25000
David Operations East Apr 14000
Sophia HR South May 30000
Liam Finance North May 16000

Employee Department Region Month Sales Target Employee Department Region Month
John HR East Jan 12000 15000 John HR East Jan
Mary Finance West Jan 18000 17000 Mary Finance West Jan
Alex IT North Feb 15000 14000 Alex IT North Feb
Sara Operations East Feb 10000 12000 Sara Operations East Feb
Mike HR South Mar 20000 19000 Mike HR South Mar
Emma Finance North Mar 9000 15000 Emma Finance North Mar
Jack IT West Apr 25000 20000 Jack IT West Apr
David Operations East Apr 14000 16000 David Operations East Apr
Sophia HR South May 30000 25000 Sophia HR South May
Liam Finance North May 16000 17000 Liam Finance North May
 Employee Department Region Month Sales Target Employee Department Region Month
John HR East Jan 12000 15000 John HR East Jan
Mary Finance West Jan 18000 17000 Mary Finance West Jan
Alex IT North Feb 15000 14000 Alex IT North Feb
Sara Operations East Feb 10000 12000 Sara Operations East Feb
Mike HR South Mar 20000 19000 Mike HR South Mar
Emma Finance North Mar 9000 15000 Emma Finance North Mar
Jack IT West Apr 25000 20000 Jack IT West Apr
David Operations East Apr 14000 16000 David Operations East Apr
Sophia HR South May 30000 25000 Sophia HR South May
Liam Finance North May 16000 17000 Liam Finance North May

Employee Department Region Month

John HR East Jan
Mary Finance West Jan
Alex IT North Feb
Sara Operations East Feb
Mike HR South Mar
Emma Finance North Mar
Jack IT West Apr
David Operations East Apr
Sophia HR South May
Liam Finance North May

Employee Department Region Month

Alex IT North Feb
Emma Finance North Mar
Liam Finance North May
Target Employee Department Region Month Sales Target
15000 John HR East Jan 12000 15000 -20
17000 Mary Finance West Jan 18000 17000 5.882353
14000 Alex IT North Feb 15000 14000 7.142857
12000 Sara Operations East Feb 10000 12000 -16.66667
19000 Mike HR South Mar 20000 19000 5.263158
15000 Emma Finance North Mar 9000 15000 -40
20000 Jack IT West Apr 25000 20000 25
16000 David Operations East Apr 14000 16000 -12.5
25000 Sophia HR South May 30000 25000 20
17000 Liam Finance North May 16000 17000 -5.882353

Target Employee Department Region Month Sales Target

15000 John HR East Jan 12000 15000
17000 Mary Finance West Jan 18000 17000
14000 Alex IT North Feb 15000 14000
12000 Sara Operations East Feb 10000 12000
19000 Mike HR South Mar 20000 19000
15000 Emma Finance North Mar 9000 15000
20000 Jack IT West Apr 25000 20000
16000 David Operations East Apr 14000 16000
25000 Sophia HR South May 30000 25000
17000 Liam Finance North May 16000 17000

Target Employee Department Region Month Sales Target Employee

15000 John HR East Jan 12000 15000 John
17000 Mary Finance West Jan 18000 17000 Mary
14000 Alex IT North Feb 15000 14000 Alex
12000 Sara Operations East Feb 10000 12000 Sara
19000 Mike HR South Mar 20000 19000 Mike
15000 Emma Finance North Mar 9000 15000 Emma
20000 Jack IT West Apr 25000 20000 Jack
16000 David Operations East Apr 14000 16000 David
25000 Sophia HR South May 30000 25000 Sophia
17000 Liam Finance North May 16000 17000 Liam

Sales Target EmployeeDepartmentRegion Month Sales Target

12000 15000 John HR East Jan 12000 15000
18000 17000 Mary Finance West Jan 18000 17000
15000 14000 Alex IT North Feb 15000 14000
10000 12000 Sara OperatioEast Feb 10000 12000
20000 19000 Mike HR South Mar 20000 19000
9000 15000 Emma Finance North Mar 9000 15000
25000 20000 Jack IT West Apr 25000 20000
14000 16000 David OperatioEast Apr 14000 16000
30000 25000 Sophia HR South May 30000 25000
16000 17000 Liam Finance North May 16000 17000
Sales Target EmployeeDepartmentRegion Month Sales Target
12000 15000 John HR East Jan 12000 15000
18000 17000 Mary Finance West Jan 18000 17000
15000 14000 Alex IT North Feb 15000 14000
10000 12000 Sara OperatioEast Feb 10000 12000
20000 19000 Mike HR South Mar 20000 19000
9000 15000 Emma Finance North Mar 9000 15000
25000 20000 Jack IT West Apr 25000 20000
14000 16000 David OperatioEast Apr 14000 16000
30000 25000 Sophia HR South May 30000 25000
16000 17000 Liam Finance North May 16000 17000

14500
Sales Target EmployeeDepartmentRegion Month Sales Target
12000 15000 John HR East Jan 12000 15000
18000 17000 Mary Finance West Jan 18000 17000
15000 14000 Alex IT North Feb 15000 14000
10000 12000 Sara OperatioEast Feb 10000 12000
20000 19000 Mike HR South Mar 20000 19000
9000 15000 Emma Finance North Mar 9000 15000
25000 20000 Jack IT West Apr 25000 20000
14000 16000 David OperatioEast Apr 14000 16000
30000 25000 Sophia HR South May 30000 25000
16000 17000 Liam Finance North May 16000 17000

Sales Target
15000 14000
9000 15000
16000 17000

### ###
### ###
### ###
### ###
Department Region Month Sales Target
HR East Jan 12000 15000
Finance West Jan 18000 17000
IT North Feb 15000 14000
OperationsEast Feb 10000 12000
HR South Mar 20000 19000
Finance North Mar 9000 15000
IT West Apr 25000 20000
OperationsEast Apr 14000 16000
HR South May 30000 25000
Finance North May 16000 17000

EmployeeDepartment Region Month Sales Target

John HR East Jan 12000 15000
Mary Finance West Jan 18000 17000
Alex IT North Feb 15000 14000
Sara OperationsEast Feb 10000 12000
Mike HR South Mar 20000 19000
Emma Finance North Mar 9000 15000
Jack IT West Apr 25000 20000
David OperationsEast Apr 14000 16000
Sophia HR South May 30000 25000
Liam Finance North May 16000 17000
EmployeeDepartment Region Month Sales Target
John HR East Jan 12000 15000
Mary Finance West Jan 18000 17000
Alex IT North Feb 15000 14000
Sara OperationsEast Feb 10000 12000
Mike HR South Mar 20000 19000
Emma Finance North Mar 9000 15000
Jack IT West Apr 25000 20000
David OperationsEast Apr 14000 16000
Sophia HR South May 30000 25000
Liam Finance North May 16000 17000

EmployeeDepartment Region Month Sales Target

John HR East Jan 12000 15000
Mary Finance West Jan 18000 17000
Alex IT North Feb 15000 14000
Sara OperationsEast Feb 10000 12000
Mike HR South Mar 20000 19000
Emma Finance North Mar 9000 15000
Jack IT West Apr 25000 20000
David OperationsEast Apr 14000 16000
Sophia HR South May 30000 25000
Liam Finance North May 16000 17000
 Departme
Emp ID Name Department Sales Target Emp ID Name
nt
101 Alex HR 42000 50000 101 Alex HR
102 Maria Finance 55000 50000 102 Maria Finance
103 John IT 49000 45000 103 John IT
104 Sara Finance 70000 60000 104 Sara Finance
105 Mike HR 35000 40000 105 Mike HR
106 Priya IT 62000 60000 106 Priya IT
107 David Finance 47000 50000 107 David Finance
108 Riya IT 51000 55000 108 Riya IT
109 Tom HR 38000 45000 109 Tom HR
110 Neha Finance 65000 60000 110 Neha Finance

EmpID Name Department Region Month Sales Target Rating Q1

E001 Alice HR East Jan 12000 15000 B 3000 0 -20 Q2
E002 Bob Finance West Jan 18000 17000 A 1000 FALSE 5.882353 Q3
E003 Charlie IT North Jan 22000 20000 A 2000 FALSE 10 Q4
E004 David HR South Jan 14000 16000 C 2000 FALSE -12.5 Q5
E005 Eva Finance East Jan 20000 18000 A 2000 FALSE 11.11111 Q11
E006 Frank IT West Jan 25000 23000 A 2000 FALSE 8.695652 Q12
E007 Grace HR North Feb 17000 16000 B 1000 FALSE 6.25 Q13
E008 Henry Finance South Feb 15000 18000 C 3000 FALSE -16.66667 Q15
E009 Irene IT East Feb 26000 25000 A 1000 FALSE 4 Q18
E010 Jack HR West Feb 13000 14000 B 1000 FALSE -7.142857 Q21
E011 Karen Finance North Feb 22000 21000 A 1000 FALSE 4.761905 Q22
E012 Leo IT South Feb 28000 27000 A 1000 FALSE 3.703704 Q23
E013 Maria HR East Mar 16000 15000 B 1000 FALSE 6.666667 Q24
E014 Nathan Finance West Mar 19000 20000 C 1000 FALSE -5 Q25
E015 Olivia IT North Mar 24000 22000 A 2000 FALSE 9.090909 Q26
E016 Peter HR South Mar 15000 16000 C 1000 FALSE -6.25 Q27
E017 Quinn Finance East Mar 21000 20000 A 1000 FALSE 5 Q33
E018 Ryan IT West Mar 27000 26000 A 1000 FALSE 3.846154 Q34
E019 Sarah HR North Mar 18000 17000 B 1000 FALSE 5.882353
E020 Tom Finance South Mar 23000 22000 A 1000 FALSE 4.545455 Q34
E010 Jack HR West Jun 25000 10000 B 15000 FALSE 150 Q43

### ###
### ###
### ###
### ###
EmpID Name Dept Region Month Sales Target #NAME?
E101 John Finance East Jan 12000 10000
E102 Sarah HR West Jan 15000 14000
E103 Mike Finance North Feb 10000 13000
E104 Lisa HR South Feb 18000 17000
E105 Tom IT East Mar 14000 11000
E106 Emma Finance West Mar 20000 16000
E107 Raj Sales North Apr 17000 15000
E108 Priya IT South Apr 19000 18000
E109 Alex HR East May 16000 15500
E110 David Sales West May 21000 20000
 Sales Target
42000 50000
55000 50000
49000 45000
70000 60000
35000 40000
62000 60000
47000 50000
51000 55000
38000 45000
65000 60000

13000
Finance Department
North #NAME? #NAME?
20000 #NAME? #NAME?
Feb Jun #NAME? #NAME?
12000
#NAME?
27000 #N/A
#NAME?
North
28000
Henry
Bob
South
Feb
Bob
East
#N/A
Grace

Jack
Alice
Alice
Alice
Alice
Alice
Alice
Alice
Alice
Alice
Alice
Alice
Alice
Alice
Alice
Alice
Alice
Alice
Alice
Alice
Alice
Alice

HR
Lisa #N/A

David
Employee
Department
Gender Age Salary YearsExperience Location
Asha FinanF 45 55000 12 Delhi
Rohan IT M 32 72000 7 Mumbai
Priya HR F 29 48000 5 Delhi
Anil FinanM 50 90000 20 Kolkata
Neha OperaF 35 60000 10 Mumbai
Kiran IT M 42 82000 15 Bangalore
Meera HR F 28 40000 2 Delhi
Suraj OperaM 38 45000 8 Mumbai
Divya FinanF 41 75000 14 Delhi
Arjun IT M 36 95000 9 Chennai

Student Class Subject Marks Fail Gender Attendance%

Rahul 12 Math 95 No M 92
Sneha 11 Science 88 No F 78
Arjun 12 History 72 No M 65
Kavya 10 Math 45 No F 80
Manish 11 Science 55 No M 60
Riya 12 English 33 Yes F 45
Ajay 10 History 62 No M 85
Sonia 11 Math 82 No F 77
Deepak 12 Science 91 No M 93
Pooja 10 English 28 Yes F 40

PatientID Age Gender Disease DaysAdmitted BillAmount

P001 65 M Diabetes 8 55000
P002 42 F Cancer 15 120000
P003 28 M Fever 3 8000
P004 55 F Heart Disease 10 95000
P005 70 M Diabetes 12 70000
P006 34 F Cancer 5 45000
P007 22 M Accident 6 60000
P008 60 F Diabetes 14 85000
P009 30 F Fever 2 5000
P010 80 M Heart Disease 20 150000
 EmpID Name Department
Q1 3 E001 Alice HR
Q2 1 E002 Bob Finance
Q3 0 E003 Charlie IT
Q4 Department E004 David HR
#NAME? #NAME? E005 Eva Finance
#NAME? #NAME? E006 Frank IT
#NAME? Value does not exist E007 Grace HR
#NAME? #NAME? E008 Henry Finance
Q5 4 E009 Irene IT
E010 Jack HR
E011 Karen Finance
Q6 2 E012 Leo IT
Q9 2 E013 Maria HR
Q10 93 E014 Nathan Finance
Q11 E015 Olivia IT
E016 Peter HR
E017 Quinn Finance
E018 Ryan IT
E019 Sarah HR
E020 Tom Finance

Customer Product
Q11 3 John Smartphon
Q12 150000 James Laptop
Q13 34000 Alice Tablet
Q14 1 Darwan Smartphon
Q15 40 John Tablet
 Region Month Sales Target Rating
East Jan 12000 15000 B 28000
West Jan 18000 17000 A #NAME?
North Jan 22000 20000 A #N/A
South Jan 14000 16000 C
East Jan 20000 18000 A
West Jan 25000 23000 A
North Feb 17000 16000 B
South Feb 15000 18000 C #NAME? Finance
East Feb 26000 25000 A #NAME?
West Feb 13000 14000 B #NAME?
North Feb 22000 21000 A
South Feb 28000 27000 A
East Mar 16000 15000 B
West Mar 19000 20000 C
North Mar 24000 22000 A
South Mar 15000 16000 C
East Mar 21000 20000 A
West Mar 27000 26000 A
North Mar 18000 17000 B
South Mar 23000 22000 A

Date Sales Customer Product Date Sales

1-Jul-24 100 John Smartphon 1-Jul-24 #NAME?
2-Jul-24 150
3-Jul-24 250
4-Jul-24 300
5-Jul-24 450