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
01/Jul/25 7/1/2025 10:41
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 Course
1 18001 JAY PRAKASH SHASHIKANT DIXIT Male ADASM-06 MONTHS
2 18002 ANOOP KUMAR SHRIPAL Male ADASM-06 MONTHS
3 18003 LAREB KHAN NASHIM ALI Male ADASM-06 MONTHS
4 18004 PAVAN PRATAP SINGH TRIBHUVAN LAL Male ADASM-06 MONTHS
5 18005 SAHIL KHAN GOKUL PRASAD Male ADASM-06 MONTHS
6 18006 SHIVAM DEVENDAR SINGH Female ADASM-06 MONTHS
7 18007 BABLU KUMAR BAGISH KUMAR MISHRA Male ADASM-06 MONTHS
8 18008 JAKEEL KHAN RAM LAKHAN Female ADASM-06 MONTHS
9 18009 PRACHI SINGH BRAJNATH KASHYAP Male ADASM-06 MONTHS
10 18010 SANDEEP KUMAR RAM KHELAWAN Female ADASM-06 MONTHS
11 18011 ABHISHEK SINGH VINOD KUMAR Male ADASM-06 MONTHS
12 18012 PANKAJ KUMAR SHAUKAT ALI Male ADASM-06 MONTHS
13 18013 ARJUN KUMAR RAJ SHAMSHUL HAQ Female ADASM-06 MONTHS
14 18014 MO. KAUSEN RAZA SANTOSH GAUTAM Female ADASM-06 MONTHS
15 18015 NAND LAL HETRAM Male ADASM-06 MONTHS
16 18016 ASHOK KUMAR CHANDRA BHAL Female ADCA-12 MONTHS
17 18017 GAYATRI DEVI TAHZEEB KHAN Female ADCA-12 MONTHS
18 18018 JANARDAN PAL RADHEY SHYAM MAURYA Female ADCA-12 MONTHS
19 18019 APOORVA VERMA ANIL KUMAR MAURYA Male ADCA-12 MONTHS
20 18020 SANJAY KUMAR JAGDISH PRASAD MAURYA Male ADCA-12 MONTHS
21 18021 SUNEEL KUMAR RAM MURTI Male ADCA-12 MONTHS
22 18022 AJAY KUMAR SANTOSH NISHAD Male ADCA-12 MONTHS
23 18023 DEEPAK KUMAR AVDHESH KUMAR MISHRA Male ADCA-12 MONTHS
24 18024 VINEET KUMAR TEJKARAN Female ADCA-12 MONTHS
25 18025 KAMLESH PRADEEP KUMAR AWASHTI Female ADCA-12 MONTHS
26 18026 SURAJ KUMAR TIWARI JAY PRAKASH CHAURASIYA Female ADCA-12 MONTHS
27 18027 UMESH KUMAR RAVENDRA KUMAR Male ADCA-12 MONTHS
28 18028 PALLAVI DEVI RAKESH GUPTA Male ADCA-12 MONTHS
29 18029 VIKRAM MOH ARIF Female DCA-12 MONTHS
30 18030 AMAN JAISWAL AZAMUDDEEN Male DCA-12 MONTHS
31 18031 JAKEEL KHAN MADHAV RAM Male DCA-12 MONTHS
32 18032 JAMEER AHMAD SHAMSUDDIN Male DCA-12 MONTHS
33 18033 LAREB KHAN JUGUL KISHOR Female DCA-12 MONTHS
34 18034 SAHIL KHAN MOH ARIF Male DCA-12 MONTHS
35 18035 SHIVANI PAL GUR DAYAL SINGH Male DCA-12 MONTHS
36 18036 RAVIN NIGAM HARIOM MISHRA Female DCA-12 MONTHS
37 18037 NAVNEET RAM NARESH Female DCA-12 MONTHS
38 18038 SHADAB ANSARI RAM KISHORE KASHYAP Female DCA-12 MONTHS
39 18039 MANISH KUMAR CHHOTE LAL Male DCA-12 MONTHS
40 18040 MOHAMMAD ALMAS PRAHLAD SINGH Male DCA-12 MONTHS
41 18041 ROSHNI DEVI RAJESH KUMAR Male DCA-12 MONTHS
42 18042 AKASH DEEP SINGH CHANDRIKA PRASAD Male DCA-12 MONTHS
43 18043 SURAJ KUMAR RAM GOPAL SONY Male DCA-12 MONTHS
44 18044 IRFAN ASHRAF ALI Male ADCA-12 MONTHS
45 18045 ABHISHEK VEERENDRA KUMAR Female ADCA-12 MONTHS
46 18046 DEEPAK KUMAR DINESH KUMAR Male ADASM-06 MONTHS
47 18047 JANARDAN PAL RAM ASARE Male ADASM-06 MONTHS
48 18048 SURAJ KUMAR TIWARI PRAHLAD SINGH Female ADASM-06 MONTHS
49 18049 KAMLESH BALVEER SINGH Male ADASM-06 MONTHS
50 18050 AJAY KUMAR SARVESH KUMAR Female ADASM-06 MONTHS
51 18051 PALLAVI DEVI ARVESH KUMAR Male ADASM-06 MONTHS
52 18052 UMESH KUMAR RAMESH KUMAR Male ADASM-06 MONTHS
53 18053 SANJAY KUMAR JAGTAR SINGH Female ADASM-06 MONTHS
54 18054 ABHISHEK RAM CHANDRA Male ADASM-06 MONTHS
55 18055 GAYATRI DEVI UTTAM PRAKASH PANDEY Male ADASM-06 MONTHS
56 18056 SUNEEL KUMAR SUJATA SHENDAGE Male ADASM-06 MONTHS
57 18057 VINEET KUMAR MO. SHAREEF Female ADASM-06 MONTHS
58 18058 APOORVA VERMA RAMENDRA KUMAR Male ADASM-06 MONTHS
59 18059 ASHOK KUMAR BIRENDRA KUMAR PANDEY Female ADASM-06 MONTHS
60 18060 IRFAN JAI PRAKASH Female ADASM-06 MONTHS
61 18061 TANMAY RAY RAM GOPAL Female ADCA-12 MONTHS
62 18062 RUKHMA DEVI RADHESHYAM Female DCA-12 MONTHS
63 18063 MANOJ KUMAR SAIDUL HASAN Male DCA-12 MONTHS
64 18064 RIYA SHRIVASTAVA RAM NIWAS Male DCA-12 MONTHS
65 18065 SATYAM TIWARI VIKRAMA RAJBHAR Female DCA-12 MONTHS
66 18066 RANJEET KUMAR RAJ BACHAN LAL Male DCA-12 MONTHS
67 18067 VIPIN MISHRA BHAIRAV SINGH Male DCA-12 MONTHS
68 18068 KULDEEP KUMAR AJAY BARANWAL Female ADFA-12 MONTHS
69 18069 JYOTI YADAV MOHAMMAD IRFAN Male ADFA-12 MONTHS
70 18070 PRANSHU MISHRA AMBIKA SHUKLA Male ADFA-12 MONTHS
71 18071 VISHNU MAHFOOZ KHAN Male ADFA-12 MONTHS
72 18072 MOHIT NAG KAMLESH KUMAR Male ADFA-12 MONTHS
73 18073 RAGHVENDRA SHUKLA RAMAKANT Female ADFA-12 MONTHS
74 18074 VAIBHAV AWASTHI NAUSAD ALI Male ADFA-12 MONTHS
75 18075 AKEEL KHAN DEVRAJ Female ADFA-12 MONTHS
76 18076 AYUSH MISHRA SHIVCHARAN Female ADFA-12 MONTHS
77 18077 NAJIS BANO WAHID ALI Male ADFA-12 MONTHS
78 18078 FIRDAUSH BARI KAMLESH KUMAR Male ADFA-12 MONTHS
79 18079 HIMANSHU YADAV RAM SHANKAR Male ADFA-12 MONTHS
80 18080 SHAHNUMA BANO YOGENDRA PRASAD YADAV Male ADFA-12 MONTHS
81 18081 ASHWANI KUMAR VERMA RAJESH KUMAR VISHWAKARMA Male ADCA-12 MONTHS
82 18082 SHUBHAM KUMAR JAMUNA PRASAD Male ADCA-12 MONTHS
83 18083 AVIRAL SHUKLA KRISHAN KUMAR Male DCA-12 MONTHS
84 18084 PRINCE CHAURASIYA SHRAVAN KUMAR Female DCA-12 MONTHS
85 18085 SHIVAM VERMA RAMA SHANKAR Male DCA-12 MONTHS
86 18086 PALAK DEVI RAKESH MISHRA Male DCA-12 MONTHS
87 18087 SAUMYA VERMA NAZIR AHMAD Female DCA-12 MONTHS
88 18088 VAIBHAV GUPTA GENDAN LAL Female DCA-12 MONTHS
89 18089 RAM LAKHAN RAJESH GUTPA Male DCS-06 MONTHS
90 18090 SHIVAM RAJ BAHADUR Male DCS-06 MONTHS
91 18091 ANSHUMAN MUBARAK ALI Female ADFA-12 MONTHS
92 18092 ARPIT SHUKLA BRAJESH KUMAR Male ADFA-12 MONTHS
93 18093 MAYANK GUPTA RAM MURTI Male ADFA-12 MONTHS
Admission date Total Fee Deposit Fee State
1/1/2024 4400 3800 Madhya Pradesh
1/2/2024 4400 1800 Rajasthan
1/2/2024 4400 4400 Chandigarh
1/2/2024 4400 4400 Bihar
1/2/2024 4400 500 Uttar Pradesh
1/2/2024 4400 3800 Goa
1/3/2024 4400 4400 Gujarat
1/3/2024 4400 4400 Haryana
1/3/2024 4400 4400 Himachal Pradesh
1/3/2024 4400 3800 Jharkhand
1/4/2024 4400 4000 Chhattisgarh
1/4/2024 4400 1200 Goa
1/5/2024 4400 3800 Madhya Pradesh
1/5/2024 4400 4400 Maharashtra
1/5/2024 4400 3800 Punjab
1/18/2024 5500 5500 Odisha
1/18/2024 5500 5500 Punjab
1/18/2024 5500 4900 Odisha
1/19/2024 5500 4900 Odisha
1/19/2024 5500 5500 Punjab
1/19/2024 5500 5500 Rajasthan
1/20/2024 5500 5100 Chandigarh
1/20/2024 5500 5500 Chhattisgarh
1/20/2024 5500 5100 Goa
1/22/2024 5500 4900 Goa
1/22/2024 5500 4900 Uttar Pradesh
1/22/2024 5500 1300 Uttarakhand
1/23/2024 5500 5500 West Bengal
2/12/2024 3200 3200 Chandigarh
2/13/2024 3200 3200 Chandigarh
2/13/2024 3200 2600 Haryana
2/13/2024 3200 2800 Haryana
2/13/2024 3200 3200 Delhi
2/13/2024 3200 2600 Bihar
2/13/2024 3200 2800 Maharashtra
2/14/2024 3200 1000 Uttar Pradesh
2/15/2024 3200 3200 Delhi
2/15/2024 3200 2600 Gujarat
2/16/2024 3200 3200 Madhya Pradesh
2/16/2024 3200 3200 Rajasthan
2/16/2024 3200 2600 Jharkhand
2/17/2024 3200 3200 Uttarakhand
2/17/2024 3200 2800 West Bengal
9/9/2024 5500 5500 Bihar
9/10/2024 5500 5500 Maharashtra
9/18/2024 4400 4400 Uttar Pradesh
9/18/2024 4400 4400 Delhi
9/21/2024 4400 3800 Gujarat
9/24/2024 4400 4000 Madhya Pradesh
9/25/2024 4400 4400 Rajasthan
9/26/2024 4400 3800 Jharkhand
9/26/2024 4400 3800 Uttarakhand
10/1/2024 4400 3800 West Bengal
10/3/2024 4400 4000 Bihar
10/3/2024 4400 3800 Maharashtra
10/4/2024 4400 3800 Uttar Pradesh
10/4/2024 4400 4400 Delhi
10/5/2024 4400 3800 Gujarat
10/8/2024 4400 4000 Uttar Pradesh
10/8/2024 4400 3800 Uttar Pradesh
10/18/2024 5500 5500 Bihar
3/11/2024 3200 500 Maharashtra
3/12/2024 3200 2600 Bihar
3/12/2024 3200 3200 Maharashtra
3/12/2024 3200 2600 Uttar Pradesh
3/13/2024 3200 2000 Delhi
3/13/2024 3200 3200 Gujarat
5/7/2024 7500 6900 Madhya Pradesh
5/8/2024 7500 7500 Rajasthan
5/8/2024 7500 7500 Jharkhand
5/8/2024 7500 7500 Uttarakhand
5/9/2024 7500 6900 West Bengal
5/9/2024 7500 7500 Bihar
5/9/2024 7500 6900 Maharashtra
5/10/2024 7500 7500 Uttar Pradesh
5/10/2024 7500 7500 Delhi
5/10/2024 7500 7100 Gujarat
5/11/2024 7500 6900 Madhya Pradesh
5/11/2024 7500 6900 Rajasthan
5/11/2024 7500 7100 Jharkhand
1/17/2024 5500 4900 Uttarakhand
1/17/2024 5500 5500 West Bengal
3/29/2024 3200 2800 Bihar
3/29/2024 3200 2800 Maharashtra
3/29/2024 3200 3200 Uttar Pradesh
3/30/2024 3200 3200 Delhi
3/30/2024 3200 2600 Gujarat
3/30/2024 3200 2600 Uttar Pradesh
4/9/2024 1800 1800 Uttar Pradesh
4/9/2024 1800 1800 Bihar
5/25/2024 7500 6900 Maharashtra
5/27/2024 7500 7500 Bihar
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
