Computer Aptitude for Bank Exams: Fundamentals, Shortcuts, Networking and Banking Tech

Cover the full Computer Aptitude syllabus of IBPS and SBI mains (hardware, memory, number systems, MS Office shortcuts, networking, internet, DBMS, cyber security and banking technology like UPI, NEFT, RTGS and IMPS) with clear tables, worked conversions and exam traps.

Reviewed by (19 years teaching)Written with AI helpReport a mistake

9 min read · Published 3 November 2026

Part of Banking (IBPS / SBI) prep

Your computer is a bank branch

Think of a computer as a busy bank branch. The CPU is the branch manager who takes every decision. RAM is the manager's desk: files kept there are handled quickly, but the desk is cleared every evening when the branch shuts (power off). The hard disk is the strong room, where records stay safe for years. The keyboard and cheque-reading machine are the enquiry counter (input), and the printer that prints your passbook is the output counter. Once you see the computer as a branch, half of Computer Aptitude stops feeling like a list to mug up.

In IBPS PO and Clerk mains, and in SBI mains, Computer Aptitude is clubbed with Reasoning in one section. It usually carries around 15 to 20 questions, and most of them are direct, one-line facts: which key does what, which memory is volatile, which protocol sends email, what RTGS stands for. That makes it the fastest scoring part of the section. Each question takes 15 to 30 seconds if you know the fact, which saves precious minutes for the long puzzles. The only risk is negative marking (0.25 mark per wrong answer), so guess only when you can eliminate options.

1. Computer fundamentals: hardware and software

Hardware is every part you can touch: CPU, monitor, keyboard, motherboard. Software is the set of instructions that tells the hardware what to do. Software has two big families. System software runs the machine itself (operating systems like Windows, Linux, Android, plus device drivers and utilities). Application software does a job for the user (MS Word, Excel, a browser, a banking app). The CPU has three parts: the ALU (Arithmetic Logic Unit) does calculations and comparisons, the CU (Control Unit) directs the flow of data and instructions, and registers are tiny, ultra-fast storage slots inside the CPU.

CategoryExamplesBank-exam favourite
Input devicesKeyboard, mouse, scanner, microphone, webcamMICR reader (reads cheque numbers), OMR, OCR, barcode reader
Output devicesMonitor, printer, speaker, projectorPlotter (large drawings), dot-matrix printer (impact printer)
Both input and outputTouchscreen, modem, headset with micTouchscreen at ATMs and kiosks
TranslatorsCompiler, interpreter, assemblerCompiler converts the whole program at once; interpreter goes line by line
MICR stands for Magnetic Ink Character Recognition. Banks print the cheque number, the 9-digit MICR code and account details in magnetic ink so machines can read them fast. Do not confuse the 9-digit MICR code with the 11-character IFSC code.

2. Memory: speed, size and the volatile trap

Memory is arranged like a pyramid. At the top are registers, then cache, then RAM: fast, small and costly. At the bottom are hard disks, SSDs and pen drives: slower, huge and cheap. Primary memory (RAM and ROM) talks directly to the CPU; secondary memory (HDD, SSD, CD, pen drive) stores data permanently.

MemoryVolatile?Key fact
RegistersYesFastest memory, inside the CPU
CacheYesSits between CPU and RAM; holds frequently used data
RAMYesWorking memory; contents lost when power goes off. Types: SRAM (used in cache), DRAM (main memory)
ROMNoHolds startup instructions (BIOS/firmware). Types: PROM, EPROM (erased by UV light), EEPROM (erased electrically)
HDD / SSDNoSecondary storage; SSD has no moving parts, so it is faster than HDD
1 nibble = 4 bits | 1 byte = 8 bits | 1 KB = 1024 bytes | 1 MB = 1024 KB | 1 GB = 1024 MB | 1 TB = 1024 GB | 1 PB = 1024 TB
Volatile means the data disappears without power. RAM and cache are volatile; ROM, hard disk, SSD and pen drive are non-volatile. Examiners love to put 'ROM is volatile' as a tempting wrong option.

3. Number systems: binary, octal, decimal, hex

