SSC CGL Tier II Computer Knowledge · Free notes
MS Office: SSC CGL Tier II Computer Knowledge
MS Office has 39 questions in the SSC CGL Tier II bank, 24 EASY and 15 MODERATE: 17 on Word, 17 on Excel and 5 on PowerPoint. Most ask for a keyboard shortcut, the tab or tool that does a job, or what an Excel function returns. The shortcuts are worth learning as a list; the rest make sense once you have used each program for a few minutes.
The handout has every subtopic, worked example, formula and trap with answers shown. The formula sheet is the chapter’s formulas and traps alone, on one page.
Subtopic notes
Formula & revision sheet
0 formulas · 3 reference tables · 3 gotchas across all subtopics — the exam-eve cheat-sheet
Formula & revision sheet
0 formulas · 3 reference tables · 3 gotchas across all subtopics — the exam-eve cheat-sheet
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
PYQ weightage by concept
3 concepts · 39 PYQs — where the marks actually sit, so you know what to drill first
PYQ weightage by concept
3 concepts · 39 PYQs — where the marks actually sit, so you know what to drill first
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.