Free Banking Notes — RBI, Banking Awareness, Reasoning

🔢

Quantitative Aptitude

Arithmetic, Algebra, DI & Advanced Math

20 Chapters▼

Number System

▼

Key Concepts

Natural Numbers: 1, 2, 3, … | Whole Numbers: 0, 1, 2, 3, …
Integers: …−2, −1, 0, 1, 2, … | Rational: p/q form (q≠0)
Prime Numbers: Divisible only by 1 and itself (2, 3, 5, 7, 11, …)
HCF & LCM: HCF × LCM = Product of two numbers
Divisibility Rules: 2 (even), 3 (digit sum÷3), 9 (digit sum÷9), 11 (alternating sum)

📌 Every prime > 3 is of the form 6k±1. The only even prime is 2.

Simplification & Approximation

▼

BODMAS Rule

Brackets → Order (powers/roots) → Division → Multiplication → Addition → Subtraction
For approximation: round values to nearest convenient number before solving

Useful Fraction-to-Decimal Conversions

Fraction	Decimal	%
1/4	0.25	25%
1/3	0.333	33.33%
1/8	0.125	12.5%
3/4	0.75	75%

💡 In approximation questions, never approximate beyond ±2% of actual value

Percentage

▼

Core Formulas

Percentage = (Value / Total) × 100
% Change = [(New − Old) / Old] × 100
Successive % change: A% then B% → Net = A + B + (AB/100)

✅ If price ↑ by r%, consumption must ↓ by [r/(100+r)]×100 to keep expenditure same

Profit & Loss

▼

Key Formulas

Profit % = (Profit / CP) × 100 | Loss % = (Loss / CP) × 100
SP = CP × (100 + Profit%) / 100 | CP = SP × 100 / (100 + Profit%)
Dishonest dealer: Profit% = (Error / True weight − Error) × 100
Marked Price: Discount % = (MP − SP) / MP × 100

💡 Two articles sold at same SP: one at X% profit, other at X% loss → always a loss of (X²/100)%

Simple & Compound Interest

▼

Formulas

SI = P × R × T / 100
CI = P × [(1 + R/100)ⁿ − 1]
CI − SI (2 yrs) = P × (R/100)²
CI − SI (3 yrs) = P × (R/100)² × (R/100 + 3)

📌 Money doubles in SI: T = 100/R years. Doubles in CI: ~70/R years (Rule of 72)

Ratio & Proportion

▼

Key Rules

If a:b = c:d then ad = bc (cross-multiplication)
Componendo: (a+b)/(a−b) = (c+d)/(c−d)
Duplicate ratio of a:b = a²:b²
Sub-duplicate ratio of a:b = √a:√b

✅ Mean Proportional of a and b = √(ab) | Third Proportional of a,b = b²/a

Partnership

▼

Profit Sharing Rule

Simple Partnership: Profit ∝ Capital invested (time equal)
Compound Partnership: Profit ∝ Capital × Time
If A invests ₹P₁ for t₁ months and B invests ₹P₂ for t₂ months → ratio = P₁t₁ : P₂t₂

💡 Working partner may get a salary/commission before profit is split

Average

▼

Formulas

Average = Sum of all observations / Number of observations
Average of first n natural numbers = (n+1)/2
Average of first n even numbers = n+1 | first n odd numbers = n
If average of a group increases/decreases by x when a new member joins → use: new sum = new count × new avg

Mixture & Alligation

▼

Alligation Rule

Ratio of quantities = (Dearer price − Mean price) : (Mean price − Cheaper price)
Used to find: mixing two solutions, average speed, average cost etc.

📌 Withdrawal & replacement: Final conc. = C × (1 − x/V)ⁿ where x = amount replaced each time, V = total volume, n = times

Time & Work

▼

Key Concepts

If A completes work in n days → A's 1-day work = 1/n
A and B together: 1/A + 1/B = 1/T → T = AB/(A+B)
Efficiency method: Assume total work = LCM of days; calculate units/day for each person

✅ M₁D₁H₁/W₁ = M₂D₂H₂/W₂ (work equivalence formula for different persons, days, hours)

Pipes & Cisterns

▼

Core Rules

