Computer Knowledge (MS Office, Spreadsheets, E-Governance)
Computer Knowledge tests practical MS Office use, spreadsheet formulas, internet and e-governance terminology. The exam favours commands, shortcuts and precise formula behaviour over theory.
MS Office essentials
- Word: Ctrl+S save, Ctrl+P print, Ctrl+Z undo, Ctrl+F find; styles, mail merge and track changes are common topics.
- Excel: every formula begins with '='; SUM, AVERAGE, COUNT, COUNTA, IF and VLOOKUP are frequently tested. Relative references change on copy; absolute references like $A$1 do not.
- PowerPoint: the slide master controls global formatting; F5 starts the slide show.
- File types: .docx, .xlsx, .pptx; CSV stores comma-separated values.
E-governance basics
- DigiLocker stores verified digital documents; UMANG aggregates citizen services.
- PFMS tracks government payments and DBT transfers; GeM is the government e-marketplace.
- e-Office supports file movement; Bharat Kosh handles non-tax receipts.
Worked example
In Excel, to total column B only where column C says J&K: =SUMIF(C2:C10,"J&K",B2:B10) The first range is tested against the criterion; the third range supplies the values to add. Both ranges must be the same size.
Traps
- Typing text without an equals sign, so Excel treats it as a label.
- Confusing COUNT (numbers) with COUNTA (non-empty cells).
- Copying a formula without locking the lookup range.
- Confusing cc (visible copy) with bcc (hidden copy).
- Assuming every deleted file goes to the Recycle Bin.