Computer Knowledge / Computer Awareness
Computer Awareness tests everyday computing, office software, networking, and the digital channels a bank branch uses.
Core rules
- Memory: 1 byte = 8 bits; 1 KB = 1024 bytes; 1 MB = 1024 KB; 1 GB = 1024 MB. RAM is volatile primary memory; hard disks and SSDs are secondary storage.
- Input devices include keyboard, mouse, scanner, and microphone; output devices include monitor, printer, and speaker. A modem converts digital signals to analog and back.
- Shortcuts: Ctrl+C copy, Ctrl+X cut, Ctrl+V paste, Ctrl+Z undo, Ctrl+S save, Ctrl+F find.
- An operating system manages hardware and software; Windows, Linux, and macOS are examples. Common file types are .docx, .xlsx, .pptx, and .pdf.
- Networking: LAN is local, WAN spans larger areas; HTTP and HTTPS are web protocols, with the s indicating encryption.
- Banking IT: CBS connects branches; NEFT, RTGS, and IMPS transfer funds electronically; CTS handles cheque truncation.
Worked example
Cell C5 contains =B5*$D$1. Copy it to C6. The relative reference B5 shifts down one row to B6, but the absolute reference $D$1 stays fixed, so C6 shows =B6*$D$1.
Traps
Confusing RAM with ROM; calling software hardware; swapping Ctrl+X and Ctrl+C; and assuming HTTPS only means a faster site rather than a secure connection.