Student_details

Student_Name Marks
Aaradhya 20
Adah 72
Adhira 29
Alisha 67
Amoli 61
Anaisha 10
Ananya 72
Anika 77
Anushka 57
Asmee 35
Avni 51
Carina 92
Drishti 89
Hiya 46
Ira 10
Ishana 33
Ishita 30
Kaia 41
Kashvi 20
Keya 100
Kimaya 35
Krisha 3
Larisa 46
Mahika 53
Mayra 61
Mehar 56
Mirai 11
Mishka 5
Naitee 18
Navya 83
Nehrika 57
Neysa 29
Pavati 84
Prisha 67
Ryka 67
Rebecca 61
Saanvi 81
Sahana 60
Sai 34
Saisha 52
Saloni 30
Shanaya 5
Shrishti 67
 Sneha 98
Taahira 8
Taara 70
Tanvi 2
Viti 28
Zara 31
Student_details
Grade
F A
C Grade Table
F Marks
D 0
D 60
F 70
C 80
C 90
F
F
F
A
B
F
F App
F
F
F
F
A
F
F
F
F
D
F
F
F
F
B
F
F
B
D
D
D
B
D
F
F
F
F
D
A
F
C
F
F
F
 F
Grade Table C
Grade F
F D
D D
C F
B C
A C
F
F
F
A
B
F
Apply logical function F
F
F
F
F
A
F
F
F
F
D
F
F
F
F
B
F
F
B
D
D
D
B
D
F
F
F
F
D
A
F
C
F
F
F
F
F
 Products Cost of admission to Shelf life Cost after revaluation Cost after revaluation
warehouse (in months) Q.1. Q.2.
prod 1 200 6 =IF(C2>8,B2/2,B2) =IF(C2>=8,B2/2,IF(C2>=5,B2/1.5,B2))
prod 2 500 12 250 250
prod 3 700 5 700 466.66666666667
prod 4 400 7 400 266.66666666667
prod 5 600 10 300 300

Q.1. If the product is kept in stock for more than 8 months we should reduce its price 2 times (Half price).

Q.2. If the product is stored for 8 or more than 8 months, the price is reduced 2 times (Half price). If it’s 5 or more than
5 months, but less than 8, it’s 1.5 times (price/1.5).
Emp_id Emp_nameGender city country salary
1 Micah Male Langford France ₹ 140,402.00
2 Byron Female Woodstock Mongolia ₹ 103,819.00
3 Nero Female Sint-Gillis-bij-Dendermonde Bahrain ₹ 81,616.00
4 Armand Male Daly Sri Lanka ₹ 128,233.00
5 Kirk Female Bourges Martinique ₹ 19,431.00
6 Alden Female Dhule Jordan ₹ 187,336.00
7 Burke Male Fermont Laos ₹ 171,896.00
8 Chester Female Carunchio Zambia ₹ 74,126.00

9 Travis Male Zelem Ireland ₹ 190,679.00

10 Amery Male Alingsås Niue ₹ 128,758.00

