Computer Awareness and Office Applications
Domain 7 tests basic computer literacy and practical use of MS Word, Excel, PowerPoint, internet and email. Questions are usually definitional or shortcut-based.
Hardware, software and memory
- CPU processes instructions; RAM is volatile working memory; ROM is non-volatile firmware storage.
- Units: 1 KB = 1024 bytes; 1 MB = 1024 KB; 1 GB = 1024 MB.
- System software includes the operating system; application software includes Word and Excel.
- Common shortcuts: Ctrl+C copy, Ctrl+V paste, Ctrl+X cut, Ctrl+Z undo, Ctrl+S save, Ctrl+P print.
Office applications
- Word: formatting, headers/footers, mail merge, spell check.
- Excel: a cell reference like B4; formulas start with "="; SUM adds a range; absolute reference $A$1 stays fixed when copied.
- PowerPoint: F5 starts the slide show; Esc exits.
- Email: To, Cc (visible copy), Bcc (hidden copy); attachments have size limits.
Worked example
In Excel, cell B2 contains 10 and B6 contains 20. =SUM(B2:B6) adds every numeric cell from B2 through B6, including B3–B5; =B2+B6 adds only the two endpoints. If B3=5, B4=5, B5=5, the first formula returns 45, the second returns 30. This is why range and endpoint formulas are not interchangeable.
Traps
Calling RAM non-volatile; confusing Cc with Bcc; forgetting the "=" sign so Excel treats the entry as text; and mixing relative references with absolute references when a formula is copied.