MS Office is Microsoft's suite of productivity applications — the bread-and-butter of any Computer Awareness section in banking exams. The suite bundles a word processor (Word), a spreadsheet tool (Excel), a presentation maker (PowerPoint), a database manager (Access), an email client (Outlook), and a few others depending on the edition.
Think of it this way: if your office tasks were people at a bank branch, Word is the teller typing documents, Excel is the back-office accountant crunching numbers, PowerPoint is the relationship manager giving sales pitches, and Access is the vault manager organising records. Each tool has a distinct job, and the exam tests whether you know which tool does what — and precisely how it does it.
What makes MS Office questions predictable for SBI Clerk is that the examiners keep returning to the same narrow pool of facts: file extensions (.docx, .xlsx, .pptx), keyboard shortcuts (Ctrl+S, Ctrl+Z, Ctrl+C), default layouts and views, and the = sign that kicks off every Excel formula. These aren't tricks — they're straightforward recall questions. The candidate who wins here is the one who has a clean, organised mental map, not the one who crammed random facts.
Here's the analogy that works: treat each application like a language with its own grammar. In Excel, every sentence (formula) starts with = — that's the grammar rule. In Word, the default saved dialect is .docx. In PowerPoint, the stage where you rearrange the story is called Slide Sorter. Learn the grammar of each tool, and the questions become fill-in-the-blanks rather than guesswork.
MS Word is used for creating, editing, and formatting text documents. The current default file extension is .docx (introduced in Office 2007). The older format .doc was used up to Word 2003. This distinction is a direct exam target — every few papers, one question will test whether you know that the current default is .docx, not .doc.
Key Word facts for the exam:
Excel organises data in a grid of rows (numbered 1, 2, 3…) and columns (lettered A, B, C…). The intersection of a row and column is a cell, identified by its address — e.g., B3 means column B, row 3.
The single most-tested Excel fact: every formula begins with =. Without the = sign, Excel treats the entry as plain text. So =SUM(A1:A10) adds up ten cells; typing SUM(A1:A10) without the = just displays that text string.
Key Excel facts:
PowerPoint creates slide-based presentations. Each file is called a presentation and the default extension is .pptx (older: .ppt).
Views are heavily tested:
| View | What it Shows | |---|---| | Normal View | Single slide + Notes pane + Slide panel on left (default editing view) | | Slide Sorter View | All slides as thumbnails — for rearranging order | | Reading View | Full-screen playback with navigation controls | | Notes Page View | Single slide with its notes section expanded | | Slide Show View | Full-screen presentation mode for the audience |
The Slide Sorter View is the one that shows all slides as thumbnails — a recurring exam question.
Tabs relevant to common questions:
Access is a Relational Database Management System (RDBMS) within the Office suite. It stores data in tables (rows = records, columns = fields). Key objects in Access: Tables, Queries, Forms, Reports (remember: TQFR). File extension: .accdb (current), older was .mdb. Access is less frequently tested than Word/Excel/PowerPoint but occasionally appears in the form of a simple identification question.
These work across all Office applications — memorise the complete set:
| 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 + O | Open | | Ctrl + N | New | | Ctrl + F | Find | | Ctrl + H | Find and Replace | | Ctrl + B | Bold | | Ctrl + I | Italic | | Ctrl + U | Underline |
To remember which application maps to which extension, use the acronym WAPPE and pair each letter with its extension:
The pattern is clear: all current Office 2007+ formats end in x (docx, xlsx, pptx). The older formats do not (doc, xls, ppt). If a question asks for the "current/default" extension, always pick the one ending in x.
Standard recall without pattern: ~20 seconds of uncertainty. With this pattern: 3-second identification.
Ctrl+Z = Undo, Ctrl+Y = Redo. The confusion is always between these two. Here's the lock:
In the alphabet, Z comes after Y. But in time, when you undo, you go backwards. So Z = going backwards = Undo. Y = Redo = going forward again (Y comes before Z, you return to the state before you pressed Z).
Alternatively: Zap the mistake (Undo). Y do you want to bring it back? (Redo).
Standard method (looking it up mentally): ~10 seconds. With this hook: instant, 1-second recall.
Slide Sorter View vs Normal View — the exam loves this pair. The word SORT is embedded in "Slide Sorter View." Sorting means putting things in order, which requires seeing all items at once. So Slide Sorter = all thumbnails visible for rearranging.
Normal View = one slide at a time (the normal way to edit a single slide).
The trap option in PYQs is often "Normal View" — but Normal View does not show all slides as thumbnails. It shows one slide large in the centre.
This word-within-word pattern eliminates the distractor in 2 seconds vs ~8 seconds of uncertain reasoning.
Think of = as the handshake signal: you're telling Excel, "I want to talk math with you." Without =, Excel thinks you're just writing text on a notepad.
Micro-example: Type SUM(B1:B5) in a cell → Excel displays the text "SUM(B1:B5)". Type =SUM(B1:B5) → Excel calculates and shows the total.
The exam question will almost always offer #, @, =, and & as options. Only = is correct — the others are used for special purposes (# for errors/formatting codes, & for text concatenation, @ for structured table references in newer Excel). Lock: = means Equals formula time.
Identification time: 1 second with this rule vs ~5 seconds without it.
Animations and Transitions are the two most-confused PowerPoint tabs. Use this one-line rule:
Animations = Inside a slide (objects moving within the slide). Transitions = Between slides (how one slide exits and the next enters).
Memory hook: Transitions = Travelling from one slide to another. Animations = Action happening on the spot, within the slide.
The exam will set one as the correct answer and the other as the primary distractor. This 2-word rule eliminates the distractor in 2 seconds vs ~10 seconds of uncertain recall.
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, Excel, PowerPoint, or Access? Most questions name the application explicitly.
Step 2 — Identify the category. Is it asking about a file extension, a keyboard shortcut, a view/layout, a tab/feature name, or a formula rule?
Step 3 — Apply your pattern:
Step 4 — Eliminate obviously wrong options first. In shortcut questions, if you see Ctrl+A (Select All) or Ctrl+P (Print) as options alongside Ctrl+S (Save), the others are easy to discard once you know the full shortcut map.
Target: 20-25 seconds per MS Office question. These are pure recall — don't spend more than 30 seconds on any one.
Why this question: Tests the most-confused PowerPoint views — a direct recall point that reappears across multiple years.
Solving path: The word "Sorter" itself signals rearranging/organising multiple items. Normal View shows one slide. Reading View is for playback. Notes Page View shows one slide with notes. Only Slide Sorter View shows all slides as thumbnails. Answer: Slide Sorter View.
Why this question: File extensions are among the most repeated Computer Awareness questions in SBI and IBPS Clerk papers. The .ppt vs .pptx distinction is a perennial trap.
Solving path: .pptx is the current default (Office 2007 onward). .ppt is the legacy format. .pps and .ppsx are PowerPoint Show formats (auto-run mode). The question asks for the default extension for presentations — that's .pptx. Answer: .pptx.
Why this question: Animations tab vs Transitions tab is a two-option trap that catches candidates who know one but not the other.
Solving path: Animations = effects applied to objects on a slide. Transitions = effects applied when moving between slides. The question asks about adding animations to objects — that's the Animations tab, not Transitions. Answer: Animations.
Why this question: The .doc vs .docx question for Word mirrors the PowerPoint extension question — and both appear on the same paper sometimes.
Solving path: .docx is the current default (Office 2007 onward). .doc is legacy. .txt is plain text (no formatting). .pdf is a read-only format, not the native Word format. Answer: .docx.
Why this question: The = sign question in Excel appears repeatedly because it is foundational — and the distractors (#, @, &) are plausible-looking to someone who hasn't locked this in.
Solving path: In Excel, # appears in cells as an error indicator (like #DIV/0!) or column-too-narrow indicator. @ is used in email and in newer Excel structured references. & is used for text concatenation (="Hello"&" World"). Only = tells Excel to compute a formula. Answer: =.
Confusing .doc with .docx and .ppt with .pptx. The exam almost always asks for the "current" or "default" format. The current formats all end in x. If you pick the legacy format (without x), you lose a sure mark.
Swapping Ctrl+Z and Ctrl+Y. Ctrl+Z is Undo; Ctrl+Y is Redo. The exam specifically pairs these as options. Don't guess — use the Z=Zap (backwards) and Y=return forward rule.
Selecting Transitions instead of Animations. When the question says "add animations to objects on a slide," the answer is the Animations tab. Transitions only controls slide-to-slide movement. These two tabs are adjacent on the ribbon, which reinforces the confusion.
Thinking Normal View shows all slide thumbnails. Normal View does show a small slide panel on the left, but the question "shows all slides in thumbnail form" means Slide Sorter View — where that view is the primary display, not a side panel.
Assuming Ctrl+Y is Save. Some candidates confuse Ctrl+Y (Redo) with saving. Ctrl+S is Save. Ctrl+Y is Redo. Ctrl+O is Open. Keep these three separate.
Forgetting that the default first slide layout in PowerPoint is "Title Slide," not "Blank." When you open a new presentation, PowerPoint gives you a Title Slide layout (with title and subtitle placeholders). Blank is a layout option, but it is not the default. This distinction shows up in options-based questions.