Computer Knowledge and Office Application Skills
What this domain tests
Computer Knowledge and Office Application Skills is a scoring section for anyone who uses a PC daily. It covers computer generations and hardware, memory and storage units, operating-system basics, word processing, spreadsheets, presentations, internet and email, networking, databases and basic cyber-security - often framed around tasks an SSO performs, such as maintaining insured-person data, preparing compliance reports and mail-merging letters.
Rules to keep ready
- Generations: vacuum tubes (1st), transistors (2nd), integrated circuits (3rd), microprocessors (4th), artificial intelligence (5th).
- Memory: 1 byte = 8 bits; 1024 bytes = 1 KB. RAM is volatile and holds running programs; ROM is non-volatile and holds firmware.
- Word: Ctrl+N new, Ctrl+S save, Ctrl+P print, Ctrl+F find, Ctrl+H replace, Ctrl+Z undo, Ctrl+Y redo.
- Excel: every formula starts with '='; $A$1 is absolute, A1 relative; F2 edits a cell in place; Alt+= inserts AutoSum.
- PowerPoint: F5 starts the show from the beginning, Shift+F5 from the current slide.
- Security: phishing is a fraudulent message that harvests credentials; a firewall filters traffic; antivirus software detects malware.
Worked example
Cells A1 = 10, A2 = 20, A3 is empty, A4 = 0. What does =AVERAGE(A1:A4) return? AVERAGE ignores a genuinely empty cell (A3) but counts a stored zero (A4), so it divides the sum 30 by the three counted cells: 10. If A4 held text rather than 0, the result would be 15. The blank/zero/text distinction is a favourite question.
Traps
Claiming RAM is permanent storage; swapping Ctrl+Z and Ctrl+Y; confusing Save with Save As; assuming copied formatting pastes identically into Excel; and forgetting that email Cc is visible to every recipient while Bcc is not - a confidentiality point in ESIC offices.