MS Office — Study Notes
MPESB Group 1/2/3 | Computer Knowledge
Overview
MS Office (Microsoft Office) is a productivity suite widely used in government offices, businesses, and education. For MPESB exams, questions focus on practical knowledge — identifying toolbar functions, keyboard shortcuts, file extensions, and basic operations in Word, Excel, PowerPoint, and Access.
Questions are straightforward but require familiarity with interface elements, default settings, and common operations. Students who have hands-on experience score easily; those relying only on theory often confuse similar-sounding features.
Master the file extensions, key shortcuts, toolbar icons, and basic terminology for each application. Know the difference between similar functions (like Save vs Save As, or Cut vs Copy).
Key Concepts
- MS Word is a word processor for creating documents — letters, reports, resumes. Default extension is .docx (older format: .doc).
- MS Excel is a spreadsheet application for calculations, data analysis, and charts. Files are stored as .xlsx workbooks containing multiple worksheets.
- MS PowerPoint creates presentations with slides containing text, images, animations, and transitions. Default extension is .pptx.
- MS Access is a database management system (DBMS) for storing and querying structured data. Uses .accdb format and works with tables, queries, forms, and reports.
- Ribbon Interface — All modern MS Office apps use a ribbon (introduced in Office 2007) with tabs (Home, Insert, View, etc.) containing grouped commands.
- Quick Access Toolbar — Small customizable toolbar above the ribbon for frequently used commands like Save, Undo, Redo.
- Office Button / File Tab — Contains file operations: New, Open, Save, Save As, Print, Close, Exit.
- Clipboard operations — Cut (Ctrl+X), Copy (Ctrl+C), Paste (Ctrl+V) work uniformly across all Office applications.
Formulas / Key Facts
File Extensions (Very Important)
| Application | Default Extension | Older Format |
|---|---|---|
| MS Word | .docx | .doc |
| MS Excel | .xlsx | .xls |
| MS PowerPoint | .pptx | .ppt |
| MS Access | .accdb | .mdb |
Essential Keyboard Shortcuts
| Shortcut | Function |
|---|---|
| Ctrl + N | New document/workbook/presentation |
| Ctrl + O | Open existing file |
| Ctrl + S | Save |
| Ctrl + P | |
| Ctrl + Z | Undo |
| Ctrl + Y | Redo |
| Ctrl + A | Select All |
| Ctrl + F | Find |
| Ctrl + H | Find and Replace |
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
| F5 | Start slideshow (PowerPoint) |
| F7 | Spelling and Grammar check |
| Ctrl + Home | Go to beginning of document |
| Ctrl + End | Go to end of document |
MS Word Specific Facts
- Default font: Calibri (11 pt) in Word 2007–2021; Aptos in current Microsoft 365
- Page orientation: Portrait (default) or Landscape
- Mail Merge creates personalized letters using data source
- Header appears at top of every page; Footer at bottom
- Page Break: Ctrl + Enter
MS Excel Specific Facts
- Cell address = Column letter + Row number (e.g., A1, B5, Z100)
- Workbook contains multiple Worksheets (default: 1 sheet in newer versions)
- Formula always starts with = sign (e.g., =A1+B1)
- Basic functions: SUM, AVERAGE, MAX, MIN, COUNT, IF
- Cell reference types: Relative (A1), Absolute ($A$1), Mixed (A$1 or $A1)
- AutoFill: Drag cell corner to copy or extend series
- Rows: numbered 1, 2, 3... | Columns: lettered A, B, C...
MS PowerPoint Specific Facts
- Slide = single page of presentation
- Slide Master controls uniform formatting across all slides
- Transition = effect when moving between slides
- Animation = effect on objects within a slide
- Normal View for editing; Slide Sorter for rearranging; Slideshow for presenting
- First slide typically uses Title Slide layout
MS Access Specific Facts
- Table stores data in rows (records) and columns (fields)
- Query retrieves specific data using criteria
- Form provides user-friendly interface for data entry
- Report generates formatted printable output
- Primary Key uniquely identifies each record
- Relationship links tables (One-to-One, One-to-Many, Many-to-Many)
Worked Examples
Example 1: In MS Excel, what will be the result of formula =SUM(A1:A3) if A1=10, A2=20, A3=30?
Solution:
- SUM function adds all values in the specified range
- A1:A3 means cells A1, A2, and A3
- Result = 10 + 20 + 30 = 60
Example 2: Which shortcut key is used to start a slideshow from the beginning in MS PowerPoint?
Solution:
- F5 starts slideshow from first slide
- Shift + F5 starts from current slide
- Answer: F5
Example 3: What is the default file extension of MS Word 2016?
Solution:
- Word 2007 onwards uses .docx format (XML-based)
- Older Word 97-2003 used .doc
- Answer: .docx
Common Mistakes
❌ Confusing Cut and Copy — Cut removes original (Ctrl+X); Copy keeps original (Ctrl+C). Fix: Cut = "move", Copy = "duplicate".
❌ Thinking .doc and .docx are same — They are different formats. Older Office versions cannot open .docx without compatibility pack. Remember: "x" stands for XML format introduced in Office 2007.
❌ Mixing up Transition and Animation in PowerPoint — Transition is between slides; Animation is within a slide on specific objects. Think: Transition = travel between slides.
❌ Forgetting = sign in Excel formulas — Writing SUM(A1:A5) without = shows it as text, not calculation. Every formula must begin with =.
❌ Confusing Workbook and Worksheet — Workbook is the entire Excel file; Worksheet is one sheet within it. One workbook can contain multiple worksheets.
❌ Access confusion: Table vs Query — Table stores raw data; Query extracts filtered data from tables. Query does not store data permanently.
Quick Reference
📌 Word = .docx | Excel = .xlsx | PowerPoint = .pptx | Access = .accdb
📌 Ctrl+S = Save | Ctrl+P = Print | Ctrl+Z = Undo | Ctrl+Y = Redo
📌 Excel formula always starts with = sign
📌 F5 = Start PowerPoint slideshow | F7 = Spell check
📌 Access: Table (data) → Query (filter) → Form (entry) → Report (print)
📌 Mail Merge in Word creates personalized bulk letters