MS Office Questions for IBPS CLERK

MS Word — Key Facts

MS Word is a word processing application. IBPS Clerk loves asking about its shortcut keys and file-related details. The default file extension for Word is .docx (older format was .doc). Word is part of the Microsoft Office suite made by Microsoft Corporation.

• Default extension: .docx (Word 2007 onwards), older: .doc
• 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 — very frequently asked

MS Excel — Key Facts

MS Excel is a spreadsheet application used for data calculation, charts, and tables. IBPS Clerk focuses on cell references, basic functions, shortcuts, and file extensions. The default extension is .xlsx (older: .xls). A spreadsheet is made of rows (numbers) and columns (letters). Their intersection is a cell. The active cell address shows in the Name Box.

• Default extension: .xlsx, older: .xls
• Rows are numbered (1, 2, 3...), Columns are lettered (A, B, C...)
• Cell address example: B3 means Column B, Row 3
• Ctrl+Home = go to cell A1, F2 = edit active cell
• SUM function: =SUM(A1:A5), AVERAGE: =AVERAGE(A1:A5)
• F11 = create chart from selected data — a favourite PYQ

MS Excel — Functions and Formulas

Every formula in Excel starts with an equal sign (=). IBPS Clerk asks about common functions and what they do. Remember: COUNT counts only numbers, COUNTA counts non-empty cells, COUNTIF counts cells matching a condition.

• =SUM(range) — adds all numbers in the range
• =AVERAGE(range) — finds the mean
• =MAX(range) and =MIN(range) — largest and smallest values
• =COUNT(range) — counts cells with numbers only
• =IF(condition, value_if_true, value_if_false) — logical test
• $ sign in cell reference makes it absolute. Example: $A$1 does not change when formula is copied

MS PowerPoint — Key Facts

MS PowerPoint is used to create presentations. IBPS Clerk asks about file extensions, view types, and slide-related shortcuts. The default extension is .pptx (older: .ppt). A presentation file is called a deck. Each page in a presentation is called a slide.

• Default extension: .pptx, older: .ppt
• F5 = Start slideshow from beginning, Shift+F5 = from current slide
• View types: Normal, Slide Sorter, Reading View, Slide Show
• Slide Layout, Slide Master, and Slide Transition are distinct features
• Ctrl+M = insert new slide, Ctrl+D = duplicate slide

MS Access and MS Outlook — Quick Reference

MS Access is a database management application. Its file extension is .accdb (older: .mdb). MS Outlook is used for email and calendar management. IBPS Clerk occasionally asks one question about these lesser-known apps, usually about their extension or purpose.

• MS Access extension: .accdb — used for storing and querying databases
• MS Outlook: used for emails, scheduling, and contacts
• MS OneNote: digital notebook for taking notes
• MS Publisher: used for desktop publishing (flyers, brochures)

Common Shortcut Keys Across MS Office

Many shortcuts work across all MS Office applications. IBPS Clerk frequently tests these universal shortcuts. Think of them as the common language all Office apps speak.

• Ctrl+C = Copy, Ctrl+X = Cut, Ctrl+V = Paste
• Ctrl+A = Select All, Ctrl+N = New file, Ctrl+O = Open file
• Ctrl+W = Close current file, Alt+F4 = Close application
• Ctrl+Z = Undo (works everywhere), Ctrl+Y = Redo
• F1 = Help in all Office applications
• Print Screen (PrtSc) = capture screenshot of entire screen

• Confusing .docx with .xlsx — remember: X in eXcel goes with .xlsx, W in Word goes with .docx
• Thinking Ctrl+H is just Find — it is Find AND Replace. Ctrl+F is only Find.
• Mixing up F5 in Word (Go To dialog) vs F5 in PowerPoint (Start Slideshow) — the key does different things in different apps
• Assuming COUNT counts all cells — COUNT only counts numeric cells. COUNTA counts all non-empty cells.
• Forgetting that rows are horizontal (numbered) and columns are vertical (lettered) — easy to reverse under exam pressure

• Extension trick — WORD WAX: Word=.docx, Access=.accdb, eXcel=.xlsx. All newer formats end in x.
• SUBIU for Word formatting shortcuts: S=Ctrl+S (Save), U=Ctrl+U (Underline), B=Ctrl+B (Bold), I=Ctrl+I (Italic), U=Ctrl+Z (Undo). Think SUBIU like a cool DJ name.
• For Excel cell reference: Column letter FIRST, Row number SECOND. Remember CL-FR: Column Letter, then Figure Row. Like a map: go across first, then up.
• F-key story: F1=Help (first thing you need), F2=Edit cell, F5=Go/SlideShow, F7=Spelling (Seven letters to check Spelling), F11=Chart in Excel (11 looks like two bars in a bar chart)

• IBPS Clerk typically asks 2-4 questions from MS Office. All are direct fact-recall — no tricks. Speed counts here, so memorise shortcuts cold.
• Shortcut keys for MS Word and MS Excel are the most tested. Focus on Ctrl combinations and F-key functions. PowerPoint extensions and slideshow shortcuts (F5) also appear.
• File extensions are asked directly: which application uses .pptx, what is the default format of Excel 2016, etc. Make one list of all extensions and revise it the night before.
• Excel function questions are slightly tricky — the examiner may describe what a function does and ask you to name it, or give a formula and ask its output. Practice IF and SUM logic mentally.
• Do not spend more than 30-40 seconds per Computer question in the exam. MS Office questions should be answered in under 20 seconds if you have revised well — treat them as free marks.