I85PREP
⌘ K
Lok Sewa Kharidar study materials
Lok Sewa Kharidar study resources

Lok Sewa Kharidar: Office Management and Computer Skills: Daily Office Work and MS Office

Lok Sewa Kharidar · Work through your exam, one topic at a time.

All guide sections

Office Management and Computer Skills: Daily Office Work and MS Office

This section tests everyday office work - correspondence, records, filing and procurement basics - together with practical computer literacy in Windows, MS Office, email and the internet.

Office management essentials

  • Core functions: receiving and dispatching mail, registry and recording, filing, indexing, forms and stationery control, and office layout.
  • Filing methods: chronological, alphabetical, numerical and subject-based, plus digital record management with retention and disposal schedules.
  • Correspondence types: official letter (external), memo (internal), circular (same message to many recipients), notice and press release. Every official letter carries a file number, date, subject, reference, signature and designation.
  • Procurement under the Public Procurement Act 2063 uses sealed quotation, national or international competitive bidding, and user committees within prescribed thresholds.
  • Digital governance: Nagarik App and online tax, passport and company-registration services.

Computer skills

  • Hardware versus software; the input-processing-output-storage cycle; RAM is volatile, ROM is permanent; storage units run KB, MB, GB, TB.
  • Windows: files, folders, file extensions, Save versus Save As, and shortcuts such as Ctrl+C, Ctrl+V, Ctrl+X, Ctrl+Z and Ctrl+P.
  • Word: formatting, tables, headers and footers, mail merge. Excel: formulas begin with =, functions such as SUM, AVERAGE, COUNT and IF. Email: To, Cc, Bcc and attachments.

Worked example

In Excel, A1 contains 10 and A2 contains 20. What does =AVERAGE(A1:A2) return? Reasoning: the colon denotes a range from A1 to A2, so Excel averages 10 and 20 and returns 15. If that formula is copied to B1, the range shifts to B1:B2 because cell references are relative; use $A$1:$A$2 to lock it.

Traps that cost marks

  • Using Save when a new copy is needed, overwriting the original file.
  • Confusing Cc (visible copy) with Bcc (hidden copy).
  • Sending an internal memo where a circular to many offices is required.