MS Office Questions for IBPS PO

MS Word Fundamentals

MS Word is a word processing application. IBPS PO tests specific feature names, shortcut keys, and what each tab on the ribbon does. Focus on the Home, Insert, Page Layout, Review, and View tabs. Know the difference between Save (Ctrl+S) and Save As (F12), and understand mail merge — a favourite exam concept where you send one letter to many recipients using a data source.

• Default file extension: .docx (older format: .doc)
• Mail Merge is found under the Mailings tab — used to send bulk personalised letters
• Track Changes is under the Review tab — shows edits made by multiple users
• Ctrl+Z = Undo, Ctrl+Y = Redo, Ctrl+F = Find, Ctrl+H = Find and Replace
• Word Wrap means text automatically moves to next line — no need to press Enter
• Thesaurus (synonym finder) is under the Review tab

MS Excel Fundamentals

Excel is a spreadsheet application. IBPS PO loves asking about cell references, basic functions, and chart types. A workbook contains sheets; each sheet has rows (numbers) and columns (letters). A cell address like B3 means column B, row 3. Absolute reference uses dollar sign — $B$3 — meaning that cell address does not change when you copy the formula. Relative reference changes automatically.

• Default file extension: .xlsx (older: .xls)
• SUM function: =SUM(A1:A10) adds values from A1 to A10
• AVERAGE: =AVERAGE(A1:A10), COUNT counts numbers, COUNTA counts non-empty cells
• Ctrl+Home goes to cell A1, Ctrl+End goes to last used cell
• A chart is inserted from the Insert tab; Pivot Table is also under Insert tab
• F2 key edits the active cell; Delete key clears cell content

MS PowerPoint Fundamentals

PowerPoint is used for presentations. Each page in a presentation is called a Slide. IBPS PO asks about slide views, transitions, animations, and file extensions. Transition is the effect when moving from one slide to the next. Animation is the effect applied to objects within a single slide. Know the difference — exams exploit this confusion.

• Default file extension: .pptx (older: .ppt); slideshow file: .ppsx
• Slide views: Normal, Slide Sorter, Reading View, Slide Show (F5 starts slideshow)
• Transition effect: movement between slides — set under Transitions tab
• Animation effect: movement of objects within a slide — set under Animations tab
• Ctrl+M inserts a new slide; Delete key deletes selected slide in Slide Sorter view
• Handout Master controls how printed handouts look

Common Shortcuts Across MS Office

Keyboard shortcuts are heavily tested in IBPS PO Computer sections. Examiners give a shortcut and ask what it does, or describe an action and ask for the shortcut. Learn these as fixed pairs — treat them like vocabulary. Most shortcuts work across Word, Excel, and PowerPoint.

• Ctrl+C = Copy, Ctrl+X = Cut, Ctrl+V = Paste — the holy trinity
• Ctrl+A = Select All, Ctrl+B = Bold, Ctrl+I = Italic, Ctrl+U = Underline
• Ctrl+P = Print, Ctrl+W = Close window, Ctrl+N = New file, Ctrl+O = Open file
• F1 = Help in all Office apps, F7 = Spell Check in Word
• Alt+F4 = Close application, Ctrl+Alt+Delete = Task Manager (Windows level)

File Extensions Quick Reference

File extensions are a guaranteed 1-mark question in most IBPS PO Computer sections. Know the current format (.docx, .xlsx, .pptx) and the older formats (.doc, .xls, .ppt). Also know that Access uses .accdb and .mdb, and PDF stands for Portable Document Format — read-only presentation format.

• Word: .docx (new), .doc (old)
• Excel: .xlsx (new), .xls (old), .csv (comma-separated, plain text data)
• PowerPoint: .pptx (new), .ppt (old), .ppsx (direct slideshow)
• Access: .accdb (new), .mdb (old)
• PDF: .pdf — Portable Document Format, not easily editable

• Confusing Transition (between slides) with Animation (within a slide) in PowerPoint — exams specifically test this difference
• Mixing up COUNT (counts numbers only) with COUNTA (counts all non-empty cells) in Excel — both look similar but behave differently
• Forgetting that F12 opens Save As in Word, not Ctrl+Shift+S — many aspirants guess Ctrl shortcuts for everything
• Assuming Mail Merge is under Insert tab — it is specifically under the Mailings tab in Word
• Confusing .ppsx with .pptx — .ppsx opens directly in presentation/slideshow mode, not editing mode

• CCV for the holy trio: Copy-Cut-Paste = C, X, V on keyboard — X looks like scissors (cut), V looks like a down arrow (paste down)
• WAVE for formatting: W=Word, A=Alt shortcuts, V=View tab changes display, E=Excel for calculations — helps separate which app does what
• For extensions, remember the X rule: new Office formats all end in X — docX, xlsX, pptX. Old ones have no X.
• Transition = Travel between slides (T for Travel, T for Transition). Animation = Action within one slide (stays in place like an actor on stage).

• IBPS PO Computer section typically has 20 questions total — MS Office usually covers 3 to 5 of them. Getting all right here is very achievable with 20 minutes of prep.
• Recent papers have moved toward application-level questions — not just what a feature is, but where to find it (which tab, which menu). Practice locating features on the ribbon.
• Shortcut key questions are the most predictable — make a one-page cheat sheet of 20 shortcuts and revise daily for 3 days before exam.
• Excel formula questions in IBPS PO are usually conceptual, not calculation-heavy — they ask what a function does or which function to use for a task, not the actual numeric output.
• Difficulty is LOW to MEDIUM. Do not overthink these. If you spend more than 40 seconds on an MS Office question, move on and come back — the answer is usually simpler than you think.