SystemBaseDigits used
Binary20, 1
Octal80 to 7
Decimal100 to 9
Hexadecimal160 to 9 and A to F (A = 10, B = 11, C = 12, D = 13, E = 14, F = 15)

Decimal to binary (divide-by-2 method)

  1. 1Divide the number by 2 and write down the remainder (0 or 1).
  2. 2Keep dividing the quotient by 2 until the quotient becomes 0.
  3. 3Read the remainders from bottom to top: that is your binary number.

Convert decimal 45 into binary

45 ÷ 2 = 22, remainder 1

22 ÷ 2 = 11, remainder 0

11 ÷ 2 = 5, remainder 1

5 ÷ 2 = 2, remainder 1

2 ÷ 2 = 1, remainder 0

1 ÷ 2 = 0, remainder 1

Read bottom to top: 101101

Check: 32 + 0 + 8 + 4 + 0 + 1 = 45 ✓

Convert binary 11010110 into hexadecimal and decimal

Group into 4 bits from the right: 1101 | 0110

1101 = 8 + 4 + 0 + 1 = 13 = D; 0110 = 0 + 4 + 2 + 0 = 6

So binary 11010110 = D6 in hex

Decimal: D6 = 13 × 16 + 6 = 208 + 6 = 214

⚡ Shortcut: 3 bits make one octal digit, 4 bits make one hex digit

Convert hexadecimal AF into decimal

A = 10 and F = 15

AF = 10 × 16 + 15 = 160 + 15 = 175

Bonus: the largest 2-digit hex number FF = 15 × 16 + 15 = 255

4. MS Office shortcuts that keep repeating

ShortcutActionWhere
Ctrl + C / Ctrl + X / Ctrl + VCopy / Cut / PasteAll Office apps
Ctrl + Z / Ctrl + YUndo / RedoAll Office apps
Ctrl + B / Ctrl + I / Ctrl + UBold / Italic / UnderlineAll Office apps
Ctrl + S / F12Save / Save AsAll Office apps
Ctrl + P / Ctrl + NPrint / New documentAll Office apps
Ctrl + F / Ctrl + HFind / ReplaceWord, Excel
Ctrl + KInsert hyperlinkWord, Excel, PowerPoint
F7Spelling and grammar checkWord
Ctrl + E / Ctrl + L / Ctrl + R / Ctrl + JCentre / Left / Right / Justify alignmentWord
F2Edit the active cellExcel
Ctrl + ;Insert today's dateExcel
F5 / Shift + F5Slide show from beginning / from current slidePowerPoint
Alt + F4Close the active window or programWindows
Excel facts asked often: every formula starts with '=', a cell address like B7 means column B and row 7, $B$7 is an absolute reference (it does not change when copied), and functions like SUM, AVERAGE, COUNT, MAX and IF are the usual ones in options.

Quick check

Which of the following memories loses its contents when the computer is switched off?

5. Networking and the internet

Networks are classified by area: PAN (personal, like Bluetooth between phone and earbuds), LAN (one office or branch), MAN (a city) and WAN (across countries; the internet is the biggest WAN). Topology is the layout: in star topology every computer connects to a central hub or switch, in bus topology all share one backbone cable, in ring topology each computer links to two neighbours in a circle, and in mesh topology every node connects to many others for maximum reliability.

