Class/Subjects 8:00 AM - 8:45 AM 8:45 AM - 9:30 AM

Mathematics Mathematics (Ms. Johnson) Mathematics (Mr. Smith)

Science Science (Mr. Smith) Science (Mrs. Lee)
English English (Mrs. Lee) English (Mr. Brown)
History History (Mr. Brown) History (Ms. Davis)
Geography Geography (Ms. Davis) Geography (Mr. Wilson)
Physical Education Physical Education (Mr. Wilson) Physical Education (Ms. Taylor)
Art Art (Ms. Taylor) Art (Mr. White)
Computer Science Computer Science (Mr. White) Computer Science (Ms. Johnson)

Class/Subjects 9:30 AM - 10:15 AM

Science Science (Mr. Brown)

Row 3
Column 4
 9:30 AM - 10:15 AM 10:15 AM - 11:00 AM 11:00 AM - 11:15 AM (Break)
Mathematics (Mrs. Lee) Mathematics (Mr. Brown) Break
Science (Mr. Brown) Science (Ms. Davis) Break
English (Ms. Davis) English (Mr. Wilson) Break
History (Mr. Wilson) History (Ms. Taylor) Break
Geography (Ms. Taylor) Geography (Mr. White) Break
Physical Education (Mr. White) Physical Education (Ms. Johnson) Break
Art (Ms. Johnson) Art (Mr. Smith) Break
Computer Science (Mr. Smith) Computer Science (Mrs. Lee) Break
 11:15 AM - 12:00 PM 12:00 PM - 12:45 PM 12:45 PM - 1:30 PM
Mathematics (Mr. Wilson) Mathematics (Ms. Taylor) Mathematics (Mr. White)
Science (Ms. Taylor) Science (Mr. White) Science (Ms. Johnson)
English (Mr. White) English (Ms. Johnson) English (Mr. Smith)
History (Ms. Johnson) History (Mr. Smith) History (Mrs. Lee)
Geography (Mr. Smith) Geography (Mrs. Lee) Geography (Mr. Brown)
Physical Education (Mrs. Lee) Physical Education (Mr. Brown) Physical Education (Ms. Davis)
Art (Mr. Brown) Art (Ms. Davis) Art (Mr. Wilson)
Computer Science (Ms. Davis) Computer Science (Mr. Wilson) Computer Science (Ms. Taylor)
 1:30 PM - 2:15 PM
Mathematics (Ms. Johnson)
Science (Mr. Smith)
English (Mrs. Lee)
History (Mr. Brown)
Geography (Ms. Davis)
Physical Education (Mr. Wilson)
Art (Ms. Taylor)
Computer Science (Mr. White)
 Employee ID Name Department Salary Joining Date
EMP001 Employee_1 Finance ₹ 41,954.00 1/1/2020
EMP002 Employee_2 Operations ₹ 49,855.00 1/2/2020 Employee ID
EMP003 Employee_3 Sales ₹ 94,210.00 1/3/2020 EMP012
EMP004 Employee_4 Finance ₹ 74,689.00 1/4/2020
EMP005 Employee_5 Operations ₹ 90,652.00 1/5/2020
EMP006 Employee_3 Operations ₹ 74,820.00 1/6/2020
EMP007 Employee_7 Sales ₹ 85,206.00 1/7/2020
EMP008 Employee_8 Finance ₹ 30,924.00 1/8/2020
EMP009 Employee_9 Operations ₹ 57,737.00 1/9/2020
EMP010 Employee_10 Sales ₹ 36,000.00 1/10/2020
EMP011 Employee_11 Sales ₹ 96,371.00 1/11/2020
EMP012 Employee_12 Operations ₹ 85,028.00 1/12/2020

16
17
Name Department Salary Joining Date
 Employee ID Name Department Salary Joining Date
