SSC CGL · Computer Knowledge

MS Office (Word, Excel, PowerPoint)

40 practice questions with full step-by-step solutions, quick revision notes, plus a concept-first explainer — free, no sign-up.

Reviewed by (19 years teaching)Written with AI helpReport a mistake

What you'll learn

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.

Read MS Office for SSC: Word, Excel and PowerPoint Made Easy

This chapter has

12
easy
20
medium
8
hard

MS Office (Word, Excel, PowerPoint) — quick revision notes

This chapter covers the parts of MS Office that SSC asks again and again: the common shortcuts shared by Word, Excel and PowerPoint, Word formatting and features like Mail Merge and page breaks, Excel cells, ranges, formulas, functions, error values and cell references, and PowerPoint views, transitions and the Slide Master. Most questions are one-line recall, but Excel formula questions need a quick, careful calculation.
  • Shortcuts common to Office: Ctrl + C copy, Ctrl + X cut, Ctrl + V paste, Ctrl + Z undo, Ctrl + Y redo, Ctrl + S save, Ctrl + P print, Ctrl + A select all, Ctrl + F find, Ctrl + H replace, Ctrl + N new, Ctrl + O open.
  • Word alignment: Ctrl + L left, Ctrl + E centre, Ctrl + R right, Ctrl + J justify. Formatting: Ctrl + B bold, Ctrl + I italic, Ctrl + U underline.
  • Function keys: F1 Help, F7 spelling check, F12 Save As. In PowerPoint, F5 starts the show from slide 1 and Shift + F5 from the current slide.
  • Default extensions from Office 2007: Word .docx, Excel .xlsx, PowerPoint .pptx. The older 97-2003 formats were .doc, .xls and .ppt.
  • Excel structure: a workbook (file) holds worksheets; a cell is where a column (letter) meets a row (number), so C5 is column C, row 5.
  • Every Excel formula starts with =. A colon makes a range (A1:A5 = 5 cells), a comma lists separate cells (A1,A5 = 2 cells). A1:B3 covers 2 columns × 3 rows = 6 cells.
  • Order of operations in Excel: ^ first, then * and /, then + and -. So =2+32*2 = 2 + 18 = 20.
  • References: A1 relative, $A$1 absolute, $A1 or A$1 mixed. When copied, only the part without $ moves. =$B2*C$1 copied one cell right and down becomes =$B3*D$1.
  • COUNT counts numbers only (0 counts), COUNTA counts all non-empty cells, AVERAGE ignores blank cells, COUNTIF counts cells meeting a condition such as ">50".
  • Error values: #DIV/0! dividing by zero or a blank cell, #NAME? misspelt function, #VALUE! wrong data type, #REF! invalid cell reference, #N/A lookup value not found.
  • Useful functions: INT rounds down (INT(-3.7) = -4), LEN counts characters including spaces, & joins text, IF tests a condition, VLOOKUP finds a value in the first column and returns from the column number given.
  • PowerPoint: Ctrl + M new slide, Slide Sorter view to rearrange slides, transitions act between slides, animations act on objects within a slide, and the Slide Master sets the design for all slides.

Common mistakes to avoid

  • Mixing up F5 (show from first slide) with Shift + F5 (show from current slide) in PowerPoint.
  • Thinking Ctrl + C centres text because C looks like 'Centre': centre is Ctrl + E.
  • Writing a range with a comma: =SUM(A1,A5) adds only two cells, while =SUM(A1:A5) adds five.
  • Moving the $-locked part when copying a formula: only the column or row WITHOUT a $ changes.
  • Skipping the 0 in COUNT, or treating a blank cell as 0 in AVERAGE.
  • Using '>=' logic when the condition is '>': 50 is not greater than 50, both in IF and in COUNTIF.
  • Choosing the old extensions .doc, .xls or .ppt when the question says Office 2007 or later.
Exam tip: Make a one-page shortcut table and revise it daily for a week; those are free marks. For Excel formula questions, write the cell values in a small row on your rough sheet and work step by step in Excel's order of operations, checking every '>' versus '>=' before you mark.

MS Office (Word, Excel, PowerPoint) — solved practice questions

10 SSC CGL Computer Knowledge questions with step-by-step solutions. Attempt each, then reveal the answer.

