Computer Literacy
What the section tests
Computer Literacy in KVS PRT covers basic hardware and software, memory and storage, operating-system tasks, word processing, spreadsheets, presentations, internet and email use, and safe digital practices. Questions are practical and definition-based.
Core concepts
- Hardware vs software: hardware is physical equipment; software is the set of instructions. The operating system manages both.
- Memory: RAM is volatile working memory; ROM is non-volatile. Storage units rise from bit to byte, KB, MB, GB and TB; 1 KB = 1024 bytes.
- MS Word: formatting, spell check, headers and footers, and shortcuts such as Ctrl+B for bold and Ctrl+Z for undo.
- MS Excel: cells are named by column and row, such as A1; formulas begin with = and functions such as SUM add ranges.
- Internet and email: a browser displays web pages; email needs a valid address, subject and message. HTTPS indicates encrypted transfer.
- Safety: use strong passwords, avoid unknown links and never share personal data casually.
Worked example
If A1 contains 10 and A2 contains 20, what does =SUM(A1:A2) return?
Reasoning: SUM adds all numeric values in the specified range. The range A1:A2 includes both cells, so the result is 10 + 20 = 30. If A3 were 5 and the formula were =SUM(A1:A3), the result would be 35.
Traps that cost marks
- Confusing RAM (temporary) with ROM (permanent).
- Treating 1 KB as 1000 bytes in binary-based storage questions; the standard value is 1024 bytes.
- Mixing Ctrl+Z (undo) with Ctrl+Y (redo).
- Thinking a formula and a function are the same; every formula starts with =, while SUM is a function used inside a formula.