Entity Sales 2022 Sales 2023 Sales 2024 ID First Name
West_01 $ 300.00 $ 336.00 $ 403.00 72 Emily
West_02 $ 400.00 $ 448.00 $ 538.00 66 James
west_03 $ 100.00 $ 112.00 $ 134.00 14 mila
west_04 $ 200.00 $ 224.00 $ 269.00 30 John
West_01 $ 320.00 $ 358.00 $ 430.00 53 Jessica
West_02 $ 350.00 $ 392.00 $ 470.00 56 Mark
west_03 $ 360.00 $ 403.00 $ 484.00 79 Richard
west_04 $ 370.00 $ 414.00 $ 497.00
west_03 Sales 2024 134
Last Name Salary ID 14
Smith $ 64,901.00 Salary 188657
Anderson $ 70,855.00 Jan
Clark $ 188,657.00 Feb
Lewis $ 97,566.00 Mar
Walkar $ 58,339.00 Apr
Reed $ 125,180.00 May
Lopez $ 91,632.00 Jun
Jul
Aug
Sep
Oct
Nov
Dec
Chocolate Strawberry Vanila Month Apr
544 639 189 Flavor Vanila
217 719 679 Sales 929
810 178 810
567 926 929
745 230 364
298 820 947
457 522 832
495 500 239
871 391 529
585 225 791
478 262 540
741 883 809
Emp. ID EMP. Name Sales -2019 Sales-2020 Sales-2021
S001 Suraj 192000 555000 950000
S002 Puram 183000 325000 875000
S003 Gopal 210000 650000 880000
S004 Rohan 425000 875000 894000
S005 Soham 198000 380000 895000
S006 Mohit 168000 555000 694000
S007 Rupak 215000 325000 895000
S008 Kunal 365000 745000 650000
S009 Pooja 260000 635000 875000
S010 Subrata 250000 759000 780000
Sales Rohan
Sales -2019 210000
Sales-2020 650000
Sales-2021 880000
Food Types Cost Quantity Total Cost
Chowmein Chinease 50 2 100
Pasta Italian 60 1 60
Dhokla Gujrati 40 1 40
Masala Dosa South Indian 100 2 200
Biriyani Hyderabadi 140 1 140
Cheese Maggi Chinease 80 4 320
Uttapam South Indian 60 3 180
Food Total Cost
Biriyani 140
Name Height Weight
Sally 6.2 185
Tom 5.9 170
Kevin 5.8 175
Amanda 5.5 145
Carl 6.1 210
Ned 6 180
Tom
Height 6.2
Item Color
T-shirt Red
T-shirt Black
T-shirt Gray
Sandals Black
Sandals Black
Hoodle Gray
Hoodle White
Hoodle Blue
Hat Black
Hat Orange
Hat White
Name Height Weight
Sally 6.2 185
Tom 5.9 170 Amanda
Kevin 5.8 175 Weight 145
Amanda 5.5 145
Carl 6.1 210
Ned 6 180
Price ID
18 1001
17.5 1002
19 1003 2001
24 2001 Price
25 2002
33 3001 24
35 3002
32 3003
28 4001
30 4002
25 4003
MARKET RESEARCH: Revenue and Profit for Popular iPhone Apps (2019)
Category App Type Revenue Profit
Game Temple Run In-App Purchases $3,543,590.00 $1,417,436.00
Game Candy Crush In-App Purchases $1,460,004.00 $584,001.60
Game Doom In-App Purchases $1,180,914.00 $472,365.60
Game Bejewelled In-App Purchases $3,315,375.00 $1,326,150.00
Productivity Office Lens Free $989,735.00 $395,894.00
Productivity Google Docs Free $3,376,162.00 $1,350,464.80
Productivity OneDrive Free $4,704,744.00 $1,881,897.60
Social Media Twitter Free $3,643,081.00 $1,457,232.40
Social Media Instagram Free $2,379,523.00 $951,809.20
Social Media Facebook Free $2,682,348.00 $1,072,939.20
Communications Messenger Free $2,218,678.00 $887,471.20
Communications WhatsApp Free $2,300,920.00 $920,368.00
Communications Slack Free $854,762.00 $341,904.80
Social Media LinkedIn Free $4,333,796.00 $1,733,518.40
Photography FaceTune In-App Purchases $4,726,854.00 $1,890,741.60
Productivity Layout In-App Purchases $2,311,869.00 $924,747.60
Photography Camera Pro In-App Purchases $1,091,925.00 $436,770.00
Photography Lightroom Subscription $2,428,841.00 $971,536.40
Productivity Google Calendar Free $3,315,820.00 $1,326,328.00
Utilities Google Maps Free $1,203,681.00 $481,472.40
Shopping Amazon Free $1,757,487.00 $702,994.80
Music Amazon Music Subscription $3,748,959.00 $1,499,583.60
Music Spotify Subscription $3,193,503.00 $1,277,401.20
Social Media YouTube Free $2,459,057.00 $983,622.80
Travel Booking Free $1,440,676.00 $576,270.40
Travel AirBnb Free $2,583,723.00 $1,033,489.20
Dating Tinder In-App Purchases $2,189,187.00 $875,674.80
Social Media Twitch Free $2,662,745.00 $1,065,098.00
Social Media TikTok Free $4,062,941.00 $1,625,176.40
Select App: WhatsApp
Category Communications
Type Free
Profit $ 920,368.00
Revenue $ 2,300,920.00
Employee ID Employee Name Salary Employee Status
53 Eileen Harmon ₹ 41,486.00 Part-Time
55 Freya Chen ₹ 52,741.00 Part-Time
57 Simran Hampton ₹ 43,077.00 Fixed-Term
58 Everly Coulson ₹ 30,475.00 Permanent
59 Isabella Glass ₹ 69,431.00 Freelancer
60 Siraj O'Brien ₹ 26,113.00 Contractor
63 Marwah Bassett ₹ 20,546.00 Contractor
64 Samuel Nava ₹ 95,766.00 Fixed-Term
65 Isla-Rae Stamp ₹ 46,771.00 Fixed-Term
66 Elouise Hart ₹ 90,418.00 Permanent
67 Bayley Leal ₹ 68,357.00 Freelancer
68 Teejay Kaye ₹ 69,066.00 Freelancer
69 Raj Bernal ₹ 24,581.00 Permanent
70 Don Bryan ₹ 21,428.00 Contractor
71 Aeryn Kaiser ₹ 48,080.00 Fixed-Term
72 Stacy Conroy ₹ 76,840.00 Part-Time
73 Demi Calderon ₹ 97,041.00 Freelancer
80 Anabel Singleton ₹ 82,259.00 Part-Time
81 Tobey Oneil ₹ 25,265.00 Fixed-Term
82 Aamina Hulme ₹ 32,421.00 Contractor
83 Cem Sykes ₹ 93,799.00 Contractor
84 Keith Conrad ₹ 24,358.00 Contractor
85 Husnain Donaldson ₹ 98,712.00 Permanent
86 Kelsey Brady ₹ 86,606.00 Contractor
87 Anna Blankenship ₹ 80,767.00 Permanent
88 Patrycja Hansen ₹ 59,537.00 Part-Time
89 Radhika Carver ₹ 37,693.00 Freelancer
94 Tammy Daniel ₹ 73,727.00 Permanent
96 Alexia Medina ₹ 74,964.00 Fixed-Term
ID 55
Employee Name Freya Chen
Salary ₹ 52,741.00
Status Part-Time
Name Rank Using Index&Match, find the ID Number of Dav
George 5 ID Number Name
Olivia 2 9584423 Yoav
Seymour 3 5034521 Bob
Julia 1 9543669 Rami
Owen 4 9995553 David
Leo 6 8595323 Lev
Sarah 7 9359305 Frank
Name: Bob
Find the Name of the person who's ranked 4th Answer: 5034521 <- Insert formula here
Rank 5
Name George
h, find the ID Number of David
<- Insert formula here
Coffee
Country Banana Bean Avocado Country
Seychelles 1987 No Data 13 Greece
Cayman Islands 217 No Data 22
Cook Islands 30 0 35
French Polynesia 188 23 119
Saint Lucia 7486 No Data 160
Guadeloupe 58146 30 210
Tunisia No Data No Data 333
Dominica 26767 226 337
Martinique 174084 26 352
Trinidad and Tobago 3085 51 644
Palestine 3118 No Data 677
Cyprus 5460 No Data 714
Reunion 10466 No Data 732
Barbados 1046 No Data 758
Puerto Rico 74845 3872 771
Eswatini 6857 No Data 954
Bosnia and Herzegovina No Data No Data 1051
Samoa 22558 13 1368
Bahamas 9760 No Data 1396
French Guiana 8000 No Data 1491
Grenada 2244 No Data 1549
Honduras 671251 481053 1618
Greece 2459 No Data 1640
Zimbabwe 106058 525 1766
Jamaica 66381 7085 2349
France No Data No Data 2518
Cuba 271925 6814 2819
Turkey 498888 No Data 3164
Argentina 174585 No Data 4154
Timor 566 8876 4831
Central African Republic 90530 9145 7511
Rwanda 1739007 21548 8238
Guyana 16802 403 8586
Panama 274898 6729 8834
Lebanon 71625 No Data 9383
Ghana 94268 735 9385
Congo 83059 3041 10031
Bolivia 305950 22121 12452
Costa Rica 2528788 85340 15000
Paraguay 75868 441 15882
Ecuador 6505635 5065 18232
El Salvador 17249 80167 18605
Philippines 6144374 60313 19443
New Zealand No Data No Data 25525
Madagascar 383522 57451 26777
Cote d'Ivoire 397305 88867 37983
Sri Lanka No Data 6445 50542
Morocco 319950 No Data 51170
Ethiopia 508013 470221 52389
Australia 373931 No Data 63486
Democratic Republic of Congo 309916 29673 65773
Cameroon 1203440 33164 75221
Spain 386226 No Data 89592
Haiti 262391 44200 90699
Malawi 441282 11082 92239
Chile No Data No Data 124506
Guatemala 4026547 245580 124931
South Africa 444879 No Data 127568
China 11577938 100332 128743
Israel 135000 No Data 131720
Venezuela 448315 50080 139685
United States 4274 2380 168528
Kenya 1414176 41375 233933
Brazil 6752171 3556638 235788
Colombia 3707152 720634 326666
Indonesia 7264383 722461 410094
Peru 134604 369622 504517
Dominican Republic 1175710 18416 644306
Mexico 2354479 158325 2184663
Algeria 319 No Data No Data
American Samoa 844 No Data No Data
Angola 3492184 16079 No Data
Antigua and Barbuda 270 No Data No Data
Bahrain 996 No Data No Data
Bangladesh 810347 No Data No Data
Belize 78692 90 No Data
Benin 22167 51 No Data
Bermuda 326 No Data No Data
Bhutan 3000 No Data No Data
British Virgin Islands 479 No Data No Data
Brunei 1822 No Data No Data
Burundi 1654955 14216 No Data
Cambodia 144403 381 No Data
Cape Verde 9509 35 No Data
Comoros 46777 137 No Data
Egypt 1388199 No Data No Data
Equatorial Guinea 31170 4251 No Data
Fiji 4888 19 No Data
Gabon 19216 88 No Data
Guam 354 No Data No Data
Guinea 237350 42900 No Data
Guinea-Bissau 9087 No Data No Data
India 30808000 326982 No Data
Iran 131170 No Data No Data
Italy 337 No Data No Data
Japan 51 No Data No Data
Jordan 42098 No Data No Data
Kiribati 8339 No Data No Data
Laos 970985 154435 No Data
Liberia 141679 648 No Data
Malaysia 376589 8743 No Data
Maldives 334 No Data No Data
Mali 187011 No Data No Data
Mauritius 7333 No Data No Data
Micronesia (country) 2035 No Data No Data
Montserrat 201 No Data No Data
Mozambique 578437 846 No Data
Myanmar No Data 8607 No Data
Nepal 254403 513 No Data
New Caledonia 1541 5 No Data
Nicaragua 108832 141931 No Data
Nigeria No Data 1849 No Data
Niue 81 No Data No Data
Oman 18265 No Data No Data
Pakistan 135056 No Data No Data
Papua New Guinea 1383174 57965 No Data
Portugal 22254 No Data No Data
Saint Vincent and the Grenadines 59464 181 No Data
Sao Tome and Principe 6293 10 No Data
Saudi Arabia No Data 0 No Data
Senegal 30541 No Data No Data
Sierra Leone No Data 28096 No Data
Solomon Islands 313 No Data No Data
Somalia 20905 No Data No Data
Sudan 951233 No Data No Data
Suriname 48835 5 No Data
Syria 154 No Data No Data
Taiwan 356238 0 No Data
Tanzania 3469091 55770 No Data
Thailand 1045352 32684 No Data
Togo 26820 21023 No Data
Tokelau 16 No Data No Data
Tonga 777 16 No Data
Tuvalu 292 No Data No Data
Uganda 532370 211200 No Data
United Arab Emirates 204 No Data No Data
Vanuatu 16787 29 No Data
Vietnam 2087275 1616307 No Data
Wallis and Futuna 6493 No Data No Data
Yemen 116322 19338 No Data
Zambia 652 7104 No Data
Coffee
Banana Bean Avocado
2459 No Data 1640
