Creative Co.
Sales Bills & Commission
Cust_ID Cust_Name Bill_Date Sales_Bill
414 Anindita Stores 7/22/2017 525000
Ganesh Bhandar 8/8/2017 430000
216
Priyo Brothers 8/27/2017 780000
270
378 Dhillon co. 9/10/2017 610000
648 Fantasy Creation 9/25/2017 485000
180 Michael Corner 10/5/2017 756000
Sunanda Enterprise 10/15/2017 290000
129
Sinha Brothers 11/1/2017 628000
324
810 Gagan Traders 11/11/2017 318000
Sultan co. 11/21/2017 460000
702
558 Suraj Prasad Rajbhar 7/22/2017 525000
198 Pausali Das 8/8/2017 430000
360 Reshmi Dutta 8/27/2017 780000
445 Antara Saha 9/10/2017 610000
15 Rohit Ranjan 9/25/2017 485000
234 Akash Lal Maity 10/5/2017 756000
129 Somnath Goswami 10/15/2017 290000
675 Gaurav Kumar 11/1/2017 628000
201 Sarita Kumari 11/11/2017 318000
143 Priyottam Roy 11/21/2017 460000
453 Ranajit Ghosh 7/22/2017 525000
906 Rakesh Nair 8/8/2017 430000
654 Gitin Varghese 8/27/2017 780000
340 Neeraj Sharma 9/10/2017 610000
780 Akash Gupta 9/25/2017 485000
123 Srishti Bansal 10/5/2017 756000
276 Shailja Agarwal 10/15/2017 290000
34 Manidipa Chatterjee 11/1/2017 628000
29 Rinku Gorai 11/11/2017 318000
201 Sk Raquib 11/21/2017 460000
200 Nisha Singh 7/22/2017 525000
32 Shaily 8/8/2017 430000
351 Komal Dobhal 8/27/2017 780000
288 Km Anita Bisht 9/10/2017 610000
354 Vinod Singh 9/25/2017 485000
230 Neha Negi 10/5/2017 756000
540 Veeshant Arora 10/15/2017 290000
679 Abhishek 11/1/2017 628000
109 Rajinder Kaur 11/11/2017 318000
102 Parminder Singh 11/21/2017 460000
41 Sandeep 7/22/2017 525000
45 Sagar Adhikari 8/8/2017 430000
49 Shubham Mahajan 8/27/2017 780000
53 Biswadip Sarkar 9/10/2017 610000
57 Shelly Bajoria 9/25/2017 485000
61 Tanzila Jawaid 10/5/2017 756000
65 Deep Saha 10/15/2017 290000
sion
Credit_Days Due_Dates
15 8/6/2017 Questions
30 9/7/2017 1. Set the Cust_ID column in such a way that it sho
more than 3 digits
2. Validate Cust_Name column that it should accep
7 9/3/2017 characters but less than 20
7 9/17/2017 3. Bill Date column should not accept date above 2
15 10/10/2017 4. Make drop-down list of Weekdays on cell R1
30 11/4/2017 5. Make drop down list Cust_Name on cell S1
6. Insert Input message For Cust_ID as follows
5 10/20/2017 "This will accept an ID of 3 digits"
7. Credit days should not accept negative numbers
15 11/16/2017 message
30 12/11/2017 8. Cust_ID column should accept unique numbers o
9. Insert Column after Cust_Name for Mobile numb
should not accept any data other numbers and it's
30 12/21/2017 digits only
15 8/6/2017 10. Bill date should accept only the dates of weekd
30 9/7/2017
7 9/3/2017
7 9/17/2017
15 10/10/2017
30 11/4/2017
15 10/30/2017
15 11/16/2017
30 12/11/2017
30 12/21/2017
15 8/6/2017
30 9/7/2017
7 9/3/2017
7 9/17/2017
15 10/10/2017
30 11/4/2017
15 10/30/2017
15 11/16/2017
30 12/11/2017
30 12/21/2017
15 8/6/2017
30 9/7/2017
7 9/3/2017
7 9/17/2017
15 10/10/2017
30 11/4/2017
15 10/30/2017
15 11/16/2017
30 12/11/2017
30 12/21/2017
15 8/6/2017
30 9/7/2017
7 9/3/2017
7 9/17/2017
15 10/10/2017
30 11/4/2017
15 10/30/2017
column in such a way that it should not accept not
ame column that it should accept text more than 2
s than 20
n should not accept date above 2017
n list of Weekdays on cell R1
n list Cust_Name on cell S1
ssage For Cust_ID as follows
n ID of 3 digits"
uld not accept negative numbers also create error
should accept unique numbers only
fter Cust_Name for Mobile number. Now this column
any data other numbers and it's length should be 10
d accept only the dates of weekdays.
f
Istext
Isnumber
Len
Left
Right
Mid
Countif
Today
Now
Weekday 3 12/4/2024
Weeknum
Datedif
Eomonth
