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 Kaustav Basak (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 EasyThis chapter has
MS Office (Word, Excel, PowerPoint) — quick revision notes
- 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.
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.
- 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. - 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. - 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. - 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. - 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. - 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). - 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. - 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. - 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. - 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 →