Computer Awareness and Office Procedures
What this domain tests
This section tests computer hardware and software, operating systems, MS Word, Excel and PowerPoint, internet and email, cyber safety, e-governance, and office procedures such as noting, drafting, file movement and record keeping.
Core concepts
- Hardware is physical; software is a set of instructions. RAM is volatile; ROM is non-volatile.
- In Excel, a relative reference changes when copied; an absolute reference uses dollar signs.
- CC sends a copy to recipients; BCC hides recipient addresses from others.
- A note is an internal observation on a file; a draft is the fair communication prepared for signature.
- Cyber safety includes strong passwords, avoiding unknown links and verifying official domains.
Worked example
In a spreadsheet, =SUM(A1:A5) adds all cells from A1 to A5, while =SUM(A1,A5) adds only A1 and A5. Reasoning: the colon denotes a range; the comma separates individual arguments. If the formula is copied, relative references adjust unless dollar signs are used.
Traps that cost marks
Do not confuse Save with Save As; Save As creates a new file or format. Do not put sensitive recipients in CC when BCC is intended. In office procedure, do not treat a draft as the final approved order.