Microsoft Office is a suite of productivity applications developed by Microsoft. In the IBPS PO computer section, questions on MS Office are almost always factual — they test whether you know the right tab, the right shortcut, the right file extension, or the right function name. There is no calculation involved; it is pure recall, and that makes it one of the easiest scoring areas if you organise your preparation correctly.
Think of MS Office like the three floors of a bank branch. The ground floor is MS Word — where all the written documents, letters, and notices are prepared. The first floor is MS Excel — the accounts department, where numbers live in rows and columns and formulas do the heavy lifting. The top floor is MS PowerPoint — the boardroom, where presentations are made to stakeholders.
Each floor has its own rules:
.docx..xlsx..pptx.The x at the end of each extension is not cosmetic — it signals the XML-based Open Office XML format introduced with the 2007 version of Office. Before 2007, the formats were .doc, .xls, and .ppt (no x). This distinction appears in PYQs.
What makes MS Office questions in IBPS PO manageable is that they follow patterns. The same facts — row limits, formula symbols, view names, tab locations — rotate across years with slight rewording. Build a solid fact-base once, and you will answer four to five questions per exam without reading a single option twice.
The Ribbon and Tabs
MS Word's interface is built around a ribbon with tabs. The tabs you must know:
| Tab | Key Contents | |---|---| | File | New, Open, Save, Save As, Print, Close, Options | | Home | Font, Paragraph, Clipboard, Styles | | Insert | Tables, Pictures, Header/Footer, Page Number, Hyperlink | | Page Layout / Layout | Margins, Orientation, Size, Columns | | References | Table of Contents, Footnotes, Citations | | Review | Spelling & Grammar, Track Changes, Comments | | View | Document Views, Zoom, Macros |
The exam loves asking "which tab contains X?" The most commonly tested: Print is under File, not under Home or Review. Track Changes is under Review. Page Numbers are under Insert.
Document Views in MS Word
Key Shortcuts (MS Word)
| Action | Shortcut | |---|---| | Bold | Ctrl + B | | Italic | Ctrl + I | | Underline | Ctrl + U | | Save | Ctrl + S | | Print | Ctrl + P | | Find | Ctrl + F | | Replace | Ctrl + H | | Undo | Ctrl + Z | | Select All | Ctrl + A |
Cell Structure
An Excel worksheet is a grid of rows and columns. Rows are numbered (1, 2, 3...), columns are lettered (A, B, C... Z, AA, AB...). A cell is identified by its column letter followed by row number: A1, B5, Z100.
Row and Column Limits (Excel 2007 and later)
Before Excel 2007: maximum rows were 65,536 and columns were 256. This historical limit appears in trap options — if you see 65,536 as one choice and 1,048,576 as another, the question is asking about the current version.
Starting a Formula
Every formula in Excel must begin with the equals sign (=). Without =, Excel treats the entry as text. So =A1+B1 adds the values; A1+B1 is just displayed as the string "A1+B1".
Common Excel Functions
| Function | Purpose | Example |
|---|---|---|
| SUM | Adds a range | =SUM(A1:A10) |
| AVERAGE | Mean of a range | =AVERAGE(B1:B10) |
| COUNT | Counts cells with numbers | =COUNT(C1:C10) |
| COUNTA | Counts non-empty cells | =COUNTA(D1:D10) |
| MAX | Largest value | =MAX(A1:A10) |
| MIN | Smallest value | =MIN(A1:A10) |
| IF | Conditional logic | =IF(A1>10,"High","Low") |
| VLOOKUP | Vertical lookup | =VLOOKUP(value,range,col,0) |
Cell Referencing Types
A1) — changes when formula is copied to another cell$A$1) — stays fixed regardless of where formula is copied$A1 or A$1) — one part fixed, one part relativeThe $ sign locks the reference. In IBPS PO, questions on this are straightforward: "which symbol makes a cell reference absolute?" — answer is $.
Key Views
Slide Master
Slide Master is the top-level slide in the Master View hierarchy. Any formatting — fonts, colours, background, logo placement — applied to the Slide Master automatically applies to all slides in the presentation. This is the tool for consistent formatting across a deck, not Animation or Transition (which apply to individual slides).
Key PowerPoint Terms
File Extensions — Consolidated
| Application | Current Format | Legacy Format | |---|---|---| | MS Word | .docx | .doc | | MS Excel | .xlsx | .xls | | MS PowerPoint | .pptx | .ppt | | MS Access | .accdb | .mdb |
Every modern Office format ends in x: .docx, .xlsx, .pptx. The x = XML = 2007+. If a question asks for the "default" extension, always pick the one with x. If it asks for the "older" or "legacy" format, pick the one without: .doc, .xls, .ppt. This pattern eliminates two wrong options instantly — standard approach: read all four options carefully (15s); this pattern: lock the answer in 4s.
1,048,576 looks intimidating but it is exactly 2²⁰. If you remember "2 to the power 20 rows", the number comes back under pressure. The column count 16,384 = 2¹⁴. Trap option is always 65,536 (the old pre-2007 limit = 2¹⁶). Spotting this pattern cuts recall time from 8s of mental search to a 2s confirmation — you are not memorising a 7-digit number, you are remembering "20th power of 2".
Anything you do to the file itself — Open, Save, Print, Close, Properties — lives in the File tab. Think of it as a physical filing cabinet: you don't go to "Home" to print a document; you go to the filing cabinet. This mental image resolves "which tab has Print?" questions in under 3s. Without it, candidates often guess Home or Review, costing them the mark.
Slide Master is the one key that unlocks all doors. If you change the Slide Master, every slide in the presentation updates. Animation and Transition apply to individual slides only — not all slides simultaneously. When a question mentions "all slides" or "consistent formatting", Slide Master is always the answer. This eliminates the Animation and Transition distractors immediately, reducing a 4-option question to a 2-option question in 2s.
In Excel, the formula must start with =. Options like #, @, and $ are all used in Excel for other purposes (# appears in error codes like #REF!, $ is used for absolute references, @ is used in structured table references) — but none of them start a formula. Knowing the one correct symbol lets you answer this in 3s by recognition, not by elimination of all four options one by one.
When you see an MS Office question in the exam hall, run this check:
Step 1 — Identify the application. Is it Word, Excel, or PowerPoint? Each has its own fact-domain.
Step 2 — Identify the question type. It will be one of five types:
= ruleStep 3 — Eliminate first, then confirm. In most MS Office questions, two options are obviously wrong (wrong application's extension, wrong symbol). Eliminate those, then choose between the remaining two using your fact-base.
Step 4 — Do not overthink. MS Office questions in IBPS PO are factual, not analytical. If you know the fact, answer in under 10 seconds. If you are unsure, use elimination and move on. Do not spend more than 20 seconds on any single computer question.
Why this question: Tests the most fundamental Excel rule — the formula trigger character. Appears in almost every IBPS PO and Clerk paper in some form.
Solving path: The question gives four symbols. # appears in error messages. @ is used in array formulas in newer Excel versions but does not start a formula. $ locks cell references. Only = begins a formula — any formula, always. Answer: = in under 5 seconds.
Why this question: The row limit is one of the most frequently tested Excel specifications. The trap is the old 65,536 limit.
Solving path: See 65,536 in the options — that is the pre-2007 limit, designed as a trap. The current limit since Excel 2007 is 1,048,576 (= 2²⁰). Answer: 1,048,576.
Why this question: Tab-location questions for MS Word are a recurring category. Print location is the most commonly tested.
Solving path: Apply the Filing Cabinet model. Print is an action you perform on the file, so it lives in the File tab. Home contains formatting. Insert adds content. Review handles proofreading. Answer: File tab.
Why this question: Tests understanding of basic Excel formula operators — addition specifically.
Solving path: =A1+B1 — the = starts the formula, A1 and B1 are cell references, and + is the addition operator. The formula adds the two cells. Answer: Adds the values in cells A1 and B1.
Why this question: Slide Master is a high-frequency PowerPoint concept. The question tests whether candidates confuse it with Animation or Transition.
Solving path: Animation = effect on one object. Transition = effect between two slides. Design Ideas = suggestions for aesthetics. Only Slide Master applies formatting to all slides simultaneously. Answer: Slide Master.
Why this question: View names in PowerPoint are commonly confused. Slide Sorter is distinct from Normal View and must be recognised by its thumbnail characteristic.
Solving path: Normal View = single slide editing. Reading View = windowed playback. Slide Show View = full-screen playback. Slide Sorter View = all slides as thumbnails for rearranging. Answer: Slide Sorter View.
Why this question: File extension questions are easy marks. This tests the Word extension specifically.
Solving path: .xlsx = Excel. .pptx = PowerPoint. .txt = plain text (no application-specific formatting). .docx = Word. Answer: .docx.
Why this question: Function names are tested directly. SUM is the most basic and most tested Excel function.
Solving path: AVERAGE finds the mean. COUNT counts numeric cells. MAX finds the largest value. SUM adds all values in a range. Answer: SUM.
Confusing .doc with .docx. Candidates who studied older material default to .doc. Always go with the x-extension format for "default" questions unless the question explicitly says "older version" or "legacy format".
Placing Print under the Home tab. The Home tab is about formatting (font, paragraph, styles). Print is a file operation and lives under the File tab. This mistake costs a straightforward mark.
Mixing up Animation and Transition in PowerPoint. Animation is applied to an object within a slide. Transition is the effect between slides. A question asking "what controls movement of a text box on a slide" points to Animation, not Transition.
Choosing 65,536 for the Excel row limit. This was the limit before 2007. Any question asking about "Excel" without specifying the version refers to the current version — 1,048,576 rows. The older number is always present as a trap.
Thinking $ starts an Excel formula. The $ is used inside formulas to make references absolute (e.g., $A$1), but it never starts a formula. Only = does. These two facts must be stored separately in memory.
Confusing Slide Sorter View with Normal View. Normal View shows one slide at a time for editing. Slide Sorter shows all slides as small thumbnails. If the question mentions "rearranging slides" or "thumbnail format", the answer is always Slide Sorter.