11 Luke Female Rae Lakes Samoa ₹ 82,445.00
12 Dominic Female Anglet Morocco ₹ 76,979.00
13 Marsden Female Orsara di Puglia Morocco ₹ 45,085.00
14 Thaddeus Female Township of Minden Hills Seychelles ₹ 79,119.00
15 Hector Female Watson Lake Dominican Republic ₹ 196,611.00
16 Ryan Male Pali Lesotho ₹ 16,716.00
17 Colby Male Nadrin Nepal ₹ 154,654.00
18 Cedric Male Lebu Ecuador ₹ 73,680.00
19 Barry Male Aisemont Kazakhstan ₹ 36,046.00
20 Josiah Female Chicago Italy ₹ 71,192.00
21 Hector Male Baie-Saint-Paul Morocco ₹ 77,594.00
22 Keane Male Anglet Morocco ₹ 65,070.00
23 Odysseus Male Nieuwmunster Nauru ₹ 121,916.00
24 Lee Female Bossuit Congo (Brazzaville) ₹ 87,861.00
25 Yardley Female Calvello Mauritania ₹ 37,179.00
26 Gary Female Rostock Anguilla ₹ 15,703.00
27 Ferris Male Berhampore Djibouti ₹ 69,624.00
28 Harrison Male Coreglia Antelminelli Mauritius ₹ 142,939.00
29 Harding Female Beigem Tunisia ₹ 20,206.00
30 Armand Male Biloxi Myanmar ₹ 80,543.00
31 Lewis Female Boulogne-sur-Mer Montenegro ₹ 110,683.00
32 Jelani Female Argenteuil Tuvalu ₹ 184,523.00
33 Adrian Female Barnstaple Papua New Guinea ₹ 155,297.00
34 Uriah Female Anglet Morocco ₹ 65,845.00
35 Austin Male Montbéliard Kiribati ₹ 189,293.00
36 Driscoll Female Galmaarden San Marino ₹ 153,188.00
37 Stephen Female Alessandria Canada ₹ 132,231.00
38 Ferdinand Female Antártica Turkmenistan ₹ 193,343.00
39 Talon Male Wolfville Mongolia ₹ 194,365.00
40 Fitzgerald Female Koszalin Armenia ₹ 165,495.00
41 Hiram Female Hachy Niue ₹ 65,590.00
42 Daniel Male Bazzano Åland Islands ₹ 67,380.00
43 Zachary Male Calera de Tango Norfolk Island ₹ 97,042.00
44 Timon Male Curridabat Chad ₹ 28,889.00
45 Xanthus Male Milnathort Lebanon ₹ 58,157.00
46 Jonah Female Kessel Martinique ₹ 95,900.00
47 Shad Male Whitby Ecuador ₹ 132,406.00
48 Jerome Male Salice Salentino Cape Verde ₹ 186,140.00
49 Erasmus Male Rishra Mali ₹ 140,191.00
50 Orlando Male Lanaken Italy ₹ 38,633.00
51 Wing Female East Gwillimbury Sweden ₹ 72,386.00
52 Deacon Female Holman Reunion ₹ 58,637.00
53 Asher Male Piancastagnaio Malta ₹ 103,458.00
54 Reece Female Los Lagos Jordan ₹ 184,450.00
55 Armand Male Brussel El Salvador ₹ 97,581.00
56 ChancellorFemale Anglet Morocco ₹ 38,110.00
57 Cullen Male Hohenems Paraguay ₹ 192,356.00
58 Vladimir Female Huntsville Portugal ₹ 153,137.00
59 Eric Male Anglet Morocco ₹ 172,396.00
60 Tanek Male Erlangen Guam ₹ 54,084.00
61 Walker Male Racine Bhutan ₹ 180,199.00
62 Chaim Female Bon Accord Malta ₹ 143,055.00
63 Ali Female Annapolis Royal El Salvador ₹ 56,302.00
64 Chandler Male Shawville Albania ₹ 16,285.00
65 Plato Male Caledon Samoa ₹ 21,068.00
66 Beck Female Uttarpara-Kotrung Chad ₹ 100,915.00
67 Dolan Female Tuktoyaktuk Togo ₹ 52,307.00
68 Cruz Female Foz do Iguaçu Åland Islands ₹ 163,072.00
69 Martin Female Virginal-Samme Costa Rica ₹ 174,918.00
70 Phelan Female Gold Coast Paraguay ₹ 52,608.00
71 Simon Male Helkijn Bangladesh ₹ 143,703.00
72 Acton Female Cirencester Cocos (Keeling) Islands ₹ 155,212.00
73 Brenden Female Livo Spain ₹ 135,050.00
74 Carl Male Sint-Jans-Molenbeek Gambia ₹ 137,540.00
75 Marsden Female Chatillon New Caledonia ₹ 95,561.00
76 Guy Female Lebu Romania ₹ 169,161.00
77 Donovan Female Anglet Morocco ₹ 156,642.00
78 Caesar Male Leuze Bermuda ₹ 180,841.00
79 Benedict Female Chambord Venezuela ₹ 33,381.00
80 Nigel Male Höchst India ₹ 115,439.00
81 Dominic Female Ambleside Senegal ₹ 134,090.00
82 Lars Male Albagiara Cape Verde ₹ 137,959.00
83 Benjamin Male Muiden Brunei ₹ 123,246.00
84 Shad Male Grand-Reng Israel ₹ 195,883.00
85 Calvin Male Martelange Myanmar ₹ 51,328.00
86 Tucker Female Isnes Curaçao ₹ 73,526.00
87 Dylan Male Salice Salentino Christmas Island ₹ 122,375.00
88 Garrett Male Denderwindeke Saint Lucia ₹ 93,071.00
89 David Male Anglet Morocco ₹ 100,455.00
90 Cooper Male San Pietro al Tanagro Brazil ₹ 25,150.00
91 Boris Female Vinci Sierra Leone ₹ 63,279.00
92 Joseph Male Glovertown Cambodia ₹ 37,545.00
 93 Porter Male Moignelee Syria ₹ 193,298.00
