Mock Test 1
Mock Test 1
Mock Test 1
11 Average 33977.22
29
7
27
27
22
16
16
12
21
21
14
20
20
15
12
10
13
10
11
9
7
7
6
3
6
5
Invoice no.Customer name Customer Order Date Delivered to Order amount Discount Net Amount Maximum Net Amount
1001 Ekta Sharma Senior 16th Jan Mumbai 2500 0 2500 45040
1002 Esha Bhowmick Senior 17th July Delhi 4500 450 4050
1003 Gopal Bose Retail 15th Nov Kanpur 2500 0 2500
1004 Gourab Singh Retail 20th Oct Mumbai 45800 9160 36640
1005 Goutam Kumar Business 17th July Kolkata 2630 0 2630
1006 Hemant Kumar Retail 15th Nov Ranchi 5960 596 5364
1007 Saurav Sharma Retail 20th Oct Kolhapur 1520 0 1520
1008 Hritik Verma Business 10th Feb Ahmedabad 5960 596 5364
1009 MD.Husain Senior 18th May Delhi 2500 0 2500
1010 Indradip Roy Senior 15th June Ranchi 2630 0 2630
1011 Indrajit Roy Retail 6th Dec Ranchi 14520 2904 11616
1012 Indrani Sharan Retail 20th Oct Kolkata 15200 3040 12160
1013 Indranil Kar Business 17th July Mumbai 25800 5160 20640
1014 Istekhar Khan Retail 15th Nov Ranchi 26350 5270 21080
1015 Jahnabi Mukherjee Business 20th Oct Jamshedpur 2500 0 2500
1016 Jamir Khan Senior 10th Feb Raniganj 45800 9160 36640
1017 Jhilik sen Senior 18th May Kolkata 2630 0 2630
1018 Joydeep sen Retail 15th June Ranchi 25960 5192 20768
1019 Juli sinha Retail 25th Nov Kolhapur 1520 0 1520
1020 Jyoti sharma Business 28th Aug Ahmedabad 14520 2904 11616
1021 Jyoti saran Retail 16th June Delhi 2500 0 2500
1022 Karan Gupta Business 17th July Ranchi 2630 0 2630
1023 Kartick kumar Senior 18th May Ranchi 14520 2904 11616
1024 Krishna Chowdury Senior 15th June Kolkata 25630 5126 20504
1025 Kriti Nandi Retail 25th Nov Kolkata 25800 5160 20640
1026 Kuhelika Banerjee Retail 28th Aug Ranchi 56300 11260 45040
1027 Kumar Akshay Business 16th June Kolhapur 14520 2904 11616
1028 Kushal sharma Retail 17th July Ahmedabad 25630 5126 20504
Healthwise Fitness Center
Weekly plans
Total Total
Item Type Female Male Offline Online Total Cost Revenue Profit
Baby
Food 3 1 1 3 3446979 5519664 2072685
Cereal 2 0 0 2 1100483 1932963 832480.2
Office
Supplies 1 1 2 0 3591251 4454928 863676.3
Fruits 2 0 0 2 71199.88 95996.37 24796.49
Househol
d 2 1 3 0 8538657 11354576 2815918
Vegetable
s 2 0 0 2 746171.6 1264216 518044.8
Personal
Care 2 1 2 1 909043.5 1311031 401987.5
5
6
7
8
9
10
11
12
13
14
Question
On the "Orders" worksheet enter a formula in cell i2 that uses an excel function to re
"Order Amount" column
On the "Orders" worksheet enter a formula in cell g2 that will claculate the rank of o