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 Kaustav Basak (19 years teaching)Written with AI helpReport a mistake
9 min read · Published 3 November 2026
Part of Banking (IBPS / SBI) prepYour 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.
| Category | Examples | Bank-exam favourite |
|---|---|---|
| Input devices | Keyboard, mouse, scanner, microphone, webcam | MICR reader (reads cheque numbers), OMR, OCR, barcode reader |
| Output devices | Monitor, printer, speaker, projector | Plotter (large drawings), dot-matrix printer (impact printer) |
| Both input and output | Touchscreen, modem, headset with mic | Touchscreen at ATMs and kiosks |
| Translators | Compiler, interpreter, assembler | Compiler converts the whole program at once; interpreter goes line by line |
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.
| Memory | Volatile? | Key fact |
|---|---|---|
| Registers | Yes | Fastest memory, inside the CPU |
| Cache | Yes | Sits between CPU and RAM; holds frequently used data |
| RAM | Yes | Working memory; contents lost when power goes off. Types: SRAM (used in cache), DRAM (main memory) |
| ROM | No | Holds startup instructions (BIOS/firmware). Types: PROM, EPROM (erased by UV light), EEPROM (erased electrically) |
| HDD / SSD | No | Secondary storage; SSD has no moving parts, so it is faster than HDD |
3. Number systems: binary, octal, decimal, hex
| System | Base | Digits used |
|---|---|---|
| Binary | 2 | 0, 1 |
| Octal | 8 | 0 to 7 |
| Decimal | 10 | 0 to 9 |
| Hexadecimal | 16 | 0 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)
- 1Divide the number by 2 and write down the remainder (0 or 1).
- 2Keep dividing the quotient by 2 until the quotient becomes 0.
- 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
| Shortcut | Action | Where |
|---|---|---|
| Ctrl + C / Ctrl + X / Ctrl + V | Copy / Cut / Paste | All Office apps |
| Ctrl + Z / Ctrl + Y | Undo / Redo | All Office apps |
| Ctrl + B / Ctrl + I / Ctrl + U | Bold / Italic / Underline | All Office apps |
| Ctrl + S / F12 | Save / Save As | All Office apps |
| Ctrl + P / Ctrl + N | Print / New document | All Office apps |
| Ctrl + F / Ctrl + H | Find / Replace | Word, Excel |
| Ctrl + K | Insert hyperlink | Word, Excel, PowerPoint |
| F7 | Spelling and grammar check | Word |
| Ctrl + E / Ctrl + L / Ctrl + R / Ctrl + J | Centre / Left / Right / Justify alignment | Word |
| F2 | Edit the active cell | Excel |
| Ctrl + ; | Insert today's date | Excel |
| F5 / Shift + F5 | Slide show from beginning / from current slide | PowerPoint |
| Alt + F4 | Close the active window or program | Windows |
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.
| Term | What it means |
|---|---|
| Hub / Switch / Router | Hub sends data to all ports; switch sends only to the right device using MAC addresses; router connects different networks using IP addresses |
| IP address | Logical address of a device. IPv4 is 32-bit, IPv6 is 128-bit |
| MAC address | Physical, 48-bit hardware address burnt into the network card |
| DNS | Converts a domain name like example.com into an IP address (the internet's phone book) |
| HTTP / HTTPS | Web page transfer; HTTPS adds encryption (SSL/TLS) and is used by net banking |
| SMTP / POP3 / IMAP | SMTP sends email; POP3 and IMAP receive email |
| FTP | File Transfer Protocol, for moving files between computers |
| URL | Full web address, e.g. https://www.example.com/page |
| OSI model | 7 layers: 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 group | Commands | Purpose |
|---|---|---|
| DDL (Data Definition Language) | CREATE, ALTER, DROP, TRUNCATE | Define or change the structure of tables |
| DML (Data Manipulation Language) | SELECT, INSERT, UPDATE, DELETE | Work with the data inside tables |
| DCL (Data Control Language) | GRANT, REVOKE | Give or take back access rights |
| TCL (Transaction Control Language) | COMMIT, ROLLBACK, SAVEPOINT | Confirm or undo a transaction |
7. Cyber security
| Threat | How it works |
|---|---|
| Phishing | Fake email or website that tricks you into giving passwords or card details |
| Vishing / Smishing | Phishing over a voice call / over SMS |
| Virus | Malicious code that attaches to a file and spreads when that file runs |
| Worm | Spreads on its own across networks without needing a host file |
| Trojan horse | Looks like useful software but opens a hidden backdoor |
| Ransomware | Encrypts your files and demands payment to unlock them |
| Spyware / Keylogger | Secretly 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
| System | Run by | Key features |
|---|---|---|
| NEFT (National Electronic Funds Transfer) | RBI | Settles in half-hourly batches; no minimum amount; available 24x7 since December 2019 |
| RTGS (Real Time Gross Settlement) | RBI | Each transfer settled individually and instantly; minimum ₹2 lakh; for high-value payments; 24x7 since December 2020 |
| IMPS (Immediate Payment Service) | NPCI | Instant 24x7 transfer by mobile, net banking or ATM; limit ₹5 lakh per transaction |
| UPI (Unified Payments Interface) | NPCI | Launched 2016; pay using a virtual payment address (VPA) like name@bank or a QR code; works on top of IMPS rails |
| NACH | NPCI | Bulk and recurring payments such as salary, EMIs and subsidies |
| AePS | NPCI | Aadhaar Enabled Payment System: banking with Aadhaar number and fingerprint at a micro-ATM |
| CBS (Core Banking Solution) | Each bank | Central system that lets you bank from any branch of your bank |
| CTS (Cheque Truncation System) | NPCI / RBI | Cheque image is sent electronically instead of moving the paper cheque |
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?
Keep studying
8 min read
Puzzles & Seating Arrangement: Build a Grid, Eliminate Cases
7 min read
Syllogism & Inequality: Your Easiest Guaranteed Marks in Bank Prelims
8 min read
Coding-Decoding & Blood Relations: Crack the Code, Draw the Tree
8 min read
Bank PO Mains Reasoning: Data Sufficiency, Input-Output & Critical Reasoning Made Simple