I85PREP
⌘ K
South Indian Bank Clerk study materials
South Indian Bank Clerk study resources

South Indian Bank Clerk: Computer Aptitude and Knowledge: Memory, Office Tools and Number Systems

South Indian Bank Clerk · Work through your exam, one topic at a time.

All guide sections

Computer Aptitude and Knowledge: Memory, Office Tools and Number Systems

Computer Aptitude / Knowledge combines static computer awareness with a thin aptitude layer: hardware and memory, software and operating systems, MS Office shortcuts, networking and internet protocols, database basics, cyber security, and binary-to-decimal conversion. Most questions are single-fact recalls, so revise the exact values and abbreviations rather than general descriptions.

Hardware and memory

  • 1 byte = 8 bits; 1 KB = 1024 bytes, and MB, GB and TB each step up by 1024.
  • RAM is volatile; ROM is non-volatile and includes PROM, EPROM and EEPROM.
  • Registers sit inside the CPU, cache sits between the CPU and RAM - both are faster than RAM.
  • The ALU performs arithmetic and logic operations; the control unit directs the flow of instructions.
  • Generations: vacuum tubes, transistors, integrated circuits, microprocessors, then artificial intelligence.

Office tools, shortcuts and networking

  • Ctrl+C copy, Ctrl+V paste, Ctrl+X cut, Ctrl+Z undo, Ctrl+Y redo, Ctrl+F find.
  • In Excel, =SUM(A1:A10), =AVERAGE(A1:A10) and =IF(condition, value_if_true, value_if_false); a $ before a row or column makes the reference absolute.
  • SMTP sends mail; POP3 and IMAP retrieve it. HTTP/HTTPS is for the web, FTP for file transfer.
  • LAN is smaller than MAN, which is smaller than WAN. A router connects networks, a switch works inside a LAN, a hub broadcasts to every port.

Worked example

Convert 110101₂ to decimal. Read place values from the right: 1, 2, 4, 8, 16, 32. So (1×32) + (1×16) + (0×8) + (1×4) + (0×2) + (1×1) = 32 + 16 + 4 + 1 = 53. Going the other way, divide repeatedly by 2 and read the remainders from the bottom upwards.

Cyber security

A firewall filters incoming and outgoing traffic. Phishing is a fraudulent message that harvests credentials; viruses attach to files, worms self-replicate across networks, and trojans disguise themselves as legitimate software.

Traps that cost marks

Using 1000 instead of 1024 for KB; confusing Ctrl+Z with Ctrl+Y; assuming SMTP also receives mail; writing a relative reference where an absolute one is needed.