MS Office Tests — Pick a Test and Start
Tap below to see all the tests. They run through the chapter in order — Test 1 covers the Office ribbon and MS Word basics; Test 2 covers MS Word in depth — shortcuts, tabs, indents, sections and references; Test 3 covers MS Excel — references, functions, errors and data tools; Test 4 covers MS Excel in depth — more functions, Paste Special, tables and shortcuts; Test 5 covers MS PowerPoint and the Office suite; Test 6 covers PowerPoint in depth and Access, Outlook and OneNote. Choose English or हिंदी on any test.
MS Office All Chapter Tests Checking… View tests
Set at real SSC CGL and CHSL Tier II level. Each test mixes the ways SSC asks computer questions — direct one-line questions, statement questions, match the following and assertion–reason — and no fact is asked twice across the chapter.
MS Office is the largest and most practical chapter of Computer Knowledge. SSC asks what a shortcut does (Ctrl + Enter, Shift + F3, F12, Shift + F5), which tab or group holds a command (Watermark, Mail Merge, Format Painter), what a formula returns (=2+3*4^2, COUNTA, VLOOKUP, ROUND) and what each Office application or file extension is for (.docx, .xlsx, .pptx, .accdb, .pst).
Marks are lost in three places. The first is shortcuts that differ by application: Ctrl + D opens the Font dialog in Word but duplicates a slide in PowerPoint and fills down in Excel. The second is Excel order of operations and references: powers before multiplication, and $A$1 vs A$1 vs A1 when a formula is copied. The third is views and tabs: Slide Sorter vs Normal vs Reading view, and whether a command sits on Insert, Design, Layout or References. The tests here are built around exactly these three.
How Many MS Office Questions Are Asked in SSC CGL?
Computer Knowledge is Section III, Module I of SSC CGL Tier II Paper I: 20 questions for 60 marks in 15 minutes, with 1 mark deducted for each wrong answer. It is qualifying — the marks do not add to your rank, but you must clear it. MS Office is one of its seven chapters, and CHSL Tier II has a similar 15-question computer module. The topics below are the ones SSC returns to most often, roughly in order.
| Topic | How often | What is usually asked |
|---|---|---|
| Keyboard shortcuts | Very frequent | Word, Excel and PowerPoint shortcuts: Ctrl + Enter, Shift + F3, F12, F2, Alt + =, Shift + F5, Ctrl + M |
| Excel formulas and functions | Very frequent | Operator precedence, SUM, COUNT, COUNTA, IF, VLOOKUP, ROUND, INDEX/MATCH, error values |
| Ribbon tabs and features | Frequent | Which tab holds Watermark, Mail Merge, Table of Contents, Track Changes, Slide Master |
| Cell references and data tools | Frequent | Relative, absolute and mixed references, sort, filter, Pivot Table, Goal Seek, freeze panes |
| PowerPoint views and animation | Regular | Slide Sorter, Presenter View, transitions vs animations, Slide Master, rehearse timings |
| Office apps and file extensions | Regular | .docx, .xlsx, .pptx, .accdb, .pst, templates; Access objects, Outlook, OneNote, alternatives |
Windows shortcuts such as Win + D and Alt + Tab are in the OS & Windows chapter; this chapter keeps to Word, Excel, PowerPoint and the other Office apps.
What Each MS Office Test Covers
The 150 questions run through the chapter in syllabus order, 25 to a test.
| Test | Topics |
|---|---|
| Test 1 | Ribbon introduction, Dialog box launcher, Interface elements, Window parts, Microsoft 365, Macro-enabled extension, DOCX format, Draft view, Ribbon tab contents, Format Painter, Styles, SmartArt, Page setup defaults, Gutter margin, Footer, Section break, Widow and orphan control, Mail Merge data source, Replace shortcut, Proofing tools, Track Changes shortcut, Features and Ribbon tabs, Page break shortcut, Font size shortcut, Keyboard shortcuts |
| Test 2 | First release, WYSIWYG, Maximum zoom, Default font, Selecting text with the mouse, Ctrl + D, Font formatting shortcuts, Line spacing shortcuts, Ctrl + Shift + M, Hanging indent, Types of tab stops, Ctrl + Shift + L, F4 key, Editing and navigation shortcuts, Types of section breaks, Default text wrapping, Hyphenation, Cross-reference, Caption, Citations, bibliography and index, AutoCorrect vs AutoText, Line Numbers, Combine documents, Protecting and sharing a document, Insert equation |
| Test 3 | Rows per worksheet, Last column, Cell, range, Name Box and status bar, File extensions, Operator precedence, Equal precedence of * and /, F4 key and reference types, Copying relative and absolute references, Relative, absolute and mixed references, COUNTA function, SUMIF function, ROUND function, IF with MIN, VLOOKUP exact match, VLOOKUP and HLOOKUP direction, Error values, #NUM! error, Sort, Filter and Data Validation, Conditional Formatting, Freeze Panes, PivotTable, What-If Analysis, Chart types, Flash Fill shortcut, Shortcut keys |
| Test 4 | Fill handle series, Sheets in a new workbook, Gridlines, Print Titles and zoom, Reference to another sheet, Name Manager, INDEX with MATCH, IFERROR function, IFS function, COUNTIFS function, Text functions, MID function, INT function with a negative number, ROUNDUP function, Statistical functions, NETWORKDAYS function, Joining text with &, Circular reference, Paste Special, Array formulas, Format Cells dialog tabs, Remove Duplicates, Text to Columns and Consolidate, Slicers, Protection, macros and hiding rows, Chart legend, Shortcut keys |
| Test 5 | First release of MS Office, MS Access file extension, Office applications and their uses, Outlook data file (.pst), LibreOffice as an alternative, Apple iWork presentation app, WPS Office developer, Origin of PowerPoint, PowerPoint file extensions, Default layout of first slide, Slide Sorter view, Views of PowerPoint, Presenter View, Slide Master, Animation vs transition, Types of animation effects, Exit animation icon colour, Animation Pane, Slide Show tab features, Action buttons, Speaker notes and handouts, Photo Album, Designer (Design Ideas), PowerPoint shortcut keys, Keys during a slide show |
| Test 6 | Placeholder, Default slide size, Slide Size and Master views, Morph transition, Animation start options, Animation trigger, Advance Slide After, Kiosk mode, Set Up Slide Show options, Record Slide Show, Export as video, Linked vs embedded object, Alt Text, Grouping and slide-show shortcuts, Go to a slide during a show, Header and Footer, MS Access objects, MS Access Design View, Outlook .ost file, MS Outlook features, OneNote organisation, MS Visio, Office Assistant Clippit, Compatibility Mode, Co-authoring with OneDrive |
The three traps that cost the most marks
- Same keys, different apps. Ctrl + D – Font dialog (Word), duplicate slide (PowerPoint), fill down (Excel). F5 – Go To (Word), start slide show (PowerPoint). Always read which application the question names.
- Order of operations in Excel. Brackets, then powers (^), then * and /, then + and −. =2+3*4^2 is 50, not 400 or 80.
- Which tab? Watermark – Design; Drop Cap, WordArt, SmartArt – Insert; Table of Contents, Footnote – References; Mail Merge – Mailings; Track Changes – Review.
Solved Examples — SSC CGL MS Office
(a) Office 2003
(b) Office 2007
(c) Office 2010
(d) Office 2013
1. A contextual tab, such as Picture Format, appears only when a related object is selected.
2. The Backstage view (File tab) was introduced in Office 2010.
3. The Ribbon can be shown or hidden with the shortcut Ctrl + F2.
Which of the statements given above is/are correct?
(a) 1 and 2 only
(b) 2 and 3 only
(c) 1 and 3 only
(d) 1, 2 and 3
Assertion (A): A Word file saved in .docx format is generally smaller in size than the same file saved in .doc format.
Reason (R): The .docx format is based on Office Open XML, in which the file's contents are stored in a compressed (ZIP) package.
(a) Both A and R are true, and R is the correct explanation of A
(b) Both A and R are true, but R is not the correct explanation of A
(c) A is true, but R is false
(d) A is false, but R is true
(a) मेल मर्ज (Mail Merge)
(b) ट्रैक चेंजेस (Track Changes)
(c) कंपेयर (Compare)
(d) को-ऑथरिंग (Co-authoring)
How the MS Office Tests Work
- 25 questions per test, with a full question palette — answered, skipped, marked for review, not visited.
- 6 tests, 150 questions, in syllabus order — the Office ribbon and Backstage view, Word formatting, mail merge and shortcuts, Excel formulas, functions, references and errors, PowerPoint views, animations and shortcuts, and Access, Outlook and OneNote, with no fact repeated across the chapter.
- All SSC question types — direct questions, statement questions, match the following and assertion–reason.
- Optional 15-minute timer — the same 15 minutes the real Computer Knowledge module gives you for 20 questions.
- Marking: +2 correct, −0.5 wrong, 0 unattempted.
- 6–7 point bullet solutions open after you submit — the answer, the rule or full form behind it, related facts asked alongside it and what each wrong option actually refers to.
- English and Hindi — every test and every solution is available in both; choose the language when you start.
- Free with a TrickySSC account — sign in once with Google or your mobile number, and every test is open to you.
How to Prepare MS Office for SSC CGL
- Open the apps while you study. Every shortcut and every tab location here can be checked in seconds on a real computer — doing it once fixes it.
- Keep one shortcut table per app. Three columns — Word, Excel, PowerPoint — make the cross-app traps obvious.
- Work every formula question by hand. Write the steps of a formula on paper before you look at the options; the wrong options are the usual slips.
- Learn the tab map. One line per tab of what it holds answers most “where is this command” questions.
- Read the solutions, not just the answer. Each solution carries six or seven related facts, which is how 150 questions cover the whole chapter.
All SSC CGL Chapter Wise Tests
Every chapter below has its own free chapter tests with full solutions.
Browse all 102 chapter tests — Maths (35) · Reasoning (28) · English (14) · GK (18) · Computer (7)
- Spot the Error
- Sentence Improvement
- Fill in the Blanks
- Active & Passive Voice
- Direct & Indirect Narration
- Sentence Rearrangement / Para Jumbles
- Synonyms
- Antonyms
- Spelling Correction
- Idioms & Phrases
- One Word Substitution
- Homonyms
- Cloze Test
- Reading Comprehension
- All English chapters →
- Word Analogy
- Letter Analogy
- Number Analogy
- Number-Set & Triad Analogy
- Mixed Analogy
- Word Classification
- Letter Classification
- Number Classification
- Number-Pair & Triad Classification
- Word-Pair & Mixed Classification
- Series (Number, Letter & Alphanumeric)
- Alphabet Test
- Coding-Decoding
- Blood Relations
- Direction & Distance
- Time Sequence, Number & Ranking
- Seating Arrangement
- Syllogism
- Statement & Conclusion
- Venn Diagram
- Mathematical Operations
- Missing Number
- Puzzle / Data Arrangement
- Calendar & Clock
- Mirror & Water Image
- Paper Folding, Embedded & Figure Completion
- Figure Series, Classification, Analogy & Counting
- Dice, Cube, Cuboid & Dot Situation
- All Reasoning chapters →
- Number System
- Rule of Divisibility
- Remainder Theorem
- Decimal & Fraction
- LCM & HCF
- Square & Cube Root
- Number Series (AP & GP)
- Power, Indices & Surds
- Algebraic Formula
- Algebraic Result
- Algebraic Expression & Identities
- Percentage
- Profit & Loss
- Discount & Marked Price
- Simple Interest
- Compound Interest
- Ratio & Proportion
- Partnership
- Average
- Problems on Ages
- Mixture & Alligation
- Time & Work
- Pipe and Cistern
- Time, Speed and Distance
- Quadratic Equation
- Boat and Stream
- Races
- Trigonometry
- Heights & Distances
- Geometry
- Mensuration
- Coordinate Geometry
- Probability
- Statistics
- Data Interpretation
- All Maths chapters →
- History: Ancient India
- History: Medieval India
- History: Modern India
- Polity & Constitution
- Art & Culture
- Economics
- Science: Physics
- Science: Chemistry
- Geography: India
- Geography: World
- Science: Biology
- Static: Books & Authors
- Static: Awards & Honours
- Static: Important Days & Events
- Static: Sports
- Govt Schemes
- National & International Organizations
- Static GK: Misc (Dances, Festivals, Symbols, Superlatives)
- All GK chapters →