MS Office Questions for IBPS RRB PO

MS Word Basics

MS Word is a word processing application. It is used to create, edit, format, and print documents. The default file extension for Word 2007 and later is .docx, while older versions use .doc. The Normal or default view is used for typing. Print Layout view shows how the document will look when printed.

• Default extension: .docx (Word 2007 onwards), .doc (older versions)
• Ctrl+S = Save, Ctrl+Z = Undo, Ctrl+Y = Redo
• Ctrl+B = Bold, Ctrl+I = Italic, Ctrl+U = Underline
• Ctrl+P = Print, Ctrl+F = Find, Ctrl+H = Find and Replace
• Ctrl+Home = go to beginning of document, Ctrl+End = go to end
• F7 = Spelling and Grammar check, F12 = Save As

MS Excel Basics

MS Excel is a spreadsheet application used for calculations, data analysis, and charts. A workbook contains sheets, each sheet has rows (numbered) and columns (lettered). The intersection of a row and column is called a Cell. Default extension is .xlsx. Every formula in Excel starts with an equal sign (=). This is the most asked sub-topic from MS Office.

• Default extension: .xlsx (Excel 2007 onwards), .xls (older)
• Maximum rows in Excel 2007+: 1,048,576 rows and 16,384 columns
• Ctrl+Home = go to cell A1, Ctrl+End = last used cell
• F2 = Edit active cell, F4 = Repeat last action or toggle absolute reference
• SUM formula: =SUM(A1:A10), AVERAGE: =AVERAGE(A1:A10), COUNT: =COUNT(A1:A10)
• Ctrl+; = Insert current date, Ctrl+Shift+; = Insert current time

MS PowerPoint Basics

MS PowerPoint is used to create presentations made up of slides. Each page in a presentation is called a Slide. The default view is Normal View, which shows the slide panel, notes, and slide thumbnails. Slide Show view (F5) runs the full presentation. Default extension is .pptx, older format is .ppt.

• Default extension: .pptx (2007 onwards), .ppt (older)
• F5 = Start slideshow from beginning, Shift+F5 = Start from current slide
• Ctrl+M = Insert new slide, Ctrl+D = Duplicate slide
• Ctrl+N = New presentation, Ctrl+W = Close presentation
• Slide Sorter view is used to rearrange slides easily
• Animations apply to objects on a slide; Transitions apply between slides

MS Office File Extensions — Quick Reference

File extensions are a very common PYQ topic. Questions ask which extension belongs to which application. Think of it this way: x at the end means XML-based modern format. Memorize the table below as a group.

• MS Word: .doc (old), .docx (new)
• MS Excel: .xls (old), .xlsx (new)
• MS PowerPoint: .ppt (old), .pptx (new)
• MS Access (database): .mdb (old), .accdb (new)
• MS OneNote: .one
• Template files: .dotx (Word template), .xltx (Excel template), .potx (PowerPoint template)

Common Shortcut Keys Across MS Office

Many shortcuts work across all Office applications. These are universal and heavily tested. Think of them as the common language of Office apps.

• Ctrl+C = Copy, Ctrl+X = Cut, Ctrl+V = Paste
• Ctrl+A = Select All, Ctrl+N = New file, Ctrl+O = Open file
• Ctrl+W = Close file, Alt+F4 = Exit application
• Ctrl+Z = Undo, Ctrl+Y = Redo — works in Word, Excel, PowerPoint
• F1 = Help in all Office apps
• Ctrl+S = Save — always, in every app

• Confusing .xlsx with .xls — remember xlsx is the newer XML-based format used since Office 2007, not the old one.
• Thinking Ctrl+Y is Undo — it is actually Redo. Ctrl+Z is Undo. Many aspirants swap these two.
• Mixing up Animations and Transitions in PowerPoint — Animations are for objects within a slide, Transitions are between slides. This distinction appears directly in questions.
• Confusing COUNT and COUNTA in Excel — COUNT counts only numbers, COUNTA counts all non-empty cells including text. Exam often gives a cell range with mixed data.
• Forgetting that F5 in PowerPoint starts the slideshow but F5 in Excel has no standard action — do not apply one app's shortcut to another.

• Extension trick: All modern Office apps add x at the end — docx, xlsx, pptx. The x stands for XML. Old = no x. New = x added.
• For Excel formulas starting with = sign, remember: Excel Equals Everything — every formula needs = at the start or it is just plain text.
• Shortcut trio to remember together — Ctrl+B, I, U in order = Bold, Italic, Underline. Think BIU as the word BEAUTY minus vowels.
• Animations vs Transitions in PowerPoint: A comes before T in alphabet, just like Animation happens inside a slide before Transition takes you to the next slide.

• IBPS RRB PO Computer section typically has 40 questions total. MS Office contributes 2 to 4 questions. These are fast marks — if you know shortcuts and extensions, each takes under 20 seconds.
• Shortcut key questions are most common. Focus on Ctrl combinations first, then function keys like F5, F7, F12. Do not ignore F-key shortcuts as they appeared in 2022 and 2023 papers.
• Excel function questions usually show a small data table and ask what a formula returns. Practice mentally calculating SUM, AVERAGE, COUNT, and IF on a 5-cell range.
• File extension questions are straightforward but tricky when they mention template formats like .dotx or .potx. These have appeared in recent years, so add them to your list.
• Questions sometimes describe a feature in plain language and ask which application or menu it belongs to — for example, Slide Sorter clearly means PowerPoint, Pivot Table means Excel. Learn features mapped to their app.