PYQ Vault

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

Word questions ask for a shortcut, the place a setting lives (a tab or a dialog box), or what a feature is for. Most shortcuts are Ctrl plus a letter.

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 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
Practise this conceptself-check · 3 quick reps

The same idea in a real exam question:

SSC CGL Tier II · 2022 · Tier II (CGL 2022), 2 Mar 2023 · Q148Easy

Example 1 · MS Office · Word, Excel and PowerPoint

Which among the following keyboard shortcuts is used to insert a hyperlink for the selected text in Microsoft Word?

Using Ctrl + C for centre

Ctrl + C copies. Centre alignment is Ctrl + E (left is Ctrl + L, right is Ctrl + R, justify is Ctrl + J).

Concept 2 of 3: MS Excel

A cell is where a column and a row meet, named by column letter then row number (B7). Functions take a range and return one answer: SUM adds, COUNT counts numbers, COUNTIF counts the cells that meet a condition.

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

ABCD12345678B2B3B4B5B7=SUM(B2:B5)adds these 4 cellsB7: column B,then row 7The colon means "from B2 down to B5".
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
Practise this conceptself-check · 3 quick reps

The same idea in a real exam question:

SSC CGL Tier II · 2025 · Tier II (CGL 2025), 18 Jan 2026 · Q134Easy

Example 2 · MS Office · Word, Excel and PowerPoint

In Excel, which function would you use to count the number of cells in a range that meet a specific condition?

Confusing COUNT with COUNTIF

COUNT counts every cell that holds a number. COUNTIF counts only the cells that meet the condition you give, such as greater than 10.

Concept 3 of 3: MS PowerPoint

PowerPoint questions are about building a presentation: starting one, keeping its look consistent, and running the slide show.

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 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
Practise this conceptself-check · 3 quick reps

The same idea in a real exam question:

SSC CGL Tier II · 2024 · Tier II (CGL 2024), 20 Jan 2025 · Q144Easy

Example 3 · MS Office · Word, Excel and PowerPoint

How can you exit a slide show and return to editing mode in MS PowerPoint?

Thinking Esc closes PowerPoint

Esc only ends the slide show; the presentation stays open for editing.

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 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)

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.

Take the MS Office chapter test