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 (19 years teaching)Written with AI helpReport a mistake

9 min read · Published 2 November 2026

Part of SSC CGL prep

The 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

ShortcutActionEasy way to remember
Ctrl + CCopyC for Copy
Ctrl + XCutX looks like open scissors
Ctrl + VPasteV is next to C on the keyboard
Ctrl + ZUndoZ is the last letter: go back
Ctrl + YRedoY comes just before Z
Ctrl + SSaveS for Save
Ctrl + PPrintP for Print
Ctrl + ASelect allA for All
Ctrl + FFindF for Find
Ctrl + HReplaceFind and Replace dialog
Ctrl + N / Ctrl + ONew file / Open fileN for New, O for Open
F7 / F12Spelling check / Save AsFunction keys
Ctrl + C is Copy, not Centre. In Word the alignment keys are Ctrl + L (left), Ctrl + E (centre), Ctrl + R (right) and Ctrl + J (justify). Examiners put Ctrl + C in the options for 'centre' every year.

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

Cells in a range = (number of columns) × (number of rows). A1:B3 → 2 columns × 3 rows = 6 cells. Order of operations: ^ first, then * and /, then + and -.

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

FunctionWhat it doesExample and result
SUMAdds numbers=SUM(4,6,10) → 20
AVERAGEMean of the numbers, blanks ignored=AVERAGE(4,6,11) → 7
COUNTCounts cells with numbers12, Pune, 0 → 2
COUNTACounts all non-empty cells12, Pune, 0 → 3
MAX / MINLargest / smallest value=MAX(5,-8,2) → 5, =MIN(5,-8,2) → -8
IFReturns one value if true, another if false=IF(35>=33,"Pass","Fail") → Pass
COUNTIFCounts cells meeting a condition40, 55, 70 with ">50" → 2
VLOOKUPFinds a value in the first column, returns from a given column=VLOOKUP(code, table, 3, FALSE)
INTRounds down to a whole number=INT(7.9) → 7, =INT(-7.9) → -8
LENCounts 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.

TypeWritten asOn copying
RelativeA1Both column and row change
Absolute$A$1Nothing changes
Mixed (column fixed)$A1Only the row changes
Mixed (row fixed)A$1Only 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

ErrorUsual 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/AA 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?

Exam strategy: shortcut and feature questions take seconds, so answer them first. For any Excel formula, write the cell values on your rough sheet, apply the order of operations, and check '>' against '>=' before marking. Most wrong answers in the options come from exactly these slips.

Ready to test yourself?

Lock it in with the practice test for this chapter.

Take the practice test

Keep studying

See all SSC CGL study material →