MS Office for SSC: Word, Excel and PowerPoint Made Easy
A friendly, exam-ready guide to the MS Office questions in SSC CGL and CHSL: the shortcuts you must know, Word features, Excel formulas, functions, errors and cell references, and PowerPoint views and effects, with worked examples and quick checks.
Reviewed by Kaustav Basak (19 years teaching)Written with AI helpReport a mistake
9 min read · Published 2 November 2026
Part of SSC CGL prepThe office stationery cupboard
Think of MS Office as the stationery cupboard in a government office. Word is the letter pad for writing notices and applications. Excel is the big register with rows and columns where the accounts clerk keeps totals. PowerPoint is the chart paper you pin on the board for a presentation. The same scissors and glue (cut, copy and paste) work on all three, which is why the common shortcuts are worth learning first.
What SSC asks from this chapter
In the SSC CGL Tier-II computer module and in CHSL computer questions, MS Office questions are mostly short and factual: a shortcut, a file extension, the name of a view or feature. The scoring edge comes from Excel, where you may have to work out the result of a formula such as =COUNT, =AVERAGE or =IF, or say how a formula changes when it is copied. This guide covers both.
Shortcuts common to Word, Excel and PowerPoint
| Shortcut | Action | Easy way to remember |
|---|---|---|
| Ctrl + C | Copy | C for Copy |
| Ctrl + X | Cut | X looks like open scissors |
| Ctrl + V | Paste | V is next to C on the keyboard |
| Ctrl + Z | Undo | Z is the last letter: go back |
| Ctrl + Y | Redo | Y comes just before Z |
| Ctrl + S | Save | S for Save |
| Ctrl + P | P for Print | |
| Ctrl + A | Select all | A for All |
| Ctrl + F | Find | F for Find |
| Ctrl + H | Replace | Find and Replace dialog |
| Ctrl + N / Ctrl + O | New file / Open file | N for New, O for Open |
| F7 / F12 | Spelling check / Save As | Function keys |
MS Word: features that come up
Word in one look
- Default extension from Word 2007: .docx (older Word 97-2003: .doc).
- Ctrl + B bold, Ctrl + I italic, Ctrl + U underline.
- Enter = new paragraph, Shift + Enter = line break, Ctrl + Enter = page break.
- Header and footer: text repeated at the top and bottom of every page.
- Portrait = taller than wide; Landscape = wider than tall.
- Mail Merge: one main letter + a list of names = a personalised copy for each person.
- Shift + F3 changes the case of selected text (lower, UPPER, Each Word).
Quick check
In MS Word, which shortcut makes the selected text italic?
MS Excel: cells, ranges and formulas
An Excel file is a workbook, and each tab inside it is a worksheet. Columns are named with letters and rows with numbers, so the cell C5 sits in column C, row 5. Every formula begins with an equals sign. A colon builds a range (A1:A5 means A1 to A5), while a comma lists separate cells (A1,A5 means only those two).
Worked example: order of operations
Find the value of =10+4*32.
Step 1 (power): 32 = 9.
Step 2 (multiply): 4 × 9 = 36.
Step 3 (add): 10 + 36 = 46.
Adding first would give (10 + 4) × 9 = 126, which is wrong.
Functions you must know
| Function | What it does | Example and result |
|---|---|---|
| SUM | Adds numbers | =SUM(4,6,10) → 20 |
| AVERAGE | Mean of the numbers, blanks ignored | =AVERAGE(4,6,11) → 7 |
| COUNT | Counts cells with numbers | 12, Pune, 0 → 2 |
| COUNTA | Counts all non-empty cells | 12, Pune, 0 → 3 |
| MAX / MIN | Largest / smallest value | =MAX(5,-8,2) → 5, =MIN(5,-8,2) → -8 |
| IF | Returns one value if true, another if false | =IF(35>=33,"Pass","Fail") → Pass |
| COUNTIF | Counts cells meeting a condition | 40, 55, 70 with ">50" → 2 |
| VLOOKUP | Finds a value in the first column, returns from a given column | =VLOOKUP(code, table, 3, FALSE) |
| INT | Rounds down to a whole number | =INT(7.9) → 7, =INT(-7.9) → -8 |
| LEN | Counts characters, including spaces | =LEN("Hi you") → 6 |
Worked example: COUNT versus COUNTA
A1:A5 hold 8, Kolkata, (blank), 0 and 15.
=COUNT(A1:A5): numbers are 8, 0 and 15, so the result is 3.
=COUNTA(A1:A5): non-empty cells are 8, Kolkata, 0 and 15, so the result is 4.
=AVERAGE(A1:A5): (8 + 0 + 15) ÷ 3 = 23 ÷ 3 ≈ 7.67. Text and blanks are ignored, but 0 is counted.
Relative, absolute and mixed references
When you copy a formula, Excel shifts its cell references by the same number of rows and columns that you moved. A dollar sign stops that shift for the part written right after it.
| Type | Written as | On copying |
|---|---|---|
| Relative | A1 | Both column and row change |
| Absolute | $A$1 | Nothing changes |
| Mixed (column fixed) | $A1 | Only the row changes |
| Mixed (row fixed) | A$1 | Only the column changes |
Worked example: copying a formula
C3 contains =A3*$B$1. It is copied to C4 (one row down).
A3 is relative, so it becomes A4.
$B$1 is absolute, so it stays $B$1.
C4 now contains =A4*$B$1. This is how one fixed rate in B1 is applied to a whole column.
Quick check
Cell B2 contains =A$1+$A2. If it is copied to C3, what will C3 contain?
Excel error values
| Error | Usual cause |
|---|---|
| #DIV/0! | Dividing by zero or by a blank cell |
| #NAME? | Misspelt function or unknown name, such as =SUMM() |
| #VALUE! | Wrong type of data, such as adding text to a number |
| #REF! | Formula refers to a cell that has been deleted |
| #N/A | A lookup could not find the value |
MS PowerPoint basics
PowerPoint in one look
- Default extension from PowerPoint 2007: .pptx (older: .ppt).
- F5 starts the show from slide 1; Shift + F5 starts from the current slide; Esc ends it.
- Ctrl + M inserts a new slide.
- Normal view for editing, Slide Sorter view for rearranging thumbnails, Notes Page view for speaker notes, Reading view for viewing in the window.
- Transition = effect between slides; Animation = effect on an object inside a slide.
- Slide Master = one place to set fonts, logo and background for all slides.
Quick check
In MS PowerPoint, which key combination starts the slide show from the slide that is currently selected?
Keep studying
8 min read
Computer Fundamentals: Generations, Devices and Number Systems for SSC
8 min read
Memory and Storage: RAM, ROM, Cache and Disks for SSC
8 min read
Operating Systems and Software: Windows, Types and File Extensions for SSC
9 min read
Internet, Networking and Cyber Security for SSC: The Complete Basics