EMP001 Employee_1 Finance ₹ 41,954.00 1/1/2020
EMP002 Employee_2 Operations ₹ 49,855.00 1/2/2020
EMP003 Employee_3 Sales ₹ 94,210.00 1/3/2020
EMP004 Employee_4 Finance ₹ 74,689.00 1/4/2020
EMP005 Employee_5 Operations ₹ 90,652.00 1/5/2020
EMP006 Employee_3 Operations ₹ 74,820.00 1/6/2020
EMP007 Employee_7 Sales ₹ 85,206.00 1/7/2020
EMP008 Employee_8 Finance ₹ 30,924.00 1/8/2020
EMP009 Employee_9 Operations ₹ 57,737.00 1/9/2020
EMP010 Employee_10 Sales ₹ 36,000.00 1/10/2020
EMP011 Employee_11 Sales ₹ 96,371.00 1/11/2020
EMP012 Employee_12 Operations ₹ 85,028.00 1/12/2020
emp_type Greater than
Salary Emp_type
90000 Grade1
75000 Grade2
60000 Grade3
45000 Grade4
30000 Grade5
15000 Grade6
 Pen Pencil Eraser Book Scale Marker Notebook Sharpener

Price (₹) 10 5 7 50 15 25 60 8
Stock 100 200 150 75 120 90 60 130
Sold 60 80 50 40 30 20 25 60
Supplier A1 A2 A1 A3 A1 A4 A2 A2
Discount (%) 5 0 2 10 3 5 12 0
 Bag Ruler Crayons File Whiteboard
Chart Paper Stapler Glue Highlighter Compass

500 20 100 30 400 15 75 20 40 120

40 80 55 70 15 100 45 60 85 35
15 35 20 30 10 40 20 30 50 12
A5 A1 A3 A4 A5 A3 A2 A4 A2 A3
15 0 8 5 20 2 7 5 10 5
Calculator

Questions
700 1. Find the price of Notebook
20 2. Find the stock of Bag
8 3. How many Sharpener items are sold?
A5 4. Who is the supplier of Marker?
12 5. Find the discount given on Calculator
6. Find the supplier of the item priced at ₹400
7. Find the stock of Chart Paper (Supplier A5)
8. What is the price of the item whose stock is 130?
9. Find the discount on Stapler
10. How many Notebooks were sold?
11. Calculate the final price after discount for Book
12. How much revenue (Price × Sold) was generated from Bag?
13. Find which item supplied by A3 has the highest discount
14. Which item has the lowest stock among all?
15. Find the total revenue generated by items with discounts more than 10%
 EmpID Name Department Salary City
