Introduction
Microsoft Office is the most widely used productivity suite, and SSC exams test its three core
applications — Word (documents), Excel (spreadsheets), and PowerPoint (presentations) — through direct
feature and shortcut-key questions.
MS Word — Key Features
| Feature | Purpose |
|---|
| Mail Merge | Creates personalised copies of a document (e.g., letters) using a data source |
| Track Changes | Records edits made by different reviewers for collaborative editing |
| Spell Check / Grammar Check | Automatically flags spelling and grammar errors |
| Header/Footer | Repeated content at the top/bottom of every page |
| Table of Contents | Auto-generated navigation list based on document headings |
MS Word — Important Shortcuts
| Shortcut | Function |
|---|
| Ctrl + B / I / U | Bold / Italic / Underline |
| Ctrl + S | Save |
| Ctrl + Z / Y | Undo / Redo |
| Ctrl + P | Print |
| Ctrl + F | Find |
| Ctrl + H | Replace |
| Ctrl + A | Select All |
MS Excel — Key Concepts
| Term | Meaning |
|---|
| Cell | Intersection of a row and column, identified by an address (e.g., A1) |
| Worksheet | A single spreadsheet page (grid of cells) |
| Workbook | The full Excel file, which can contain multiple worksheets |
| Formula Bar | Displays and allows editing of the formula/content in the selected cell |
MS Excel — Common Formulas
| Formula | Function |
|---|
| =SUM(range) | Adds all values in the specified range |
| =AVERAGE(range) | Calculates the average of values in the range |
| =COUNT(range) | Counts the number of cells containing numbers |
| =MAX(range) / =MIN(range) | Finds the highest/lowest value in the range |
| =IF(condition, value_if_true, value_if_false) | Returns one value if a condition is true, another if false |
| =VLOOKUP(value, table, col_index) | Searches for a value in the first column of a table and returns a value from a specified column in the same row |
📌 Note: Every Excel formula begins with an equals sign (=) — without it, Excel treats the entry as plain text, not a calculation.
MS Excel — Important Shortcuts
| Shortcut | Function |
|---|
| Ctrl + Arrow Key | Jump to the edge of the current data region |
| F2 | Edit the selected cell |
| Ctrl + ; | Insert the current date |
| Alt + = | Auto-sum the selected range |
MS PowerPoint — Key Concepts
| Term | Meaning |
|---|
| Slide | A single page/screen of a presentation |
| Slide Master | Controls the overall design/layout applied to all slides |
| Slide Transition | The visual effect when moving from one slide to the next |
| Animation | Movement effect applied to individual objects within a slide |
| Slide Show | Full-screen presentation mode (started with F5) |
| Shortcut | Function |
|---|
| F5 | Start the slide show from the beginning |
| Shift + F5 | Start the slide show from the current slide |
| Esc | Exit the slide show |
✅ UPSC/SSC Focus: MS Word features (mail merge, track changes) and shortcuts · Cell/Worksheet/Workbook hierarchy in Excel · Common Excel formulas (SUM, IF, VLOOKUP) · Slide Master vs individual slide transitions/animations in PowerPoint.