Pipe filling tank in x hrs → rate = 1/x per hour (positive)
Pipe emptying tank in y hrs → rate = −1/y per hour (negative)
Net rate when both open = 1/x − 1/y; time = xy/(y−x)

💡 If leak empties a full tank in L hours and inlet fills in F hours → time to fill with leak = FL/(L−F)

Time, Speed & Distance

▼

Formulas

Speed = Distance / Time | 1 km/h = 5/18 m/s | 1 m/s = 18/5 km/h
Average Speed (same distance) = 2xy/(x+y) where x, y are two speeds
Relative Speed: Same direction = |S₁−S₂| | Opposite direction = S₁+S₂

📌 Train crossing a pole: Time = Length/Speed. Train crossing bridge: Time = (Train + Bridge length)/Speed

Boats & Streams

▼

Key Terms

Downstream speed = Boat speed + Stream speed (u+v)
Upstream speed = Boat speed − Stream speed (u−v)
Boat speed = (Downstream + Upstream) / 2
Stream speed = (Downstream − Upstream) / 2

Linear & Quadratic Equations

▼

Quadratic — ax² + bx + c = 0

Roots: x = [−b ± √(b²−4ac)] / 2a
Sum of roots = −b/a | Product of roots = c/a
Discriminant D = b²−4ac: D>0 (real distinct), D=0 (equal), D<0 (imaginary)

Inequalities

Multiplying/dividing by negative flips the inequality sign
For quadratic inequality, find roots then test intervals

Data Interpretation — Table & Bar Graph

▼

Strategy

Read all column/row headings before solving any question
Identify the unit (₹ crore, thousands, %) upfront
For Bar Graphs: compare bar heights visually before calculating
Missing DI: find the missing value using given total or ratio

📌 Types: Table DI, Bar Graph, Line Graph, Pie Chart, Caselet DI, Missing DI — each requires 5–6 questions in mains exam

Data Interpretation — Pie Chart & Line Graph

▼

Pie Chart

Total = 360° or 100%
Value of a sector = (Angle/360) × Total or (% / 100) × Total

Caselet DI

Data given in paragraph form — extract and tabulate before solving
Watch for keywords: "remaining", "rest", "twice as many as", "ratio of"

Permutation & Combination

▼

Formulas

nPr = n! / (n−r)! | nCr = n! / [r!(n−r)!]
Permutation = arrangement (order matters) | Combination = selection (order does not matter)
Circular arrangement of n objects = (n−1)!

✅ nCr = nC(n-r) | nC0 = nCn = 1 | nC1 = n

Probability

▼

Key Formulas

