PYQ Vault

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

Word, Excel and PowerPoint

Reference tables (3)

MS Word9 rows
Task in WordShortcut or toolAsked in
Insert a hyperlinkCtrl + K2022
Centre-align textCtrl + E2022
Close the document windowAlt + F42022
Add bullets (Word 2010)Ctrl + Shift + L2024
Increase indentCtrl + M2024
Print only some pagesCustom Print2022
See the page as printedPrint Preview2023
Consistent headingsStyles2024
Change one heading onlyDirect formatting2025
MS Excel10 rows
Task in ExcelShortcut or functionAsked in
New blank workbookCtrl + N2022
Select the whole rowShift + Spacebar2022
Adjust column widthAlt + H + O + W2024
Line break inside a cellAlt + Enter2025
Add a rangeSUM2023
Count cells with numbersCOUNT2024
Count cells meeting a conditionCOUNTIF2025
Show only rows above a markFilter2025
A math functionABS2022
Column width limit (Excel 2003)255 characters2024
MS PowerPoint5 rows
Task in PowerPointHowAsked in
Leave the slide showPress Esc2024
Start a blank presentationFile, New, Blank Presentation2024
Keep a consistent designUse a template2024
Reorganise contentInsert and delete slides2024
Stop text boxes movingUse placeholders2025

Watch out for (3)

PYQ weightage by concept

3 concepts · 39 PYQs — where the marks actually sit, so you know what to drill first

Word, Excel and PowerPoint39 PYQs · 100%
ConceptPYQsShare
MS Word1744%
MS Excel1744%
MS PowerPoint513%

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.