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