MS Office is Microsoft's suite of productivity applications. For SSC CGL Computer Awareness, this chapter is almost pure memorization — but the right kind. You are not being tested on how to use these tools; you are being tested on specific facts: which shortcut does what, which function returns what, which file extension belongs to which version.
Think of MS Office as a city with four distinct neighborhoods:
Each application has its own default file extension, its own shortcut ecosystem, and its own vocabulary (cells vs. slides vs. documents vs. tables). The SSC CGL paper exploits the overlaps — it asks you Ctrl+H in Word (Find and Replace) when you might confuse it with Ctrl+F (Find only). It asks about MAX vs. LARGE vs. HIGH (where the last one does not even exist as a function).
Here is the analogy that sticks: Word is a notebook, Excel is a calculator with memory, PowerPoint is a projector, and Access is a filing cabinet with an index system. Each tool exists because no single tool does all four jobs well.
The version divide matters. MS Office 97-2003 saved files in binary formats (.doc, .xls, .ppt). Office 2007 introduced Open XML formats (.docx, .xlsx, .pptx) — smaller, less corruptible, and XML-based. That version break is a permanent fixture in SSC exams.
Default settings you must know:
Critical Word shortcuts:
| Shortcut | Action | |---|---| | Ctrl + S | Save | | Ctrl + P | Print | | Ctrl + C | Copy | | Ctrl + X | Cut | | Ctrl + V | Paste | | Ctrl + Z | Undo | | Ctrl + Y | Redo | | Ctrl + F | Find | | Ctrl + H | Find and Replace | | Ctrl + G | Go To | | Ctrl + B | Bold | | Ctrl + I | Italic | | Ctrl + U | Underline | | Ctrl + A | Select All | | Ctrl + N | New Document | | Ctrl + O | Open | | Ctrl + W | Close Document | | Ctrl + Home | Move to beginning | | Ctrl + End | Move to end |
The one that SSC loves to test: Ctrl + H opens Find and Replace, not Ctrl + F. Ctrl + F opens only the Find panel.
Word Views: Print Layout (default), Read Mode, Web Layout, Outline, Draft.
Mail Merge — combining a template document with a data source (like an Excel sheet) to produce personalized letters. The three stages: main document, data source, merged output.
Worksheet basics:
Functions you must know cold:
| Function | What it does | Example | |---|---|---| | SUM | Adds values | =SUM(A1:A10) | | AVERAGE | Arithmetic mean | =AVERAGE(A1:A10) | | MAX | Highest value | =MAX(A1:A10) | | MIN | Lowest value | =MIN(A1:A10) | | COUNT | Counts numeric cells | =COUNT(A1:A10) | | COUNTA | Counts non-empty cells | =COUNTA(A1:A10) | | COUNTIF | Counts cells meeting a condition | =COUNTIF(A1:A10,">5") | | SUMIF | Sums cells meeting a condition | =SUMIF(A1:A10,">5") | | VLOOKUP | Vertical lookup | =VLOOKUP(value, range, col, 0) | | IF | Conditional logic | =IF(A1>10,"Yes","No") | | LARGE | Returns nth largest value | =LARGE(A1:A10,2) |
Look — LARGE and MAX are different. MAX returns the single highest value. LARGE(range, 1) returns the highest, LARGE(range, 2) returns the second highest. SSC has tested this distinction.
Excel shortcuts:
Cell referencing:
Views:
File extension: .pptx (2007+), .ppt (older)
Slide elements: Placeholders, Text Boxes, Shapes, SmartArt, Charts, Tables, Media
Transitions — effects between slides (Fade, Wipe, Push) Animations — effects on individual objects within a slide (Appear, Fly In, Spin)
Key shortcut: F5 starts the slideshow from the beginning. Shift + F5 starts from the current slide.
MS Access is a Relational Database Management System (RDBMS). It organizes data in tables with rows (records) and columns (fields).
Objects in Access:
File extension: .accdb (Access 2007+), .mdb (older)
Primary Key: a field that uniquely identifies each record. No duplicates, no nulls.
SSC always tries to swap Ctrl+H and Ctrl+F. Lock this in: H = Hunt and Replace (Hunt = Find, Replace = the second action). Ctrl+F = Find only (F = Find, one action). Ctrl+G = Go To (G = Go). Three consecutive letters C, F, G, H map to three functions: Find, Go To, Find-and-Replace — in alphabetical order but shuffled by usage. Standard recall: 8 seconds of confusion. With this pattern: under 2 seconds.
Office 2007 was the great divide. Before 2007: .doc, .xls, .ppt (three letters). From 2007 onward: .docx, .xlsx, .pptx (four letters, the X = XML). Every question about file extensions becomes a binary decision: is it the old format or the new format? 2007+ always gets the X. Standard approach: trying to recall independently for each app — 15 seconds. With this rule: 3 seconds across all three apps simultaneously.
When a question asks for the "highest value," the answer is MAX, not LARGE — unless the question says "second highest," "third highest," or "nth highest." LARGE needs a second argument (the rank number). MAX takes only a range. Eliminate TOP and HIGH immediately — neither is a real Excel function. This cuts four-option questions down to a one-step check: does the question mention a rank? If yes, LARGE. If no, MAX. Time saved: eliminates re-reading the options — saves 10-12 seconds per question.
Map each view to its job: Normal = Create (you build slides here), Sorter = Arrange (you drag slides here), Reading = Review (you watch it here in a window), Presenter = Deliver (you present here with notes). The SSC question almost always describes the job and asks the name. "Grid layout, rearranging" — that is Arrange = Sorter. Standard recall from a list: 12 seconds. With the Create-Arrange-Review-Deliver map: 4 seconds.
Four COUNT functions appear in SSC options: COUNT, COUNTA, COUNTIF, COUNTBLANK. Separate them in one sentence: COUNT = numbers only, COUNTA = anything non-empty, COUNTIF = conditional, COUNTBLANK = empty cells only. When the question says "meets a specific condition" or "specific criterion," eliminate COUNT, COUNTA, COUNTBLANK immediately — only COUNTIF remains. Reduces a 4-option question to a 0-second decision after reading "condition."
When you see an MS Office question in the exam hall, run this decision tree in sequence:
Step 1 — Identify the application. Word (documents), Excel (cells/formulas), PowerPoint (slides/views), Access (database/tables). If the question mentions "cells" or a function with =, it is Excel. If it mentions "slides" or "thumbnails," it is PowerPoint.
Step 2 — Identify the question type. Is it asking about a shortcut key, a file extension, a function name, a view name, or a default setting?
Step 3 — Apply the relevant rule:
Step 4 — If genuinely unsure, eliminate the options that are clearly invented (e.g., .wrd, HIGH, Alt+S for Save) — they are planted distractors. You rarely need to guess between more than two real options.
Target time per MS Office question: 20-25 seconds.
Why this question: The most basic shortcut in any Office application — tests whether you confuse Save with Print (Ctrl+P) or other common Ctrl combinations.
Solving path: Ctrl+P = Print (P for Print). Ctrl+D = Font dialog in Word. Alt+S is not a standard Word shortcut. Only Ctrl+S remains for Save. Confirmed answer: Ctrl+S.
Why this question: Excel function names are a classic SSC trap. They plant plausible-sounding fake functions alongside real ones.
Solving path: TOP and HIGH do not exist as Excel functions — eliminate immediately. LARGE requires a rank argument (=LARGE(range, n)) and is used for nth largest values. For the single highest value with no rank specified, MAX is the answer. Zero ambiguity once you eliminate the fake options.
Why this question: The 2003-vs-2007 version divide is tested consistently. The .doc vs .docx distinction is a permanent SSC fixture.
Solving path: .txt is plain text — not a Word format. .wrd does not exist. .doc is the Word 97-2003 format. .docx is the 2007+ format based on XML. The question specifies "2007 and later," so the answer is .docx.
Why this question: PowerPoint view names are a recurring SSC topic. The description "thumbnails in a grid for rearrangement" is a direct hint toward one specific view.
Solving path: Outline View shows only text. Normal View is the default editing view with one slide at a time. Reading View plays the presentation in a window. Only Slide Sorter View shows all slides as small thumbnails in a grid — which matches "rearrangement" perfectly.
Why this question: Tests the Find-and-Replace vs Find-only distinction — the most common Word shortcut trap in SSC history.
Solving path: Ctrl+F opens the Find panel (Find only). Ctrl+R aligns paragraph to the right. Ctrl+G opens Go To. Ctrl+H opens Find and Replace. The question asks specifically for "Find and Replace," so Ctrl+H is correct — not Ctrl+F, which catches many candidates off guard.
Confusing Ctrl+F and Ctrl+H in Word. Ctrl+F finds text; Ctrl+H finds and replaces. SSC routinely offers both as options. The presence of "Replace" in the question is your signal to pick H.
Selecting LARGE instead of MAX for "highest value." LARGE returns the nth largest value and requires a second argument. When no rank is mentioned, MAX is always the answer for the single highest value.
Confusing .doc with .docx. The default for Word 2007 and later is .docx, not .doc. If the question says "2007 or later," the answer is .docx every single time.
Mixing up COUNT and COUNTIF. COUNT counts numeric cells with no condition. COUNTIF counts cells that meet a specified condition. The word "condition" or "criterion" in the question is the trigger for COUNTIF.
Choosing "Landscape" as the Word default. The default orientation is Portrait. Landscape must be manually applied. This sounds obvious but under exam pressure, "Landscape" often looks like a reasonable answer when the question is worded about page orientation options.
Treating MS Access as a presentation tool or spreadsheet. Access is a database application. It stores data in tables, retrieves it with queries, accepts input through forms, and outputs through reports. Any question about "database," "records," "primary key," or "queries" in the MS Office context points to Access, not Excel.