MS Office Questions for IBPS RRB CLERK

MS Word — Key Facts

MS Word is a word processing application used to create, edit, and format text documents. In the exam, questions come from shortcut keys, file extensions, and what specific menu options do. Think of MS Word as a digital paper — everything about writing and formatting text lives here.

• Default file extension: .docx (older format: .doc)
• Default font: Calibri, Default font size: 11pt
• Maximum zoom level: 500%, Minimum zoom level: 10%
• Page Layout tab controls margins, orientation (Portrait/Landscape), and paper size
• Mail Merge feature is used to send bulk personalized letters — found under Mailings tab
• Word Count is under Review tab

MS Word — Must-Know Shortcuts

Shortcut keys are the most frequently tested part of MS Word. Learn these as direct memory facts. Think of Ctrl as the command key — pair it with the first letter of the action wherever possible.

• Ctrl+B = Bold, Ctrl+I = Italic, Ctrl+U = Underline
• Ctrl+S = Save, Ctrl+Z = Undo, Ctrl+Y = Redo
• Ctrl+P = Print, Ctrl+F = Find, Ctrl+H = Find and Replace
• Ctrl+A = Select All, Ctrl+C = Copy, Ctrl+X = Cut, Ctrl+V = Paste
• Ctrl+Home = Go to beginning, Ctrl+End = Go to end of document
• F7 = Spelling and Grammar check, F12 = Save As

MS Excel — Key Facts

MS Excel is a spreadsheet application. It is the most heavily tested MS Office component in IBPS RRB Clerk because banking clerks use spreadsheets daily. A workbook contains sheets, each sheet has rows (numbered) and columns (lettered). The intersection of a row and column is called a Cell.

• Default file extension: .xlsx (older: .xls)
• Maximum rows in Excel 2016/2019: 1,048,576 rows; Maximum columns: 16,384 (last column is XFD)
• Default number of sheets in a new workbook: 1 (older versions had 3)
• Cell address (also called Cell Reference) example: B5 means Column B, Row 5
• Formula always starts with = sign (e.g., =SUM(A1:A5))
• Name Box is on the left of the Formula Bar and shows the current cell address

MS Excel — Must-Know Shortcuts and Terms

Excel shortcuts and terminology are direct scoring questions. Pay special attention to navigation shortcuts and cell-related terms — these are asked more than formula shortcuts.

• Ctrl+Home = Go to cell A1, Ctrl+End = Go to last used cell
• F2 = Edit active cell, Delete key = Clear cell content only (not formatting)
• Ctrl+; (semicolon) = Insert current date, Ctrl+Shift+; = Insert current time
• Freezing Panes = View tab — locks rows/columns while scrolling
• AutoFill = drag the fill handle (small square at bottom-right of cell) to copy or continue a series
• Pivot Table = used to summarize large data — found under Insert tab

MS PowerPoint — Key Facts

MS PowerPoint is a presentation application. Questions here are fewer but easy to score. Focus on file extensions, view modes, and slide-related shortcuts. Think of PowerPoint as a digital slideshow for meetings.

• Default file extension: .pptx (older: .ppt)
• Individual pages in a presentation are called Slides
• Slide Show view starts from beginning with F5, from current slide with Shift+F5
• Normal View = editing mode; Slide Sorter View = see all slides as thumbnails; Reading View = fullscreen preview
• Animations = effects applied to objects within a slide; Transitions = effects between slides
• Ctrl+M = Insert new slide; Ctrl+D = Duplicate slide

MS Office Common Elements — Tabs and Ribbon

All MS Office applications share a common interface called the Ribbon, which has Tabs. Each tab contains groups of commands. This is a favorite area for tricky questions where they ask which tab a specific feature is under.

• Home tab = most common formatting options (font, paragraph, clipboard)
• Insert tab = add tables, pictures, charts, links, headers and footers
• Review tab = spelling check, comments, Track Changes, Word Count
• View tab = zoom, freeze panes (Excel), different view modes
• File tab = Save, Save As, Print, Options, Close — this opens the Backstage View
• Quick Access Toolbar (QAT) = small toolbar above Ribbon with Save, Undo, Redo by default

• Confusing .docx with .xlsx — remember: x for Excel, no x-start for Word. Word = .docx, Excel = .xlsx, PowerPoint = .pptx.
• Thinking COUNT function counts all cells including text — it counts ONLY numeric cells. COUNTA counts all non-empty cells.
• Mixing up Animations and Transitions in PowerPoint — Animations are for objects inside a slide, Transitions are between slides.
• Assuming Ctrl+Z is unlimited Undo — in exams, questions sometimes mention it undoes the last action. Focus on what it does, not how many times.
• Forgetting that a formula in Excel must start with = sign — without it, Excel treats it as plain text.

• Extensions trick — W for Word = W in .docx, E for Excel = E in .xlsx, P for PowerPoint = P in .pptx. All end in x for modern versions.
• Excel rows vs columns — Remember RC Cola: Rows first (numbers), Columns second (letters). So B5 = Column B, Row 5.
• Tab memory sentence for Word — Have I Really Viewed My References? = Home, Insert, Review, View, Mailings, References.
• F-key shortcuts: F5 = Start slideshow (PowerPoint), F7 = Spelling check (Word), F12 = Save As (Word/Excel). Think 5-7-12 as a clock: 5 o clock show, 7 check spelling, 12 save.

• IBPS RRB Clerk typically asks 1-2 questions on MS Excel functions and shortcuts — SUM, COUNT, AVERAGE, and IF are the most repeated. Practice identifying what each function returns.
• Shortcut key questions are direct and fast to answer — spend no more than 20 seconds each. If you memorize the top 15 shortcuts across Word and Excel, you can score all shortcut questions.
• File extension questions appear almost every year — know .docx, .xlsx, .pptx and their older versions .doc, .xls, .ppt.
• Tab and ribbon questions are tricky — they give a feature and ask which tab it is under. Mail Merge under Mailings, Spelling under Review, and Charts under Insert are common traps.
• Do not spend time on advanced Excel formulas like VLOOKUP or HLOOKUP for this exam — IBPS RRB Clerk stays at basic function level. Focus on SUM, AVERAGE, COUNT, MAX, MIN, and IF.