I85PREP
⌘ K
MP Patwari study materials
MP Patwari study resources

MP Patwari: Computer Knowledge - Fundamentals, MS Office, Internet and e-Governance

MP Patwari · Work through your exam, one topic at a time.

All guide sections

Computer Knowledge - Fundamentals, MS Office, Internet and e-Governance

Scope

The computer section is factual and practical: hardware and software basics, operating system tasks, MS Word/Excel/PowerPoint, internet terms, and Madhya Pradesh's e-governance platforms that a patwari uses daily.

Fundamentals

  • Input devices: keyboard, mouse, scanner; output: monitor, printer; CPU is the processing unit; RAM is volatile, ROM non-volatile.
  • 1 byte = 8 bits; 1 KB = 1024 bytes; 1 MB = 1024 KB.
  • Software types: system (operating system) and application (MS Office, browsers).
  • Shortcuts: Ctrl+C copy, Ctrl+V paste, Ctrl+X cut, Ctrl+Z undo, Ctrl+S save, Ctrl+P print, Alt+Tab switch windows.

MS Office

  • Excel: every formula begins with '='; =SUM(A1:A5) adds the range; cell references can be relative (A1) or absolute ($A$1).
  • Word: Ctrl+B bold, Ctrl+E centre; mail merge combines a document with a data list.
  • PowerPoint: F5 starts the slideshow.

Internet and e-governance

URL, HTTP/HTTPS, browser, search engine and email are standard terms. Locally, know MPOnline for citizen services and forms, Lok Seva Kendras, the Samagra ID used for family-based beneficiary identification, e-District portals, Bhulekh for land records, and DigiLocker for digital documents.

Worked example

Cells A1 to A5 hold 10, 20, 30, 40, 50. The formula =SUM(A1:A5) returns 150. If copied to B6, the relative reference shifts to =SUM(B1:B5); writing $A$1:$A$5 would keep it fixed.

Traps

Saying RAM stores data permanently; writing formulas without '='; confusing the Samagra ID with Aadhaar; assuming a browser and a search engine are the same thing.