E101 Neha HR 45978 Ahmedabad
E102 Kiran Finance 42896 Jaipur
E103 Amit Sales 47892 Pune
E104 Neha IT 47573 Bangalore
E105 Ramesh IT 43209 Pune
E106 Shreya Marketing 45338 Chennai
E107 Rohit Finance 49282 Patna
E108 Sneha Sales 51297 Delhi
E109 Suresh Marketing 57972 Mumbai
E110 Ramesh Finance 43234 Patna
E111 Ajay HR 64846 Kolkata
E112 Divya Marketing 46721 Patna
E113 Kiran Sales 61424 Ahmedabad
E114 Priya Sales 67288 Jaipur
E115 Priya HR 33007 Delhi
E116 Priya Finance 61270 Chennai
E117 Kiran Finance 34278 Delhi
E118 Vikram Finance 42431 Bangalore
E119 Rohit HR 30174 Bangalore
E120 Suresh Finance 51133 Delhi
E121 Simran IT 32161 Delhi
E122 Divya Finance 67639 Bangalore
E123 Kavya HR 40380 Mumbai
E124 Amit HR 35051 Jaipur
E125 Meena Marketing 41180 Lucknow
E126 Ramesh HR 31532 Ahmedabad
E127 Amit HR 44781 Bhopal
E128 Shreya Finance 48057 Jaipur
E129 Ajay IT 47958 Mumbai
E130 Ramesh IT 55902 Kolkata
E131 Kavya Sales 58254 Ahmedabad
E132 Anjali HR 65439 Hyderabad
E133 Simran Marketing 41676 Bhopal
E134 Kavya Sales 59446 Bangalore
E135 Amit Sales 53073 Bhopal
E136 Rohit Sales 34719 Pune
E137 Nikhil HR 69332 Patna
E138 Shreya Finance 41687 Pune
E139 Rohit IT 44904 Kolkata
E140 Priya HR 38122 Pune
E141 Priya Finance 36817 Delhi
E142 Amit Finance 33089 Kolkata
E143 Pooja IT 42507 Ahmedabad
E144 Simran Sales 67063 Mumbai
E145 Divya IT 64606 Chennai
E146 Rohit Sales 66636 Jaipur
E147 Ramesh Sales 61199 Hyderabad
E148 Simran Finance 46630 Lucknow
E149 Rohit Sales 62251 Bhopal
E150 Kavya Sales 34374 Chennai
E151 Ajay Finance 31844 Lucknow
E152 Amit Marketing 55781 Kolkata
E153 Arjun Sales 31498 Chennai
E154 Suresh Sales 65767 Ahmedabad
E155 Meena Sales 37932 Kolkata
E156 Rahul IT 37653 Chennai
E157 Priya Sales 51304 Ahmedabad
E158 Vikram IT 69266 Ahmedabad
E159 Meena Sales 45123 Chennai
E160 Pooja Marketing 58081 Kolkata
E161 Sneha Finance 44836 Chennai
E162 Divya Finance 54614 Pune
E163 Suresh Marketing 48373 Bangalore
E164 Vikram Marketing 44155 Mumbai
E165 Amit IT 46834 Bhopal
E166 Sneha HR 44109 Patna
E167 Suresh IT 37440 Patna
E168 Neha HR 62974 Hyderabad
E169 Nikhil Finance 62002 Bangalore
E170 Amit Sales 43647 Bhopal
E171 Vikram Marketing 39828 Jaipur
E172 Arjun HR 50564 Bhopal
E173 Kiran Finance 62077 Ahmedabad
E174 Rahul HR 69003 Ahmedabad
E175 Arjun Finance 50852 Ahmedabad
E176 Shreya IT 69853 Hyderabad
E177 Arjun Sales 42693 Lucknow
E178 Rohit Finance 31186 Bhopal
E179 Meena Marketing 62598 Kolkata
E180 Shreya HR 45367 Pune
E181 Kiran IT 59209 Patna
E182 Priya Sales 31382 Kolkata
E183 Ajay Marketing 35525 Delhi
E184 Vikram Sales 46158 Lucknow
E185 Nikhil Sales 37922 Lucknow
E186 Meena IT 55894 Lucknow
E187 Rahul IT 59068 Bangalore
E188 Shreya Marketing 53107 Chennai
E189 Anjali HR 43902 Lucknow
E190 Kavya IT 58203 Bhopal
E191 Shreya Marketing 43450 Lucknow
E192 Ramesh HR 34884 Pune
E193 Pooja Sales 62442 Bangalore
E194 Anjali IT 31626 Lucknow
E195 Rahul IT 67926 Jaipur
E196 Neha HR 69886 Patna
E197 Ajay Sales 57230 Patna
E198 Kiran Sales 32045 Patna
E199 Kiran Marketing 38779 Jaipur
E200 Shreya Sales 35409 Mumbai
E201 Nikhil Sales 61110 Lucknow
E202 Priya IT 62637 Hyderabad
E203 Shreya Marketing 44819 Bhopal
E204 Rahul Finance 38458 Ahmedabad
E205 Neha IT 40595 Bhopal
E206 Pooja Sales 33962 Kolkata
E207 Divya Finance 54861 Hyderabad
E208 Kiran Finance 66602 Pune
E209 Arjun IT 54982 Lucknow
E210 Ramesh HR 45078 Delhi
E211 Priya Marketing 36946 Kolkata
E212 Sneha HR 49812 Delhi
E213 Rohit Finance 69247 Ahmedabad
E214 Neha IT 61894 Delhi
E215 Divya Finance 38318 Mumbai
E216 Suresh IT 50820 Bhopal
E217 Amit IT 66071 Pune
E218 Kiran IT 53779 Pune
E219 Anjali Finance 60273 Bangalore
E220 Anjali Marketing 52713 Ahmedabad
E221 Vikram Sales 53114 Chennai
E222 Suresh Sales 68716 Jaipur
E223 Priya IT 51991 Mumbai
E224 Kavya Finance 40243 Bhopal
E225 Rohit Sales 54786 Chennai
E226 Rohit Marketing 41510 Mumbai
E227 Pooja Finance 50715 Lucknow
E228 Divya IT 64927 Ahmedabad
E229 Anjali Finance 64780 Patna
E230 Rohit IT 45275 Mumbai
E231 Simran Sales 37929 Ahmedabad
E232 Shreya IT 34018 Ahmedabad
E233 Suresh Marketing 42008 Ahmedabad
E234 Ramesh Finance 49477 Bhopal
E235 Vikram IT 41653 Jaipur
E236 Ajay Marketing 65356 Bhopal
E237 Ajay HR 59300 Delhi
E238 Amit Finance 62974 Pune
E239 Anjali HR 56591 Bhopal
E240 Meena IT 66316 Patna
E241 Arjun Sales 43808 Ahmedabad
E242 Simran HR 44359 Lucknow
E243 Amit Sales 37038 Bangalore
E244 Vikram IT 67902 Jaipur
E245 Pooja Finance 57491 Pune
E246 Vikram IT 50303 Patna
E247 Meena Finance 54663 Lucknow
E248 Nikhil IT 63902 Chennai
E249 Suresh Sales 33783 Mumbai
E250 Kiran HR 40902 Lucknow
E251 Kavya Marketing 63905 Lucknow
E252 Kiran HR 62501 Ahmedabad
E253 Simran Finance 43198 Bhopal
E254 Rahul Sales 63031 Jaipur
E255 Sneha Marketing 38199 Pune
E256 Neha Sales 60905 Kolkata
E257 Arjun Sales 57310 Pune
E258 Shreya IT 58596 Mumbai
E259 Ramesh Sales 63822 Pune
E260 Vikram Sales 43945 Chennai
E261 Vikram Marketing 58759 Bangalore
E262 Shreya Finance 66348 Patna
E263 Anjali HR 48643 Ahmedabad
E264 Meena Sales 40286 Lucknow
E265 Anjali Sales 66201 Pune
E266 Shreya IT 35875 Bangalore
E267 Vikram Sales 55694 Ahmedabad
E268 Shreya HR 45135 Chennai
E269 Divya Finance 54845 Kolkata
E270 Vikram Finance 54859 Pune
E271 Vikram Sales 30368 Bhopal
E272 Ajay Finance 37206 Ahmedabad
E273 Simran Marketing 45721 Ahmedabad
E274 Anjali Sales 35864 Chennai
E275 Nikhil Marketing 50563 Pune
E276 Ajay HR 61304 Kolkata
E277 Kavya HR 46278 Kolkata
E278 Sneha Marketing 54472 Mumbai
E279 Shreya Sales 34747 Pune
E280 Ramesh IT 45164 Jaipur
E281 Simran HR 46657 Delhi
E282 Rahul Sales 54783 Bangalore
E283 Suresh Marketing 38228 Lucknow
E284 Neha Finance 39033 Jaipur
E285 Kavya IT 48883 Pune
E286 Divya Sales 33682 Ahmedabad
E287 Rahul HR 63231 Patna
E288 Amit HR 57001 Pune
E289 Ramesh IT 60808 Delhi
E290 Pooja Sales 51723 Chennai
E291 Ramesh HR 58752 Delhi
E292 Neha IT 44947 Bhopal
E293 Sneha Sales 55151 Delhi
E294 Vikram Finance 45920 Delhi
E295 Sneha Sales 53643 Kolkata
E296 Ajay HR 51278 Jaipur
E297 Neha Sales 54090 Ahmedabad
E298 Kiran IT 57796 Delhi
E299 Ajay HR 33969 Ahmedabad
E300 Rahul Finance 35064 Hyderabad
Find the Salary of employee E150.

Find the Department of employee E175.

Find the City of employee E199.

Use an input cell to enter any EmpID and return the Name of the employe