MS Office is Microsoft's suite of productivity applications. For SBI PO purposes, you need working knowledge of three applications — Word (word processing), Excel (spreadsheet/calculation), and PowerPoint (presentation). The exam does not ask you to operate the software; it tests whether you know the rules those applications follow: default settings, keyboard shortcuts, function behavior, file extensions, and named features.
Think of it like knowing traffic laws without necessarily being a driver. You don't need to have built a spreadsheet recently to answer "which symbol starts a formula in Excel?" — you need to have that rule locked in memory.
Here is the mental model that makes this topic easy: every MS Office application has the same Ribbon structure — a horizontal toolbar divided into tabs (Home, Insert, Layout/Page Layout, Review, View, etc.). Most exam questions point you to one of two things: which tab holds a particular feature, or what a particular shortcut / function / default setting does. Once you map features to tabs and memorize about fifteen shortcuts and defaults, the entire topic collapses.
A useful analogy: the Ribbon is like a government ministry. Each ministry (tab) has its own department (group within the tab). When a question asks "where do you find page margins?" — you think "that is administrative/layout work, so it belongs in the Layout ministry." That reasoning alone handles 40% of MS Word questions.
The key versions you should be aware of are Office 2003 (used .doc, .xls, .ppt), Office 2007 onwards (introduced .docx, .xlsx, .pptx — the x stands for XML), and Office 365 (cloud-integrated, same extensions). Exam questions frequently exploit the 2003-vs-2007 extension change.
Default settings (these appear directly in PYQs):
.docx (Office 2007+), .doc (Office 2003 and earlier)Ribbon tab map for Word (memorize this column):
| Feature | Tab | |---|---| | Font, Paragraph, Styles, Clipboard | Home | | Tables, Pictures, Shapes, Header/Footer, Page Number | Insert | | Margins, Orientation, Page Size, Columns, Indents, Spacing | Layout (formerly Page Layout) | | Table of Contents, Footnotes, Citations | References | | Mail Merge | Mailings | | Spelling, Grammar, Track Changes, Comments | Review | | Normal, Print Layout, Web Layout, Outline, Draft views | View |
Views in Word:
Mail Merge is a frequently tested concept. It allows you to create a template document (in Word) and merge it with a data source (typically an Excel sheet or Access database) to produce personalized copies — for example, 500 individually addressed appointment letters from one template. The Mailings tab controls this entire process.
The formula rule: Every formula in Excel begins with =. Without the equals sign, Excel treats the entry as plain text. This is tested directly.
Key functions:
| Function | What it does |
|---|---|
| =SUM(A1:A10) | Adds all values in range A1 to A10 |
| =AVERAGE(A1:A10) | Arithmetic mean of the range |
| =MAX(A1:A10) | Largest value in range |
| =MIN(A1:A10) | Smallest value in range |
| =COUNT(A1:A10) | Counts cells containing numbers |
| =COUNTA(A1:A10) | Counts non-empty cells |
| =IF(condition, value_if_true, value_if_false) | Conditional logic |
| =VLOOKUP(lookup_value, table_array, col_index, range_lookup) | Vertical lookup |
Cell reference types:
A1) — changes when formula is copied to another cell$A$1) — stays fixed regardless of where formula is copied; $ locks the reference$A1 or A$1) — locks only one dimensionFile extension: .xlsx (Office 2007+), .xls (Office 2003)
Workbook vs. Worksheet: A workbook is the entire file. Each tab at the bottom is a worksheet (also called a sheet). One workbook can hold multiple worksheets.
Views in PowerPoint:
| View | Purpose | |---|---| | Normal View | Default editing view; shows slide panel, editing area, notes | | Slide Sorter View | All slides as thumbnails; best for rearranging order | | Reading View | Full-screen presentation for review, without presenter mode | | Slide Show View | Full-screen presentation mode for the audience | | Presenter View | Shows slide + notes + next slide for the presenter | | Outline View | Shows text content in outline form |
The exam repeatedly tests Slide Sorter View — it is the correct answer whenever a question asks "which view is best for rearranging/reordering slides."
Transitions vs. Animations:
File extension: .pptx (Office 2007+), .ppt (Office 2003)
| Shortcut | Action |
|---|---|
| Ctrl + S | Save |
| Ctrl + Z | Undo |
| Ctrl + Y | Redo |
| Ctrl + C | Copy |
| Ctrl + X | Cut |
| Ctrl + V | Paste |
| Ctrl + A | Select All |
| Ctrl + P | Print |
| Ctrl + F | Find |
| Ctrl + H | Find and Replace |
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
| F7 | Spell Check |
| Ctrl + Home | Go to beginning of document |
| Ctrl + End | Go to end of document |
All Office 2007+ formats end in 'x' (.docx, .xlsx, .pptx). The 'x' stands for XML. Older (2003) formats have no 'x': .doc, .xls, .ppt. If a question asks about the "default format in recent versions," add an 'x'. If it asks about "legacy" or "older" format, remove the 'x'. This eliminates wrong options in under 5 seconds — no calculation needed vs. trying to recall full format names from scratch (20-30 seconds).
Memorize the Word tabs with the mnemonic LIRA (like the Italian currency):
When a question names a feature, ask: is it about the look of the page? (Layout). Is it about adding something new? (Insert). Is it about checking/verifying? (Review). This decision eliminates 3 wrong options in under 8 seconds vs. running through all tabs mentally one by one (30+ seconds).
Both Word and PowerPoint have a view that starts "Print" (Print Preview / Print Layout) for print purposes, and a view with "Sorter" / "Outline" for structural editing. For PowerPoint specifically: Sorter = rearranging slides (think of sorting cards in a hand). Any question ending with "rearranging/reordering slides" → Slide Sorter View, no reading required. This handles the question in 4 seconds vs. comparing all four view options (15-20 seconds).
In Excel, the answer to "which character starts a formula" will always be =. The distractors (#, @, $) all have specific Excel meanings but none starts a formula: # appears in error codes (#REF!, #VALUE!), $ locks cell references inside a formula, @ is used in table structured references. Knowing these secondary roles means you can eliminate all three distractors in 3 seconds rather than just guessing = and hoping.
The default font change happened in the same version that introduced .docx: Office 2007. If you remember "2007 = docx = Calibri," both default-font and default-extension questions collapse into one memory peg. Recall time: 3 seconds. Without this link, students often second-guess between Arial and Calibri, wasting 20+ seconds.
When you see an MS Office question in the exam hall, run this decision tree:
Step 1 — Identify the application. Is the question about Word (document/text), Excel (cells/numbers/formulas), or PowerPoint (slides/presentation)?
Step 2 — Identify the question type. Is it asking about:
Ctrl + S = save is the most common..docx/.xlsx/.pptx.Step 3 — Eliminate. In most MS Office questions, two options are clearly irrelevant. Eliminate them first, then choose between the remaining two using the specific rule.
Step 4 — Do not overthink interface details. If you have not used Office 2019 or 365 recently, ignore version-specific UI changes — exam questions target stable, version-agnostic knowledge.
Total time target per MS Office question: 15-20 seconds.
Why this question: Tests the tab-location knowledge that appears in almost every SBI PO Computer paper — specifically which Ribbon tab holds page formatting options.
Solving path: Apply the LIRA logic — "Page Layout" deals with the physical appearance of the page (margins, orientation, size). That is Layout's territory. Home handles text formatting, Insert adds objects, References handles citations. Eliminate Home, Insert, References. Answer: Layout. Time: 8 seconds.
Why this question: The most direct test of Excel formula syntax — answered correctly by nearly all serious aspirants but missed by those who confuse $ (absolute reference symbol) with the formula-start character.
Solving path: # appears in Excel errors. @ is used in structured table references. $ locks cell references within a formula but does not start one. Only = signals to Excel "calculate what follows." Answer: =. Time: 5 seconds.
Why this question: Print Preview is frequently confused with Print Layout view. The question directly tests this distinction.
Solving path: Normal View = basic editing without full page display. Web Layout = browser appearance. Outline View = heading hierarchy. Print Preview = exact on-paper appearance including margins and page breaks. The question says "how your document will look when printed" — that is the Print Preview definition verbatim. Answer: Print Preview. Time: 10 seconds.
Why this question: PowerPoint views are a recurring question category. The "rearranging slides" trigger phrase maps to exactly one view.
Solving path: Normal View = default editing. Reading View = personal review. Slide Show View = audience presentation. Slide Sorter View = all slides as thumbnails, drag-and-drop reordering. The moment you see "rearranging the order of slides," the answer is Slide Sorter View. Answer: Slide Sorter View. Time: 6 seconds.
Why this question: Shortcut keys appear in every Computer section and Ctrl + S is the most universally tested.
Solving path: Ctrl + A = Select All. Ctrl + C = Copy. Ctrl + V = Paste. Ctrl + S = Save. All four are in the universal shortcut table. Eliminate the three distractors instantly. Answer: Ctrl + S. Time: 4 seconds.
Confusing .doc and .docx as interchangeable. They are not. .doc is the pre-2007 binary format; .docx is the XML-based format introduced in Office 2007. When a question says "recent versions," the answer is .docx — always.
Selecting "Times New Roman" as the default font. This was the default before Office 2007. Since 2007, it is Calibri. Exam setters know aspirants have this outdated memory and use Times New Roman as the primary distractor.
Choosing "Normal View" for print-related questions in Word. Normal View (now called Draft View in newer versions) is a simplified editing view — it does not show how the document will print. Print Preview does.
Mixing up PowerPoint's Slide Show View and Slide Sorter View. Slide Show View is the full-screen mode the audience sees during a live presentation. Slide Sorter View is the thumbnail grid used for editing and rearranging. The question's purpose tells you which one: "presenting to audience" = Slide Show; "reorganizing" = Slide Sorter.
Thinking $ starts an Excel formula. The $ symbol is used inside formulas to create absolute cell references (e.g., =$A$1+B2), but it does not initiate the formula. Only = does that.
Placing Mail Merge under the Insert or Review tab. Mail Merge lives in the Mailings tab in Word. It is one of the least-used tabs, which is exactly why examiners ask about it. Do not guess Insert (for inserting objects) or Review (for checking content).