TermWhat it means
Hub / Switch / RouterHub sends data to all ports; switch sends only to the right device using MAC addresses; router connects different networks using IP addresses
IP addressLogical address of a device. IPv4 is 32-bit, IPv6 is 128-bit
MAC addressPhysical, 48-bit hardware address burnt into the network card
DNSConverts a domain name like example.com into an IP address (the internet's phone book)
HTTP / HTTPSWeb page transfer; HTTPS adds encryption (SSL/TLS) and is used by net banking
SMTP / POP3 / IMAPSMTP sends email; POP3 and IMAP receive email
FTPFile Transfer Protocol, for moving files between computers
URLFull web address, e.g. https://www.example.com/page
OSI model7 layers: Physical, Data Link, Network, Transport, Session, Presentation, Application
Memory trick for the OSI layers from bottom to top: 'Please Do Not Throw Sausage Pizza Away' = Physical, Data Link, Network, Transport, Session, Presentation, Application.

6. DBMS basics

A DBMS (Database Management System) stores data in an organised way so it can be searched and updated safely. Your bank's customer records live in a relational database, where data sits in tables. A row is called a record or tuple, and a column is called a field or attribute. The relational model was proposed by E. F. Codd. A primary key uniquely identifies each row and cannot be null (think of your account number). A foreign key in one table points to the primary key of another table, linking them (for example, a transactions table that stores the account number).

SQL groupCommandsPurpose
DDL (Data Definition Language)CREATE, ALTER, DROP, TRUNCATEDefine or change the structure of tables
DML (Data Manipulation Language)SELECT, INSERT, UPDATE, DELETEWork with the data inside tables
DCL (Data Control Language)GRANT, REVOKEGive or take back access rights
TCL (Transaction Control Language)COMMIT, ROLLBACK, SAVEPOINTConfirm or undo a transaction

7. Cyber security

ThreatHow it works
PhishingFake email or website that tricks you into giving passwords or card details
Vishing / SmishingPhishing over a voice call / over SMS
VirusMalicious code that attaches to a file and spreads when that file runs
WormSpreads on its own across networks without needing a host file
Trojan horseLooks like useful software but opens a hidden backdoor
RansomwareEncrypts your files and demands payment to unlock them
Spyware / KeyloggerSecretly records your activity or keystrokes

The defences are just as testable. A firewall filters network traffic using rules. Encryption scrambles data so only the right key can read it. Two-factor authentication (password plus OTP, for example) means a stolen password alone is not enough. Antivirus software detects and removes malware. And the golden rule every bank repeats: never share your OTP, PIN or CVV with anyone, not even someone claiming to be from the bank.

8. Banking technology terms

SystemRun byKey features
NEFT (National Electronic Funds Transfer)RBISettles in half-hourly batches; no minimum amount; available 24x7 since December 2019
RTGS (Real Time Gross Settlement)RBIEach transfer settled individually and instantly; minimum ₹2 lakh; for high-value payments; 24x7 since December 2020
IMPS (Immediate Payment Service)NPCIInstant 24x7 transfer by mobile, net banking or ATM; limit ₹5 lakh per transaction
UPI (Unified Payments Interface)NPCILaunched 2016; pay using a virtual payment address (VPA) like name@bank or a QR code; works on top of IMPS rails
NACHNPCIBulk and recurring payments such as salary, EMIs and subsidies
AePSNPCIAadhaar Enabled Payment System: banking with Aadhaar number and fingerprint at a micro-ATM
CBS (Core Banking Solution)Each bankCentral system that lets you bank from any branch of your bank
CTS (Cheque Truncation System)NPCI / RBICheque image is sent electronically instead of moving the paper cheque
Classic trap: NEFT and RTGS are run by RBI, while IMPS, UPI, NACH, AePS and RuPay belong to NPCI. 'Gross' in RTGS means each transaction is settled one by one, not netted in batches like NEFT.

Quick check

What is the decimal value of the hexadecimal number 3C?

Last-minute revision

  • CPU = ALU + CU + registers; registers are the fastest memory
  • RAM and cache are volatile; ROM, HDD, SSD are non-volatile
  • 1 byte = 8 bits, 1 nibble = 4 bits, 1 KB = 1024 bytes
  • Group 4 bits for hex, 3 bits for octal
  • F7 = spell check (Word), F5 = slide show (PowerPoint), F2 = edit cell (Excel), F12 = Save As
  • Switch uses MAC address, router uses IP address; IPv4 = 32-bit, IPv6 = 128-bit
  • SMTP sends mail, POP3/IMAP receive it, DNS turns names into IP addresses
  • Primary key: unique and not null; DDL changes structure, DML changes data
  • Worm needs no host file; virus does; ransomware demands payment
  • NEFT and RTGS: RBI; IMPS, UPI, NACH, AePS: NPCI; RTGS minimum ₹2 lakh

Quick check

A customer wants to transfer ₹1,50,000 instantly at 11 pm on a Sunday. Which of these cannot be used for this amount?

Ready to test yourself?

Lock it in with the practice test for this chapter.

Take the practice test

Keep studying

See all Banking (IBPS / SBI) study material →