PPSC Computer Science Notes (Sub Inspector
Preparation)
MS Word (Detailed Theory + MCQs)
• Ribbon Tabs: Home, Insert, Page Layout, References, Review, View.
• Formatting: Bold, Italic, Underline, Font Style, Paragraph Alignment.
• Insert Tab: Tables, Pictures, Header & Footer, Page Numbers.
• Page Layout: Margins, Orientation, Columns.
• Review Tab: Spell Check (F7), Thesaurus (Shift+F7), Track Changes.
• File Extensions: .doc, .docx, .dotx, .docm
• Important Shortcuts: Ctrl+S (Save), Ctrl+P (Print), Ctrl+Z (Undo), Ctrl+Y (Redo), Ctrl+F (Find).
MS Excel (Detailed Theory + MCQs)
• Workbook vs Worksheet: Workbook is full file, Worksheet is single sheet.
• Cells: Identified by row+column (e.g., A1).
• Important Functions: SUM, AVERAGE, MAX, MIN, COUNT, IF, VLOOKUP, HLOOKUP, LEN,
NOW, TODAY.
• Charts: Pie, Line, Column, Bar.
• Data Tools: Sorting, Filtering, Data Validation.
• File Extensions: .xls, .xlsx, .xlsm
• Important Shortcuts: Ctrl+N (New), Ctrl+O (Open), Ctrl+S (Save), F2 (Edit Cell).
MS PowerPoint (Detailed Theory + MCQs)
• Slides & Layouts: Title Slide, Title & Content, Two Content, Blank.
• Views: Normal, Slide Sorter, Reading View, Slide Show.
• Designing: Themes, Slide Master, Backgrounds.
• Transitions: Effects between slides.
• Animations: Effects on objects (text, images).
• File Extensions: .ppt, .pptx, .ppsx, .pptm
• Important Shortcuts: Ctrl+M (New Slide), F5 (Start Slide Show), Esc (Exit).
Computer Basics & IT Knowledge
• Hardware vs Software.
• Memory Types: RAM (Volatile), ROM (Non-Volatile), Cache, Virtual Memory.
• Storage Units: KB, MB, GB, TB.
• CPU Components: ALU, CU, Registers.
• Input/Output Devices: Keyboard, Mouse, Monitor, Printer.
• Networking: LAN, WAN, IP Address, Wi-Fi.
• Internet: WWW, HTTP, Email (CC/BCC, Attachments).
Practice MCQs (Sample)
• Q1. Shortcut for Copy in MS Word? (Ctrl+C)
• Q2. Extension of Excel 2007 file? (.xlsx)
• Q3. Function to find largest value in Excel? (MAX)
• Q4. Shortcut for New Slide in PowerPoint? (Ctrl+M)
• Q5. RAM is: Volatile Memory
Quick Revision Sheets
• MS Word Shortcuts: Ctrl+S, Ctrl+P, Ctrl+Z, Ctrl+Y, Ctrl+F.
• MS Excel Formulas: SUM, AVERAGE, MAX, MIN, COUNT.
• PowerPoint Shortcuts: Ctrl+M, F5, Esc.
• IT Basics: 1 KB = 1024 Bytes, LAN = Local Area Network.