P(E) = Favourable outcomes / Total outcomes; 0 ≤ P(E) ≤ 1
P(A∪B) = P(A) + P(B) − P(A∩B)
P(A') = 1 − P(A)
For independent events: P(A∩B) = P(A) × P(B)

Mensuration (2D & 3D)

▼

2D Shapes

Shape	Area	Perimeter
Circle	πr²	2πr
Triangle	½ × base × height	a+b+c
Rectangle	l × b	2(l+b)
Trapezium	½(a+b)×h	a+b+c+d

3D Shapes

Shape	Volume	CSA
Cylinder	πr²h	2πrh
Cone	⅓πr²h	πrl
Sphere	4/3πr³	4πr²

Data Sufficiency

▼

Approach

Do NOT solve the problem completely — just check if data is sufficient
Check Statement I alone → Statement II alone → Both together
If both give unique answer → "Either alone is sufficient"
If neither gives unique answer → "Data insufficient"

💡 Common traps: assuming values not stated, confusing "cannot determine" with "data insufficient"

🧠

Reasoning Ability

Puzzles, Logical & Analytical Reasoning

14 Chapters▼

Linear & Circular Seating Arrangement

▼

Types

Linear (single row): All face North OR all face South
Linear (two rows): Two groups facing each other
Circular: All face center OR all face outward OR mixed

Strategy

Draw arrangement immediately; start with the person having the most clues
Use definite clues before conditional ones
In circular (facing center): "A right of B" = A is clockwise from B

🪑 In linear facing North: your left = West, your right = East

Square / Rectangular Arrangement

▼

Key Points

Corner persons have neighbors on two sides only
Side (non-corner) persons face the center differently from corner ones
Always label corners and sides before placing persons

Floor-based & Box-based Puzzles

▼

Floor Puzzle

Fix topmost and bottommost floors first using definite clues
Track "above" / "below" / "immediately above/below" separately

Box Puzzle

Usually 6–8 boxes stacked; similar strategy to floors
Assign row numbers (1 = top or bottom — check problem statement)

Scheduling Puzzle

▼

Approach

Create a grid: Persons × Days/Months/Slots
Fix definite assignments first, then eliminate possibilities
Watch for "not on the same day" and "consecutive" clues

Syllogism

▼

Basic Rules (Venn Diagram Method)

All A are B + All B are C → All A are C ✅
All A are B + Some B are C → Some A are C ❌ (not definite)
No A are B + All B are C → No A are C ✅
Some A are B + Some B are C → No definite conclusion ❌

New Pattern

"Definitely" = must be true in ALL Venn diagram cases
"Possibility" = true in at least ONE Venn diagram case

✅ Either-or: both conclusions individually wrong but together exhaustive → "Either I or II follows"

Coding-Decoding

▼

Types

Letter coding: Each letter shifted by fixed number (A→D means +3)
Number coding: Words assigned number values; find the pattern
New pattern: Random symbol coding — match given pairs to decode new word

📌 Always write the alphabet with position numbers (A=1, B=2 … Z=26) for quick reference

Blood Relations

▼

Strategy

Draw a family tree immediately — top = older generation
Use M (Male) / F (Female) labels for each person
Identify the reference person in every question

💡 "Son of my father's only daughter" = my own son

Direction Sense

▼

Key Tips

Always draw a map: fix starting point, mark North up
After turning right: N→E→S→W→N (clockwise)
After turning left: N→W→S→E→N (anticlockwise)
Final distance = use Pythagoras theorem for displacement

Order & Ranking + Inequality

▼

Order & Ranking

Position from left + Position from right = Total + 1
If two persons swap positions, one position changes and the other stays — re-read carefully

Coded Inequality

Decode the symbols first (e.g., $ means ≥), then apply normal inequality rules
Watch for "either conclusion I or II": happens when combined they cover all cases

Input-Output

▼

Approach

Identify the pattern from Step 0 → Step 1 → Step 2
Common patterns: words/numbers arranged in ascending/descending order alternately, word-number shuffle
Find the rule, then apply it to reach the target step

Data Sufficiency (Reasoning)

▼

Options Framework

A: Statement I alone sufficient
B: Statement II alone sufficient
C: Both together sufficient
D: Either alone sufficient
E: Even together not sufficient

Decision Making

▼

Tips

Read the given policy/rule carefully before evaluating the case
Apply conditions strictly — do not assume information not given
If borderline case → use the "refer to higher authority" option

Alphanumeric Series & Alphabet Test

▼

Key Concepts

Series may include letters, numbers and symbols — find repeating pattern
Count positions: EJOTY rule — E=5, J=10, O=15, T=20, Y=25
Opposite letters: A↔Z, B↔Y, C↔X … (sum of positions = 27)

Odd One Out

▼

English Language

Grammar, Vocabulary, Reading & Verbal Ability

14 Chapters▼

Parts of Speech & Tenses

▼

Parts of Speech (8 Types)

Noun, Pronoun, Verb, Adjective, Adverb, Preposition, Conjunction, Interjection

Tenses Quick Reference

Tense	Form
Simple Present	V1 / V1+s
Present Continuous	is/am/are + V-ing
Present Perfect	has/have + V3
Simple Past	V2
Past Perfect	had + V3

Subject-Verb Agreement

▼

Key Rules

Singular subject → singular verb (He runs)
"Either…or / Neither…nor": verb agrees with the nearer subject
Collective nouns (team, committee) take singular verb when acting as one unit
"Each", "every", "everyone" → always singular

Articles & Prepositions

▼

Articles

A — before consonant sound | An — before vowel sound
The — specific/known noun; superlatives; unique things (the Sun)
No article: proper nouns (generally), languages, meals, sports

Common Prepositions

at (point of time/place) | in (inside/month/year) | on (surface/day/date)
since (point of time) | for (duration) | by (not later than)

Active-Passive Voice & Direct-Indirect Speech

▼

Active to Passive

Object of active → Subject of passive
Verb: is/am/are/was/were/be/been/being + V3
Subject of active → "by + object" (if mentioned)

Direct to Indirect

Remove quotation marks; use reporting verb + that/if/wh-word
Tense backshift: Present → Past, Past → Past Perfect
Pronouns change based on subject/object of reporting clause

Synonyms, Antonyms & Word Usage

▼

Tips

Learn roots: "bene" (good), "mal" (bad), "dict" (say), "rupt" (break)
Context clues: use surrounding sentence to infer meaning
Eliminate: rule out options that are clearly opposite or unrelated

📌 Build vocabulary from editorial sections of newspapers — target 10 new words daily

Idioms, Phrases & One Word Substitution

▼

Common Idioms

Beat around the bush — avoid the main topic
Break the ice — initiate conversation
Cost an arm and a leg — very expensive
Bite the bullet — endure pain/difficulty

One Word Substitution

Omnivore — eats both plants and animals
Atheist — one who does not believe in God
Insolvent — unable to pay debts
Nemesis — one who inflicts just punishment

Reading Comprehension

▼

Strategy

Read questions first, then skim passage for relevant paragraphs
Main idea questions → check first and last paragraphs
Inference questions → answer must be implied, not stated directly
Tone/attitude questions → look for positive/negative/neutral language

✅ Never bring outside knowledge — answer only from the passage

Cloze Test

▼

Approach

Read the entire passage once for overall context before filling blanks
Check grammatical fit: noun/verb/adjective/adverb required?
Eliminate options that break the logical flow of the paragraph

Error Detection & Sentence Improvement

▼

Common Error Areas

Subject-verb agreement
Wrong tense usage
Misuse of articles and prepositions
Dangling modifiers and parallelism errors
Double negatives

💡 Read each part aloud mentally — your ear often catches errors faster than your eye

Para Jumbles

▼

Strategy

Find the opening sentence: introduces topic, no pronoun reference back, no connective word
Find the closing sentence: concluding word (hence, thus, therefore), no further follow-up
Look for pronoun–noun pairs and connector words (however, moreover, therefore)
Use elimination to narrow down answer choices

Fill in the Blanks

▼

Approach

Single blank: check grammar + meaning fit
Double blank: eliminate options where either word does not fit
Connector words (although, because, however) signal contrast or cause

🌍

General Awareness (Banking + Current Affairs)

Banking Awareness, Static GK & Current Affairs

17 Chapters▼

History of Banking in India

▼

Key Milestones

Bank of Hindustan (1770) — first bank in India
Imperial Bank of India (1921) → became SBI in 1955
RBI established: 1 April 1935; Nationalised: 1949
Bank Nationalisation: 14 banks in 1969, 6 more in 1980
Liberalisation (1991): Private banks allowed — HDFC, ICICI, Axis

Reserve Bank of India (RBI) Functions

▼

Core Functions

Monetary authority — controls money supply and inflation
Banker to the Government — manages public debt, account of Centre & States
Banker's bank — lender of last resort to scheduled banks
Currency issuer — issues all notes except ₹1 coin & note (Ministry of Finance)
Foreign exchange management — custodian of forex reserves

Monetary Policy

▼

Key Monetary Policy Tools

Tool	Definition	Effect when ↑
Repo Rate	Rate RBI lends to banks	Credit costlier → less borrowing
Reverse Repo	Rate banks park money with RBI	Banks park more → less credit
CRR	% deposits kept with RBI (cash)	Less money with banks → credit contracts
SLR	% deposits in govt securities	Banks have less to lend
Bank Rate	Long-term lending rate by RBI	Long-term credit expensive

📌 Repo Rate ↑ → Borrowing cost ↑ → Credit supply ↓ → Inflation controlled

Types of Banks

▼

Public Sector Banks: SBI, PNB, Bank of Baroda (Govt owns majority)
Private Sector Banks: HDFC, ICICI, Axis, Kotak
Foreign Banks: Citibank, HSBC, Deutsche Bank
Regional Rural Banks (RRBs): Serve rural areas; owned by Centre + State + Sponsor bank
Small Finance Banks: Serve unserved/underserved segments
Payment Banks: Accept deposits up to ₹2 lakh; cannot issue loans

Financial Institutions

▼

NABARD: Agriculture & rural development | HQ: Mumbai
SIDBI: Small Industries Development Bank | HQ: Lucknow
NHB: National Housing Bank | HQ: New Delhi
EXIM Bank: Export-Import financing | HQ: Mumbai
SEBI: Securities market regulator | HQ: Mumbai
IRDAI: Insurance regulator | HQ: Hyderabad
PFRDA: Pension fund regulator | HQ: New Delhi

Banking Terms (NPA, CRR, SLR, Repo Rate)

▼

Term	Full Form / Meaning
NPA	Non-Performing Asset — loan unpaid for 90+ days
NBFC	Non-Banking Financial Company (e.g., LIC, Bajaj Finance)
KYC	Know Your Customer — mandatory identity verification
NEFT	National Electronic Funds Transfer — settled in batches
RTGS	Real Time Gross Settlement — min ₹2 lakh, real-time
IMPS	Immediate Payment Service — 24×7 including holidays
UPI	Unified Payments Interface — instant mobile payment
SWIFT	Society for Worldwide Interbank Financial Telecommunication
CIBIL	Credit score (300–900); 750+ is good
FDI	Foreign Direct Investment — equity stake in Indian company

Digital Banking

▼

UPI: Unified Payments Interface — instant, 24×7, mobile-based
BHIM: Bharat Interface for Money — NPCI app for UPI
NACH: National Automated Clearing House — bulk payments (salaries, pensions)
e-RUPI: Digital voucher by RBI; person & purpose-specific
CBDC: Central Bank Digital Currency — digital rupee by RBI

💡 RTGS min = ₹2 lakh | NEFT = no minimum | IMPS = 24×7 | UPI = instant, free

Countries, Capitals & Currencies

▼

Country	Capital	Currency
USA	Washington D.C.	US Dollar
UK	London	Pound Sterling
Japan	Tokyo	Yen
China	Beijing	Renminbi (Yuan)
Australia	Canberra	Australian Dollar
Brazil	Brasília	Real

Important Days & Books & Authors

▼

Important Days

Jan 30 — Martyrs Day | Mar 8 — International Women's Day
Apr 22 — Earth Day | Jun 5 — World Environment Day
Oct 2 — Gandhi Jayanti | Nov 14 — Children's Day

Books & Authors (Banking Context)

India's Turn — Manish Sabharwal
Fault Lines — Raghuram Rajan
An Era of Darkness — Shashi Tharoor

National Parks, Wildlife & HQs of Organizations

▼

National Parks

Jim Corbett (Uttarakhand) — first national park | Tiger Reserve
Kaziranga (Assam) — one-horned rhinoceros
Sundarbans (West Bengal) — largest mangrove; Bengal Tiger

HQs of Key Organizations

IMF & World Bank — Washington D.C. | WTO — Geneva | ADB — Manila
AIIB — Beijing | NDB (BRICS Bank) — Shanghai

National & International Current Affairs

▼

What to Track

Government schemes & their ministries
Union Budget highlights
Economic Survey key data
India's bilateral agreements & summits
New appointments (RBI Governor, Finance Minister, Cabinet changes)

📌 Read one quality newspaper or follow a monthly current affairs digest — revise last 6 months before exam

Economy & Finance

▼

GDP: Gross Domestic Product — total value of goods & services produced
GNP: GDP + Net factor income from abroad
Inflation: CPI (Consumer Price Index) — measured monthly by MoSPI
WPI: Wholesale Price Index — measures wholesale level price change
Fiscal Deficit: Excess of total expenditure over total receipts (excl. borrowings)

Awards & Honours

▼

Bharat Ratna — Highest civilian honour | Padma Awards — Padma Vibhushan, Bhushan, Shri
Nobel Prize: Peace — Oslo; others — Stockholm; announced October each year
Booker Prize — English fiction | Man Booker International — translated fiction
Dadasaheb Phalke — Highest film honour in India

Sports News

▼

What to Track

ICC Cricket tournament results & player awards
Olympic & Commonwealth Games — Indian medal winners
Grand Slam winners (Tennis) | FIFA World Cup host & winner
Arjuna, Dronacharya, Khel Ratna award winners

Appointments & Resignations

▼

What to Track

RBI Governor, Deputy Governors
SEBI, IRDAI, PFRDA Chairpersons
CEOs of major PSU banks (SBI, PNB, Canara)
New CMs, Governors of States
Heads of International Organizations (IMF MD, WB President, UN SG)

Government Schemes

▼

Scheme	Focus	Ministry
PM Jan Dhan Yojana	Financial inclusion — zero balance accounts	Finance
PMJJBY	Life insurance ₹2L cover	Finance
PMSBY	Accidental insurance ₹2L cover	Finance
Atal Pension Yojana	Pension for unorganized sector	Finance/PFRDA
Mudra Yojana	Loans to micro enterprises	Finance
Startup India	Promote entrepreneurship	Commerce

💻

Computer Knowledge

Basics, Hardware, Networking & Applications

14 Chapters▼

Fundamentals of Computers

▼

Definition & Characteristics

Computer: Electronic device that accepts data, processes it and gives output
Key characteristics: Speed, Accuracy, Automation, Versatility, Storage, Diligence
IPO Cycle: Input → Process → Output

Number Systems

System	Base	Digits
Binary	2	0, 1
Octal	8	0–7
Decimal	10	0–9
Hexadecimal	16	0–9, A–F

Generations of Computers & Types

▼

Generation	Technology	Era
1st	Vacuum Tubes	1940s–50s
2nd	Transistors	1950s–60s
3rd	Integrated Circuits (ICs)	1960s–70s
4th	Microprocessors (VLSI)	1970s–present
5th	Artificial Intelligence	Present & beyond

Types of Computers

Supercomputer (most powerful) | Mainframe | Minicomputer | Microcomputer (PC)

Input & Output Devices

▼

Input Devices

Keyboard, Mouse, Scanner, Microphone, Webcam, Touchscreen, Joystick, Barcode Reader, OMR, OCR

Output Devices

Monitor, Printer, Speaker, Projector, Plotter

📌 Touchscreen is BOTH input and output (I/O device)

Memory (RAM, ROM, Cache)

▼

Type	Full Form	Nature
RAM	Random Access Memory	Volatile (lost on power off)
ROM	Read Only Memory	Non-volatile; stores BIOS
Cache	—	Fastest; between CPU and RAM
HDD	Hard Disk Drive	Secondary storage; non-volatile
SSD	Solid State Drive	Faster than HDD; non-volatile

✅ Memory hierarchy (fastest to slowest): Registers → Cache → RAM → SSD/HDD → Cloud

Operating System

▼

Functions

Interface between user and hardware
Process management, Memory management, File management, Device management

Types

Single-user (Windows), Multi-user (Linux/Unix), Real-time OS (RTOS), Batch OS, Distributed OS

💡 Popular OS: Windows, macOS, Linux, Android (mobile), iOS

Internet Basics

▼

Key Terms

WWW: World Wide Web — system of interlinked web pages
HTTP/HTTPS: Protocol for web communication; S = Secure (SSL/TLS)
IP Address: Unique numerical label for each device (IPv4 = 32-bit, IPv6 = 128-bit)
URL: Uniform Resource Locator — web address
Browser: Chrome, Firefox, Edge, Safari

Networking Concepts

▼

Term	Full Form / Meaning
LAN	Local Area Network — small area (office, building)
WAN	Wide Area Network — large geographic area; Internet is largest WAN
MAN	Metropolitan Area Network — city-level
Router	Connects different networks; assigns IP addresses
Switch	Connects devices within same network
Modem	Modulator-Demodulator — converts digital ↔ analog
DNS	Domain Name System — maps domain name to IP address

Cyber Security

▼

Common Threats

Virus: Self-replicating malicious program
Worm: Spreads across networks without user action
Trojan: Disguises as legitimate software
Phishing: Fraudulent attempt to steal credentials via fake email/site
Ransomware: Encrypts data; demands ransom
Firewall: Security system that monitors/controls network traffic

💡 CERT-In (Computer Emergency Response Team — India) handles cyber incidents in India

MS Word

▼

Key Shortcuts

Shortcut	Action
Ctrl+S	Save
Ctrl+Z / Ctrl+Y	Undo / Redo
Ctrl+B / I / U	Bold / Italic / Underline
Ctrl+F	Find
Ctrl+H	Find & Replace
Ctrl+P	Print

📌 Default file extension: .docx | Mail merge used to send bulk personalized letters

MS Excel

▼

Key Functions

=SUM(A1:A10) | =AVERAGE(B1:B5) | =MAX() | =MIN() | =COUNT()
=IF(condition, value_if_true, value_if_false)
=VLOOKUP(lookup_value, table_array, col_index, [range_lookup])

Key Facts

Max rows: 1,048,576 | Max columns: 16,384 (XFD)
Default extension: .xlsx | Charts: Bar, Pie, Line, Column

MS PowerPoint & Shortcuts

▼

PowerPoint Basics

Default extension: .pptx | Presentation = collection of slides
Views: Normal, Slide Sorter, Notes Page, Reading View, Slide Show
F5 = Start slide show | Shift+F5 = Start from current slide

Common Shortcuts (All MS Office)

Ctrl+C / V / X — Copy / Paste / Cut
Ctrl+A — Select All | Ctrl+N — New | Ctrl+O — Open
Alt+F4 — Close application | F12 — Save As

Database Basics

▼

Key Terms

DBMS: Database Management System — software to manage databases (MySQL, Oracle)
Table: Data organized in rows (records) and columns (fields)
Primary Key: Unique identifier for each record
Foreign Key: Links two tables together
SQL: Structured Query Language — SELECT, INSERT, UPDATE, DELETE

Cloud Computing

▼

Service Models

IaaS — Infrastructure as a Service (e.g., AWS EC2)
PaaS — Platform as a Service (e.g., Google App Engine)
SaaS — Software as a Service (e.g., Gmail, Salesforce)

Deployment Models

Public Cloud (shared) | Private Cloud (dedicated) | Hybrid Cloud (mixed)

✅ Key cloud providers: AWS (Amazon), Azure (Microsoft), GCP (Google)

Artificial Intelligence (Basics)

▼

Key Concepts

AI: Machines simulating human intelligence — reasoning, learning, problem-solving
Machine Learning (ML): AI subset where systems learn from data
Deep Learning: ML subset using neural networks with many layers
NLP: Natural Language Processing — AI understanding human language (e.g., chatbots)
Robotics: AI applied to physical machines

📌 Turing Test: determines if a machine can exhibit intelligent behavior indistinguishable from a human

Free Banking Chapter-Wise Notes

Quantitative Aptitude

Key Concepts

BODMAS Rule

Useful Fraction-to-Decimal Conversions

Core Formulas

Key Formulas

Formulas

Key Rules

Profit Sharing Rule

Formulas

Alligation Rule

Key Concepts

Core Rules

Formulas

Key Terms

Quadratic — ax² + bx + c = 0

Inequalities

Strategy

Pie Chart

Caselet DI

Formulas

Key Formulas

2D Shapes

3D Shapes

Approach

Reasoning Ability

Types

Strategy

Key Points

Floor Puzzle

Box Puzzle

Approach

Basic Rules (Venn Diagram Method)

New Pattern

Types

Strategy

Key Tips

Order & Ranking

Coded Inequality

Approach

Options Framework

Tips

Key Concepts

Categories

English Language

Parts of Speech (8 Types)

Tenses Quick Reference

Key Rules

Articles

Common Prepositions

Active to Passive

Direct to Indirect

Tips

Common Idioms

One Word Substitution

Strategy

Approach

Common Error Areas

Strategy

Approach

General Awareness (Banking + Current Affairs)

Key Milestones

Core Functions

Key Monetary Policy Tools

Important Days

Books & Authors (Banking Context)

National Parks

HQs of Key Organizations

What to Track

What to Track

What to Track

Computer Knowledge

Definition & Characteristics

Number Systems

Types of Computers

Input Devices

Output Devices

Functions

Types