These worked examples are not in the timed test, so you can study them first.

  1. Q1easyReport

    In MS Word, which keyboard shortcut copies the selected text?

    • ACtrl + V
    • BCtrl + P
    • CCtrl + X
    • DCtrl + C
    Show answer & solution

    Correct answer: (D) Ctrl + C

    Ctrl + C copies the selection to the clipboard and leaves the original text where it is. Ctrl + V pastes what is on the clipboard, Ctrl + X cuts (moves) the text, and Ctrl + P opens Print. The same shortcuts work in Excel and PowerPoint too. Answer: Ctrl + C.
  2. Q2easyReport

    What does the shortcut Ctrl + Z do in MS Office applications?

    • AZooms into the document
    • BRedoes the last undone action
    • CUndoes the last action
    • DCuts the selected text
    Show answer & solution

    Correct answer: (C) Undoes the last action

    Ctrl + Z is Undo: it reverses your most recent action, and pressing it again goes further back. Redo is Ctrl + Y, cut is Ctrl + X, and zoom has no Ctrl + Z shortcut. Answer: Undoes the last action.
  3. Q3easyReport

    In MS Excel, the box formed where a row and a column meet is called a:

    • ACell
    • BWorksheet
    • CRange
    • DWorkbook
    Show answer & solution

    Correct answer: (A) Cell

    Each row (numbered 1, 2, 3, ...) crosses each column (lettered A, B, C, ...) in one box called a cell, named by its column and row, such as B4. A range is a group of cells (for example A1:A10), a worksheet is one full sheet of cells, and a workbook is the whole Excel file holding the sheets. Answer: Cell.
  4. Q4easyReport

    What is the default file extension of a document saved in MS Word 2007 and later versions?

    • A.pptx
    • B.docx
    • C.xlsx
    • D.doc
    Show answer & solution

    Correct answer: (B) .docx

    From Word 2007 onwards, documents are saved by default in the XML-based format with the extension .docx. .doc was the default in Word 97-2003, so it is the trap option here. .xlsx is an Excel workbook and .pptx is a PowerPoint presentation. Answer: .docx.
  5. Q5easyReport

    In MS PowerPoint, which key starts the slide show from the first slide?

    • AF5
    • BF7
    • CF12
    • DShift + F5
    Show answer & solution

    Correct answer: (A) F5

    F5 starts the slide show from the beginning (slide 1). Shift + F5 starts it from the slide you are currently on, which is the common trap. F7 runs the spelling check and F12 opens Save As. Answer: F5.
  6. Q6mediumReport

    Which formula correctly adds all the values in cells A1 to A5 in MS Excel?

    • A=SUM(A1:A5)
    • BSUM(A1:A5)
    • C=ADD(A1:A5)
    • D=SUM(A1,A5)
    Show answer & solution

    Correct answer: (A) =SUM(A1:A5)

    A colon (:) means 'from ... to', so A1:A5 is the range A1, A2, A3, A4 and A5. =SUM(A1,A5) uses a comma, which adds only the two cells A1 and A5. Excel has no ADD function, so =ADD(A1:A5) gives a #NAME? error. SUM(A1:A5) without the equals sign is treated as plain text, not a formula. Answer: =SUM(A1:A5).
  7. Q7mediumReport

    In MS Excel, the cell reference $A$1 is an example of:

    • AA mixed reference
    • BA circular reference
    • CA relative reference
    • DAn absolute reference
    Show answer & solution

    Correct answer: (D) An absolute reference

    The $ sign locks whatever comes right after it. In $A$1 both the column (A) and the row (1) are locked, so the reference does not change when the formula is copied. This is an absolute reference. A1 (no $) is relative, while $A1 or A$1 (only one part locked) is mixed. A circular reference is a formula that refers back to its own cell, which is a different idea. Answer: An absolute reference.
  8. Q8mediumReport

    In MS Excel, cell A1 contains 250. What value does the formula =A1*20% return?

    • A270
    • B12.5
    • C50
    • D5000
    Show answer & solution

    Correct answer: (C) 50

    In Excel, 20% is read as 20 ÷ 100 = 0.2. =A1*20% = 250 × 0.2 = 50. 5000 comes from multiplying by 20 and forgetting the % sign, 270 comes from adding 20, and 12.5 is 250 ÷ 20. Answer: 50.
  9. Q9hardReport

    Cell D2 of an Excel sheet contains the formula =$B2*C$1. If this formula is copied to cell E3, what formula will E3 contain?

    • A=$B2*C$1
    • B=$C3*D$1
    • C=$B3*D$2
    • D=$B3*D$1
    Show answer & solution

    Correct answer: (D) =$B3*D$1

    Moving from D2 to E3 shifts the formula 1 column right and 1 row down. Only the parts without a $ sign change. $B2: column B is locked by $, row 2 is free, so it becomes $B3. C$1: column C is free, row 1 is locked, so it becomes D$1. Result: =$B3*D$1. =$B2*C$1 would be right only if both references were fully absolute, =$C3*D$1 wrongly moves the locked column B, and =$B3*D$2 wrongly moves the locked row 1. Answer: =$B3*D$1.
  10. Q10mediumReport

    In MS Word, which shortcut aligns the selected paragraph to the centre?

    • ACtrl + L
    • BCtrl + J
    • CCtrl + E
    • DCtrl + C
    Show answer & solution

    Correct answer: (C) Ctrl + E

    The alignment shortcuts in Word are: Ctrl + L for left, Ctrl + E for centre, Ctrl + R for right and Ctrl + J for justify. Ctrl + C is the trap because 'C' looks like 'Centre', but Ctrl + C is Copy. Answer: Ctrl + E.

Ready to test yourself? Take the 30-question MS Office (Word, Excel, PowerPoint) test →