SSC CGL Tier II Computer Knowledge · MS Office
Word, Excel and PowerPoint
Keyboard shortcuts, tabs and tools in MS Word, what Excel's functions return, and the basics of building a PowerPoint presentation.
Why this matters
39 questions in the Tier II bank, 24 EASY and 15 MODERATE. Keyboard shortcuts alone account for 10 of them, and SSC names a version (2010, 365) that rarely changes the answer.
Concept 1 of 3: MS Word
Definition
Key facts:
- Styles give headings and titles a consistent look; direct formatting changes only the selected text.
- Section break (next page) lets the new section have its own orientation and margins.
- Page Setup is under the Layout tab.
- Quick Access Toolbar shows Save, Undo and Redo by default.
- Shading colours the background behind the selected text.
| Task in Word | Shortcut or tool | Asked in |
|---|---|---|
| Insert a hyperlink | Ctrl + K | 2022 |
| Centre-align text | Ctrl + E | 2022 |
| Close the document window | Alt + F4 | 2022 |
| Add bullets (Word 2010) | Ctrl + Shift + L | 2024 |
| Increase indent | Ctrl + M | 2024 |
| Print only some pages | Custom Print | 2022 |
| See the page as printed | Print Preview | 2023 |
| Consistent headings | Styles | 2024 |
| Change one heading only | Direct formatting | 2025 |
Practise this conceptself-check · 3 quick reps
The same idea in a real exam question:
Example 1 · MS Office · Word, Excel and PowerPoint
Using Ctrl + C for centre
Concept 2 of 3: MS Excel
Definition
Key facts:
- Cell reference: column letter then row number (A10).
- Ribbon: the strip of tabs and commands below the title bar.
- MATCH(value, array, 1) gives the position of the largest value not more than the one sought.
- Filter hides rows that do not meet a condition without deleting them.
- Inserting a row shifts the rows below it down.
Diagram · column letter, then row number
| Task in Excel | Shortcut or function | Asked in |
|---|---|---|
| New blank workbook | Ctrl + N | 2022 |
| Select the whole row | Shift + Spacebar | 2022 |
| Adjust column width | Alt + H + O + W | 2024 |
| Line break inside a cell | Alt + Enter | 2025 |
| Add a range | SUM | 2023 |
| Count cells with numbers | COUNT | 2024 |
| Count cells meeting a condition | COUNTIF | 2025 |
| Show only rows above a mark | Filter | 2025 |
| A math function | ABS | 2022 |
| Column width limit (Excel 2003) | 255 characters | 2024 |
Practise this conceptself-check · 3 quick reps
The same idea in a real exam question:
Example 2 · MS Office · Word, Excel and PowerPoint
Confusing COUNT with COUNTIF
Concept 3 of 3: MS PowerPoint
Definition
Key facts:
- Templates keep a presentation's design consistent.
- Placeholders keep text in place when content changes; loose text boxes drift.
- Esc ends a slide show and returns to editing.
- New blank presentation: File, New, Blank Presentation.
| Task in PowerPoint | How | Asked in |
|---|---|---|
| Leave the slide show | Press Esc | 2024 |
| Start a blank presentation | File, New, Blank Presentation | 2024 |
| Keep a consistent design | Use a template | 2024 |
| Reorganise content | Insert and delete slides | 2024 |
| Stop text boxes moving | Use placeholders | 2025 |
Practise this conceptself-check · 3 quick reps
The same idea in a real exam question:
Example 3 · MS Office · Word, Excel and PowerPoint
Thinking Esc closes PowerPoint
Summary — formulas & gotchas at a glance
A revision cheat-sheet for the formulas and gotchas above. Click any concept name to jump back to its full explanation.
Reference tables (3)
MS Word9 rows
| Task in Word | Shortcut or tool | Asked in |
|---|---|---|
| Insert a hyperlink | Ctrl + K | 2022 |
| Centre-align text | Ctrl + E | 2022 |
| Close the document window | Alt + F4 | 2022 |
| Add bullets (Word 2010) | Ctrl + Shift + L | 2024 |
| Increase indent | Ctrl + M | 2024 |
| Print only some pages | Custom Print | 2022 |
| See the page as printed | Print Preview | 2023 |
| Consistent headings | Styles | 2024 |
| Change one heading only | Direct formatting | 2025 |
MS Excel10 rows
| Task in Excel | Shortcut or function | Asked in |
|---|---|---|
| New blank workbook | Ctrl + N | 2022 |
| Select the whole row | Shift + Spacebar | 2022 |
| Adjust column width | Alt + H + O + W | 2024 |
| Line break inside a cell | Alt + Enter | 2025 |
| Add a range | SUM | 2023 |
| Count cells with numbers | COUNT | 2024 |
| Count cells meeting a condition | COUNTIF | 2025 |
| Show only rows above a mark | Filter | 2025 |
| A math function | ABS | 2022 |
| Column width limit (Excel 2003) | 255 characters | 2024 |
MS PowerPoint5 rows
| Task in PowerPoint | How | Asked in |
|---|---|---|
| Leave the slide show | Press Esc | 2024 |
| Start a blank presentation | File, New, Blank Presentation | 2024 |
| Keep a consistent design | Use a template | 2024 |
| Reorganise content | Insert and delete slides | 2024 |
| Stop text boxes moving | Use placeholders | 2025 |
Watch out for (3)
- Using Ctrl + C for centre→ MS Word
- Confusing COUNT with COUNTIF→ MS Excel
- Thinking Esc closes PowerPoint→ MS PowerPoint
Test yourself on MS Office
15 past SSC CGL Tier II questions from this chapter, timed at 12 minutes and marked the way the exam marks it. You see your score and every answer the moment you finish. Free to start.