94 Maxwell Female Rugby Yemen ₹ 11,000.00
95 Adrian Male Schaarbeek Somalia ₹ 69,731.00
96 Abel Male Inverness Syria ₹ 39,106.00
97 Clark Male Anglet Morocco ₹ 72,024.00
98 Jonah Female Umbertide Guatemala ₹ 115,453.00
99 Lester Male Gaziantep Georgia ₹ 65,050.00
100 Joel Male Heist-aan-Zee Albania ₹ 163,926.00
commission_rate commission (sal * total_salary
9% ₹ 11,934.17 ₹ 176,204.51 salary + commission
7% ₹ 6,748.24 ₹ 117,315.47
6% ₹ 4,488.88 ₹ 86,104.88
8% ₹ 9,617.48 ₹ 157,085.43
2% ₹ 388.62 ₹ 19,431.00
11% ₹ 19,670.28 ₹ 246,346.84
10% ₹ 17,189.60 ₹ 223,464.80
5% ₹ 3,706.30 ₹ 77,832.30

11% ₹ 20,974.69 ₹ 253,603.07

8% ₹ 9,656.85 ₹ 157,728.55
6% ₹ 4,534.48 ₹ 86,979.48
5% ₹ 3,848.95 ₹ 80,827.95
4% ₹ 1,577.98 ₹ 45,085.00
5% ₹ 3,955.95 ₹ 83,074.95
11% ₹ 21,627.21 ₹ 261,492.63
2% ₹ 334.32 ₹ 16,716.00
9% ₹ 13,918.86 ₹ 196,410.58
5% ₹ 3,684.00 ₹ 77,364.00
3% ₹ 1,081.38 ₹ 36,046.00
5% ₹ 3,559.60 ₹ 74,751.60
5% ₹ 3,879.70 ₹ 81,473.70
5% ₹ 2,928.15 ₹ 67,998.15
8% ₹ 9,143.70 ₹ 149,347.10
6% ₹ 4,832.36 ₹ 92,693.36
3% ₹ 1,115.37 ₹ 37,179.00
2% ₹ 314.06 ₹ 15,703.00
5% ₹ 3,133.08 ₹ 72,757.08
9% ₹ 12,149.82 ₹ 179,388.45
3% ₹ 505.15 ₹ 20,206.00
6% ₹ 4,429.87 ₹ 84,972.87
7% ₹ 7,747.81 ₹ 133,926.43
11% ₹ 19,374.92 ₹ 242,647.75
9% ₹ 13,976.73 ₹ 197,227.19
5% ₹ 2,963.03 ₹ 68,808.03
11% ₹ 19,875.77 ₹ 248,920.29
9% ₹ 13,786.92 ₹ 194,548.76
8% ₹ 10,578.48 ₹ 163,966.44
11% ₹ 21,267.73 ₹ 257,146.19
11% ₹ 21,380.15 ₹ 258,505.45
10% ₹ 15,722.03 ₹ 212,661.08
5% ₹ 2,951.55 ₹ 68,541.55
5% ₹ 3,032.10 ₹ 70,412.10
6% ₹ 5,822.52 ₹ 108,687.04
3% ₹ 722.23 ₹ 28,889.00
 4% ₹ 2,326.28 ₹ 60,483.28
6% ₹ 5,754.00 ₹ 107,408.00
8% ₹ 10,592.48 ₹ 164,183.44
11% ₹ 19,544.70 ₹ 244,774.10
9% ₹ 11,916.24 ₹ 175,939.71
3% ₹ 1,158.99 ₹ 38,633.00
5% ₹ 3,619.30 ₹ 76,005.30
4% ₹ 2,345.48 ₹ 60,982.48
7% ₹ 6,724.77 ₹ 116,907.54
11% ₹ 19,367.25 ₹ 242,551.75
6% ₹ 5,854.86 ₹ 109,290.72
3% ₹ 1,143.30 ₹ 38,110.00
11% ₹ 21,159.16 ₹ 255,833.48
9% ₹ 13,782.33 ₹ 194,483.99
10% ₹ 17,239.60 ₹ 224,114.80
4% ₹ 2,163.36 ₹ 56,247.36
11% ₹ 18,920.90 ₹ 236,961.69
9% ₹ 12,159.68 ₹ 179,534.03
4% ₹ 2,252.08 ₹ 58,554.08
2% ₹ 325.70 ₹ 16,285.00
3% ₹ 526.70 ₹ 21,068.00
7% ₹ 6,559.48 ₹ 114,033.95
4% ₹ 2,092.28 ₹ 54,399.28
10% ₹ 15,491.84 ₹ 209,547.52
10% ₹ 17,491.80 ₹ 227,393.40
4% ₹ 2,104.32 ₹ 54,712.32
9% ₹ 12,214.76 ₹ 180,347.27
9% ₹ 13,969.08 ₹ 197,119.24
8% ₹ 10,804.00 ₹ 167,462.00
8% ₹ 11,003.20 ₹ 170,549.60
6% ₹ 5,733.66 ₹ 107,028.32
10% ₹ 16,070.30 ₹ 217,371.89
9% ₹ 14,097.78 ₹ 198,935.34
11% ₹ 18,988.31 ₹ 237,805.92
3% ₹ 1,001.43 ₹ 33,381.00
7% ₹ 8,080.73 ₹ 139,681.19
8% ₹ 10,727.20 ₹ 166,271.60
8% ₹ 11,036.72 ₹ 171,069.16
8% ₹ 9,243.45 ₹ 150,976.35
11% ₹ 21,547.13 ₹ 260,524.39
4% ₹ 2,053.12 ₹ 53,381.12
5% ₹ 3,676.30 ₹ 77,202.30
8% ₹ 9,178.13 ₹ 149,909.38
6% ₹ 5,584.26 ₹ 104,239.52
7% ₹ 6,529.58 ₹ 113,514.15
3% ₹ 628.75 ₹ 25,150.00
5% ₹ 2,847.56 ₹ 66,126.56
3% ₹ 1,126.35 ₹ 37,545.00
11% ₹ 21,262.78 ₹ 257,086.34
2% ₹ 220.00 ₹ 11,000.00
5% ₹ 3,137.90 ₹ 72,868.90
3% ₹ 1,173.18 ₹ 39,106.00
5% ₹ 3,601.20 ₹ 75,625.20
7% ₹ 8,081.71 ₹ 139,698.13
5% ₹ 2,927.25 ₹ 67,977.25
10% ₹ 15,572.97 ₹ 210,644.91
 Using logical function find out total salary of an employee

commission less than equal to 2000

commission more than 2000 and
less than equal to 5000
commission more than 5000 and
less than equal to 7000
above 7000

Find out the sum of total salary of male employees

Find out the total count of employees having commision rate above 7%
ut total salary of an employee

salary

salary + commission

salary + commission (twice)

salary + commission (thrice)

=SUMIF(C:C,C2,I:I)
=COUNTIF(G:G,">7%")