Name Surname Contact NO. Roll no.
Test 1 Test2 Right Function
Right(text,[num_chars])
Anchal Taneja 91 7960843241 BCP3001 66 58 3001
Arjun Kapoor 91 9760843211 BCP3002 84 80 3002
Aakash Singh 91 8432112090 BCP3003 78 80 3003
Aniket Mishra 91 7538432244 BCP3004 55 62 3004
Ananya Raj 91 9785234590 BCP3005 64 64 3005
Arya Rastogi 91 7960908090 BCP3006 63 64 3006
Bhaskar Pandey 91 8907652312 BCP3007 53 49 3007
Bhumi Singh 91 8760786512 BCP3008 72 78 3008
Bhavna Chaudhary91 9760876522 BCP3009 77 75 3009
Dev Chaudhary91 9870442233 BCP3010 76 70 3010
Diksha Garg 91 9760 887640 BCP3011 80 85 3011
Disha Mittal 91 8064934500 BCP3012 56 54 3012
Daksh Jain 91 9807665721 BCP3013 58 60 3013
Dia Verma 91 9860506090 BCP3014 70 69 3014
Naman Vyas 91 7890432209 BCP3015 78 71 3015
Falak Khan 91 9870990012 BCP3016 64 65 3016
Ria Dikshit 91 9760908078 BCP3017 53 59 3017
Varsha Thapar 91 7680943444 BCP3018 57 55 3018
Priya Agarwal 91 7860999900 BCP3019 82 87 3019
Natasha Sharma 91 8934221345 BCP3020 72 77 3020
Left function Concatenation function Giving a space
Left(text,[num_chars]) Concatenate(text1,[text2],…)] Concatenate(text1," ",text2)
BCP Anchal3001 Anchal Taneja
BCP Arjun3002 Arjun Kapoor
BCP Aakash3003 Aakash Singh
BCP Aniket3004 Aniket Mishra
BCP Ananya3005 Ananya Raj
BCP Arya3006 Arya Rastogi
BCP Bhaskar3007 Bhaskar Pandey
BCP Bhumi3008 Bhumi Singh
BCP Bhavna3009 Bhavna Chaudhary
BCP Dev3010 Dev Chaudhary
BCP Diksha3011 Diksha Garg
BCP Disha3012 Disha Mittal
BCP Daksh3013 Daksh Jain
BCP Dia3014 Dia Verma
BCP Naman3015 Naman Vyas
BCP Falak3016 Falak Khan
BCP Ria3017 Ria Dikshit
BCP Varsha3018 Varsha Thapar
BCP Priya3019 Priya Agarwal
BCP Natasha3020 Natasha Sharma
Mid function
Mid(text,start_num,num_chars)
7960
9760
8432
7538
9785
7960
8907
8760
9760
9870
9760
8064
9807
9860
7890
9870
9760
7680
7860
8934
Name Surname Contact NO. Roll no. Test 1 If
Fail/pass
Anchal Taneja 91 7960843241 BCP3001 66 PASS
Arjun Kapoor 91 9760843211 BCP3002 84 PASS
Aakash Singh 91 8432112090 BCP3003 78 PASS
Aniket Mishra 91 7538432244 BCP3004 32 FAIL
Ananya Raj 91 9785234590 BCP3005 64 PASS
Arya Rastogi 91 7960908090 BCP3006 11 FAIL
Bhaskar Pandey 91 8907652312 BCP3007 53 PASS
Bhumi Singh 91 8760786512 BCP3008 72 PASS
Bhavna Chaudhary91 9760876522 BCP3009 77 PASS
Dev Chaudhary91 9870442233 BCP3010 76 PASS
Diksha Garg 91 9760 887640 BCP3011 80 PASS
Disha Mittal 91 8064934500 BCP3012 45 FAIL
Daksh Jain 91 9807665721 BCP3013 58 PASS
Dia Verma 91 9860506090 BCP3014 70 PASS
Naman Vyas 91 7890432209 BCP3015 78 PASS
Falak Khan 91 9870990012 BCP3016 43 FAIL
Ria Dikshit 91 9760908078 BCP3017 53 PASS
Varsha Thapar 91 7680943444 BCP3018 57 PASS
Priya Agarwal 91 7860999900 BCP3019 82 PASS
Natasha Sharma 91 8934221345 BCP3020 22 FAIL
Customer name Total Amount of Purchase No. Of products purchased OR FUNCTION
A 2000 2 0
B 25000 4 1
C 13000 5 0
D 23500 13 1
E 9000 8 1
OR IF FUNCTION
no discount
7500
no discount
7050
2700
