EVEN FACT ODD POWER
Number Result Number Result Number Result Number
7 7 7 5
6 6 6 4
109 5 109 3
9 9 9 6
10 3 10
15 15
14 14
3 3
SUMIF SUMIFS SUMPRODUCT
Course Fee's
DICPA 3000 RESULT
O-LEVEL 4500 Course Total
ADCA 2000 adca
DICPA 1500
O-LEVEL 2500
ADCA 1000
DICPA 1500
O-LEVEL 2000
ADCA 2500
POWER ROMAN SQRT SUM
Power Result Number Result Number Result Number
3 1 64 54
2 5 63
6 69 52
4 8 92
40 52
INT MOD ROUND
Number Result Number Divisor Result Number
54.8 45 2 54.8
60.32 63 6 60.32
50.64 56 3 50.64
80.6 95 5 80.6
12 4
SUM
Result
ROUND
Result
TODAY NOW DATE
15/Apr/25 4/15/2025 3:50
day month year
15 2 2023 15-Feb-23
16 3 2024 16-Mar-24
13 5 2025 13-May-25
TIME HOUR MINUTE
5:45 AM
6:36 AM
7:25 AM
8:24 AM
4:15 AM
DAY MONTH YEAR
15-Feb-16
16-Mar-17
13-May-18
SECOND
LOWER PROPER UPPER
Rahul
arvind raj
ramakant
SUDHEER KUMAR
Mohan mishra
SHYAM
ravi verma
LEN CONCATENATE EXACT
Rahul rahul kumar
arvind raj sudheer verma
ramakant rahul mishra
SUDHEER KUMAR arvind raj
Mohan mishra rahul kumar
SHYAM suneel raj
ravi verma
UPPER LEFT RIGHT
EXACT TRIM
Rahul Kumar
Sudheer Verma
Rahul Mishra
Arvind Raj
Rahul Kumar
Suneel Raj
MID
RAHUL
ARVIND RAJ
RAMAKANT
SUDHEER KUMAR
MOHAN MISHRA
SHYAM
RAVI VERMA
Average AverageA
9000 25
30
12000 20
15000 19909 N
18000 22
16000 219000 N
NA 11 AverageIF
35000 25
28000 19909.0909091 AverageIFS
29000
32000
25000
Max Min
25
30
20 20
250
22 250
N
25
Count Countblank CountA
25 25 25
30 30 upciss
20 252
N 5 3 upciss 7
22 22 22
N N upciss
25 25 25
Mode
25
30
20
30
22 25
25
22
25
30
Countif
25
upciss
252
upciss
22
upciss
25
Stu.ID Name Course Age BT Name Sale Jan. Sale Feb.
S1 Arvind O level 25 8 To 10 Arvind 2509 2575
S2 Rahul ADCA 20 10 To 11 Rahul 2554 2796
S3 Suresh DCA 23 10 To 11 Suresh 2840 2582
S4 Ramesh O level 24 8 To 10 Ramesh 2554 2733
S5 Harsh CCC 19 2 To 4 Harsh 2558 2557
Stu.ID Name Course Age BT Harsh
s3 Suresh DCA 23 10 To 11 lookup Sale Feb. 2557
Stu.ID Name Course Age BT
s4 Ramesh O level 24 8 To 10 vlookup Stu.ID Name
s4 Ramesh
Sale Mar. LOOKUP
2552 VLOOKUP
2975 HLOOKUP
2904
2993 INDEX
2584 MATCH
IFERRORR
DGET
BT
8 To 10
AND / OR NOT
Name Cibil Score Salary Loan Amount
Mohan 660 18593
Kishor 651 18432
Lalit 656 24200
Anoop 688 25221
Rahul 723 17890
Ram 684 34681
Ajmer 737 18541
Harsh 654 30425
IF
Name Courae Marks Grade
Mohan ADCA 80
Kishor DICPA 85
Lalit CCC 40
Anoop DICPA 70
Rahul ADCA 60
Ram DICPA 55
Ajmer CCC 89
Harsh DICPA 45
NOT = Equal to
> Greater than
< Less than
>= Greater than or Equal to
<= Less than or Equal to
<> Not Equal to
Financial FV
FV Future Value
PMT Annuity Payment (Installment) Premium 600
IPMT Interest value of annuity payment Month 60
PPMT Principal value of annuity payment Rate of Int 9%
RATE Interest FV
NPER Number of periods
PV Present value
RATE NPER
Pv 150000 Pv 150000
Pmt -6784.09 Pmt -6784.09
Nper 24 Rate 8%
RATE NPER
PMT / IPMT / PPMT
Loan 150000
Period in Months 24
Rate of int 8%
PMT
IPMT
PPMT
PV
Pmt -6784.09
Nper 24
Rate 8%
PV
SN Rool_No Name Father Gender
1 18001 JAY PRAKASH SHASHIKANT DIXIT Male
2 18002 ANOOP KUMAR SHRIPAL Male
3 18003 LAREB KHAN NASHIM ALI Male
4 18004 PAVAN PRATAP SINGH TRIBHUVAN LAL Male
5 18005 SAHIL KHAN GOKUL PRASAD Male
6 18006 SHIVAM DEVENDAR SINGH Female
7 18007 BABLU KUMAR BAGISH KUMAR MISHRA Male
8 18008 JAKEEL KHAN RAM LAKHAN Female
9 18009 PRACHI SINGH BRAJNATH KASHYAP Male
10 18010 SANDEEP KUMAR RAM KHELAWAN Female
11 18011 ABHISHEK SINGH VINOD KUMAR Male
12 18012 PANKAJ KUMAR SHAUKAT ALI Male
13 18013 ARJUN KUMAR RAJ SHAMSHUL HAQ Female
14 18014 MO. KAUSEN RAZA SANTOSH GAUTAM Female
15 18015 NAND LAL HETRAM Male
16 18016 ASHOK KUMAR CHANDRA BHAL Female
17 18017 GAYATRI DEVI TAHZEEB KHAN Female
18 18018 JANARDAN PAL RADHEY SHYAM MAURYA Female
19 18019 APOORVA VERMA ANIL KUMAR MAURYA Male
20 18020 SANJAY KUMAR JAGDISH PRASAD MAURYA Male
21 18021 SUNEEL KUMAR RAM MURTI Male
22 18022 AJAY KUMAR SANTOSH NISHAD Male
23 18023 DEEPAK KUMAR AVDHESH KUMAR MISHRA Male
24 18024 VINEET KUMAR TEJKARAN Female
25 18025 KAMLESH PRADEEP KUMAR AWASHTI Female
26 18026 SURAJ KUMAR TIWARI JAY PRAKASH CHAURASIYA Female
27 18027 UMESH KUMAR RAVENDRA KUMAR Male
28 18028 PALLAVI DEVI RAKESH GUPTA Male
29 18029 VIKRAM MOH ARIF Female
30 18030 AMAN JAISWAL AZAMUDDEEN Male
31 18031 JAKEEL KHAN MADHAV RAM Male
32 18032 JAMEER AHMAD SHAMSUDDIN Male
33 18033 LAREB KHAN JUGUL KISHOR Female
34 18034 SAHIL KHAN MOH ARIF Male
35 18035 SHIVANI PAL GUR DAYAL SINGH Male
36 18036 RAVIN NIGAM HARIOM MISHRA Female
37 18037 NAVNEET RAM NARESH Female
38 18038 SHADAB ANSARI RAM KISHORE KASHYAP Female
39 18039 MANISH KUMAR CHHOTE LAL Male
40 18040 MOHAMMAD ALMAS PRAHLAD SINGH Male
41 18041 ROSHNI DEVI RAJESH KUMAR Male
42 18042 AKASH DEEP SINGH CHANDRIKA PRASAD Male
43 18043 SURAJ KUMAR RAM GOPAL SONY Male
44 18044 IRFAN ASHRAF ALI Male
45 18045 ABHISHEK VEERENDRA KUMAR Female
46 18046 DEEPAK KUMAR DINESH KUMAR Male
47 18047 JANARDAN PAL RAM ASARE Male
48 18048 SURAJ KUMAR TIWARI PRAHLAD SINGH Female
49 18049 KAMLESH BALVEER SINGH Male
50 18050 AJAY KUMAR SARVESH KUMAR Female
51 18051 PALLAVI DEVI ARVESH KUMAR Male
52 18052 UMESH KUMAR RAMESH KUMAR Male
53 18053 SANJAY KUMAR JAGTAR SINGH Female
54 18054 ABHISHEK RAM CHANDRA Male
55 18055 GAYATRI DEVI UTTAM PRAKASH PANDEY Male
56 18056 SUNEEL KUMAR SUJATA SHENDAGE Male
57 18057 VINEET KUMAR MO. SHAREEF Female
58 18058 APOORVA VERMA RAMENDRA KUMAR Male
59 18059 ASHOK KUMAR BIRENDRA KUMAR PANDEY Female
60 18060 IRFAN JAI PRAKASH Female
61 18061 TANMAY RAY RAM GOPAL Female
62 18062 RUKHMA DEVI RADHESHYAM Female
63 18063 MANOJ KUMAR SAIDUL HASAN Male
64 18064 RIYA SHRIVASTAVA RAM NIWAS Male
65 18065 SATYAM TIWARI VIKRAMA RAJBHAR Female
66 18066 RANJEET KUMAR RAJ BACHAN LAL Male
67 18067 VIPIN MISHRA BHAIRAV SINGH Male
68 18068 KULDEEP KUMAR AJAY BARANWAL Female
69 18069 JYOTI YADAV MOHAMMAD IRFAN Male
70 18070 PRANSHU MISHRA AMBIKA SHUKLA Male
71 18071 VISHNU MAHFOOZ KHAN Male
72 18072 MOHIT NAG KAMLESH KUMAR Male
73 18073 RAGHVENDRA SHUKLA RAMAKANT Female
74 18074 VAIBHAV AWASTHI NAUSAD ALI Male
75 18075 AKEEL KHAN DEVRAJ Female
76 18076 AYUSH MISHRA SHIVCHARAN Female
77 18077 NAJIS BANO WAHID ALI Male
78 18078 FIRDAUSH BARI KAMLESH KUMAR Male
79 18079 HIMANSHU YADAV RAM SHANKAR Male
80 18080 SHAHNUMA BANO YOGENDRA PRASAD YADAV Male
81 18081 ASHWANI KUMAR VERMA RAJESH KUMAR VISHWAKARMA Male
82 18082 SHUBHAM KUMAR JAMUNA PRASAD Male
83 18083 AVIRAL SHUKLA KRISHAN KUMAR Male
84 18084 PRINCE CHAURASIYA SHRAVAN KUMAR Female
85 18085 SHIVAM VERMA RAMA SHANKAR Male
86 18086 PALAK DEVI RAKESH MISHRA Male
87 18087 SAUMYA VERMA NAZIR AHMAD Female
88 18088 VAIBHAV GUPTA GENDAN LAL Female
89 18089 RAM LAKHAN RAJESH GUTPA Male
90 18090 SHIVAM RAJ BAHADUR Male
91 18091 ANSHUMAN MUBARAK ALI Female
92 18092 ARPIT SHUKLA BRAJESH KUMAR Male
93 18093 MAYANK GUPTA RAM MURTI Male
Course Admission date Total Fee Deposit Fee State
ADASM-06 MONTHS 1/1/2024 4400 3800 Madhya Pradesh
ADASM-06 MONTHS 1/2/2024 4400 1800 Rajasthan
ADASM-06 MONTHS 1/2/2024 4400 4400 Chandigarh
ADASM-06 MONTHS 1/2/2024 4400 4400 Bihar
ADASM-06 MONTHS 1/2/2024 4400 500 Uttar Pradesh
ADASM-06 MONTHS 1/2/2024 4400 3800 Goa
ADASM-06 MONTHS 1/3/2024 4400 4400 Gujarat
ADASM-06 MONTHS 1/3/2024 4400 4400 Haryana
ADASM-06 MONTHS 1/3/2024 4400 4400 Himachal Pradesh
ADASM-06 MONTHS 1/3/2024 4400 3800 Jharkhand
ADASM-06 MONTHS 1/4/2024 4400 4000 Chhattisgarh
ADASM-06 MONTHS 1/4/2024 4400 1200 Goa
ADASM-06 MONTHS 1/5/2024 4400 3800 Madhya Pradesh
ADASM-06 MONTHS 1/5/2024 4400 4400 Maharashtra
ADASM-06 MONTHS 1/5/2024 4400 3800 Punjab
ADCA-12 MONTHS 1/18/2024 5500 5500 Odisha
ADCA-12 MONTHS 1/18/2024 5500 5500 Punjab
ADCA-12 MONTHS 1/18/2024 5500 4900 Odisha
ADCA-12 MONTHS 1/19/2024 5500 4900 Odisha
ADCA-12 MONTHS 1/19/2024 5500 5500 Punjab
ADCA-12 MONTHS 1/19/2024 5500 5500 Rajasthan
ADCA-12 MONTHS 1/20/2024 5500 5100 Chandigarh
ADCA-12 MONTHS 1/20/2024 5500 5500 Chhattisgarh
ADCA-12 MONTHS 1/20/2024 5500 5100 Goa
ADCA-12 MONTHS 1/22/2024 5500 4900 Goa
ADCA-12 MONTHS 1/22/2024 5500 4900 Uttar Pradesh
ADCA-12 MONTHS 1/22/2024 5500 1300 Uttarakhand
ADCA-12 MONTHS 1/23/2024 5500 5500 West Bengal
DCA-12 MONTHS 2/12/2024 3200 3200 Chandigarh
DCA-12 MONTHS 2/13/2024 3200 3200 Chandigarh
DCA-12 MONTHS 2/13/2024 3200 2600 Haryana
DCA-12 MONTHS 2/13/2024 3200 2800 Haryana
DCA-12 MONTHS 2/13/2024 3200 3200 Delhi
DCA-12 MONTHS 2/13/2024 3200 2600 Bihar
DCA-12 MONTHS 2/13/2024 3200 2800 Maharashtra
DCA-12 MONTHS 2/14/2024 3200 1000 Uttar Pradesh
DCA-12 MONTHS 2/15/2024 3200 3200 Delhi
DCA-12 MONTHS 2/15/2024 3200 2600 Gujarat
DCA-12 MONTHS 2/16/2024 3200 3200 Madhya Pradesh
DCA-12 MONTHS 2/16/2024 3200 3200 Rajasthan
DCA-12 MONTHS 2/16/2024 3200 2600 Jharkhand
DCA-12 MONTHS 2/17/2024 3200 3200 Uttarakhand
DCA-12 MONTHS 2/17/2024 3200 2800 West Bengal
ADCA-12 MONTHS 9/9/2024 5500 5500 Bihar
ADCA-12 MONTHS 9/10/2024 5500 5500 Maharashtra
ADASM-06 MONTHS 9/18/2024 4400 4400 Uttar Pradesh
ADASM-06 MONTHS 9/18/2024 4400 4400 Delhi
ADASM-06 MONTHS 9/21/2024 4400 3800 Gujarat
ADASM-06 MONTHS 9/24/2024 4400 4000 Madhya Pradesh
ADASM-06 MONTHS 9/25/2024 4400 4400 Rajasthan
ADASM-06 MONTHS 9/26/2024 4400 3800 Jharkhand
ADASM-06 MONTHS 9/26/2024 4400 3800 Uttarakhand
ADASM-06 MONTHS 10/1/2024 4400 3800 West Bengal
ADASM-06 MONTHS 10/3/2024 4400 4000 Bihar
ADASM-06 MONTHS 10/3/2024 4400 3800 Maharashtra
ADASM-06 MONTHS 10/4/2024 4400 3800 Uttar Pradesh
ADASM-06 MONTHS 10/4/2024 4400 4400 Delhi
ADASM-06 MONTHS 10/5/2024 4400 3800 Gujarat
ADASM-06 MONTHS 10/8/2024 4400 4000 Uttar Pradesh
ADASM-06 MONTHS 10/8/2024 4400 3800 Uttar Pradesh
ADCA-12 MONTHS 10/18/2024 5500 5500 Bihar
DCA-12 MONTHS 3/11/2024 3200 500 Maharashtra
DCA-12 MONTHS 3/12/2024 3200 2600 Bihar
DCA-12 MONTHS 3/12/2024 3200 3200 Maharashtra
DCA-12 MONTHS 3/12/2024 3200 2600 Uttar Pradesh
DCA-12 MONTHS 3/13/2024 3200 2000 Delhi
DCA-12 MONTHS 3/13/2024 3200 3200 Gujarat
ADFA-12 MONTHS 5/7/2024 7500 6900 Madhya Pradesh
ADFA-12 MONTHS 5/8/2024 7500 7500 Rajasthan
ADFA-12 MONTHS 5/8/2024 7500 7500 Jharkhand
ADFA-12 MONTHS 5/8/2024 7500 7500 Uttarakhand
ADFA-12 MONTHS 5/9/2024 7500 6900 West Bengal
ADFA-12 MONTHS 5/9/2024 7500 7500 Bihar
ADFA-12 MONTHS 5/9/2024 7500 6900 Maharashtra
ADFA-12 MONTHS 5/10/2024 7500 7500 Uttar Pradesh
ADFA-12 MONTHS 5/10/2024 7500 7500 Delhi
ADFA-12 MONTHS 5/10/2024 7500 7100 Gujarat
ADFA-12 MONTHS 5/11/2024 7500 6900 Madhya Pradesh
ADFA-12 MONTHS 5/11/2024 7500 6900 Rajasthan
ADFA-12 MONTHS 5/11/2024 7500 7100 Jharkhand
ADCA-12 MONTHS 1/17/2024 5500 4900 Uttarakhand
ADCA-12 MONTHS 1/17/2024 5500 5500 West Bengal
DCA-12 MONTHS 3/29/2024 3200 2800 Bihar
DCA-12 MONTHS 3/29/2024 3200 2800 Maharashtra
DCA-12 MONTHS 3/29/2024 3200 3200 Uttar Pradesh
DCA-12 MONTHS 3/30/2024 3200 3200 Delhi
DCA-12 MONTHS 3/30/2024 3200 2600 Gujarat
DCA-12 MONTHS 3/30/2024 3200 2600 Uttar Pradesh
DCS-06 MONTHS 4/9/2024 1800 1800 Uttar Pradesh
DCS-06 MONTHS 4/9/2024 1800 1800 Bihar
ADFA-12 MONTHS 5/25/2024 7500 6900 Maharashtra
ADFA-12 MONTHS 5/27/2024 7500 7500 Bihar
ADFA-12 MONTHS 5/27/2024 7500 500 Maharashtra
ID No. Name Father Contact Number Gender Course B. Time
18001 JAY PRAKASH SHASHIKANT DIXIT 7075284477 Male ADCA 9 to 10
18002 ANOOP KUMAR SHRIPAL 9970705350 Male ADCA 9 to 10
18003 LAREB KHAN NASHIM ALI 6839500378 Male O-Level 3 to 5
18004 PAVAN PRATAP SINGH TRIBHUVAN LAL 8303081021 Male ADASM 8 to 9
18005 SAHIL KHAN GOKUL PRASAD 9667871287 Male ADASM 8 to 9
18006 SHIVAM DEVENDAR SINGH 9875805138 Female ADFA 10 to 12
18007 BABLU KUMAR BAGISH KUMAR MISHRA 9732877972 Male ADFA 10 to 12
18008 JAKEEL KHAN RAM LAKHAN 6994664630 Female O-Level 3 to 5
18009 PRACHI SINGH BRAJNATH KASHYAP 8393618316 Male ADCA 9 to 10
18010 SANDEEP KUMAR RAM KHELAWAN 9400433656 Female ADCA 9 to 10
18011 ABHISHEK SINGH VINOD KUMAR 7132577650 Male O-Level 3 to 5
18012 PANKAJ KUMAR SHAUKAT ALI 8911912322 Male ADASM 8 to 9
18013 ARJUN KUMAR RAJ SHAMSHUL HAQ 7356391485 Female ADASM 8 to 9
18014 MO. KAUSEN RAZA SANTOSH GAUTAM 7403466218 Female ADFA 10 to 12
18015 NAND LAL HETRAM 9341353550 Male ADFA 10 to 12
ID No. Name Contact Number Course B. Time
18009 PRACHI SINGH 8393618316 ADCA 9 to 10
Contact Number Name Father B. Time
8303081021 PAVAN PRATAP SINGH TRIBHUVAN LAL 8 to 9
