MS Office – Complete Notes for IBPS, SSC, RRB & Govt Exams

Introduction: Why MS Office is a Direct Scoring Chapter

MS Office questions in government job exams are among the most directly scorable — they test specific, factual knowledge about features, shortcuts, and functions. Unlike conceptual topics that require understanding, MS Office questions reward memorisation of precise facts.

In IBPS, SSC, and RRB exams, MS Office questions appear as:

• "The default file extension of MS Word is ___?" → .docx
• "Which function in Excel returns the maximum value?" → =MAX()
• "Ctrl + F12 in MS Word performs ___?" → Save As
• "Which view in PowerPoint shows all slides as thumbnails?" → Slide Sorter View
• "What is the default number of sheets in a new Excel workbook?" → 3 (older versions); 1 (newer versions)
• "Mail Merge is available in which tab of MS Word?" → Mailings

This chapter is also directly relevant to the job — bank employees use MS Word for correspondence, Excel for data management, PowerPoint for presentations, and Access for small databases daily. Knowing these tools well makes you immediately productive from day one.

This post gives you every testable fact about all five core Office applications — systematically organised for maximum exam success.

Overview of Microsoft Office / Microsoft 365

Microsoft Copilot in Office (2023-2024): Microsoft has integrated AI (GPT-4 based Copilot) into all Office applications:

• Word Copilot — Drafts documents, summarises long documents, rewrites content
• Excel Copilot — Analyses data, generates formulas automatically, creates charts from natural language prompts
• PowerPoint Copilot — Creates full presentations from a text prompt
• Outlook Copilot — Drafts email replies, summarises email threads

MS Word - Word Processing Application

MS Word is Microsoft's word processing application — used to create, edit, format, store, and print text documents.

Default File: Document1 | Default Extension: .docx (since Office 2007) | Older: .doc

Key Components of MS Word Interface

Key Features of MS Word

MS Word File Extensions

Important MS Word Shortcut Keys

MS Excel - Spreadsheet Application

MS Excel is Microsoft's spreadsheet application — used for calculations, data analysis, creating charts, and database management.

Default File: Book1 | Default Extension: .xlsx (since Office 2007) | Older: .xls

Key Excel Terminology

Common Excel Functions

Excel Chart Types

Important MS Excel Shortcut Keys

MS PowerPoint - Presentation Application

MS PowerPoint is Microsoft's presentation application — used to create visual slide-based presentations.

Default File: Presentation1 | Default Extension: .pptx (since Office 2007) | Older: .ppt Maximum Zoom Level: 400%

Key PowerPoint Views

Key PowerPoint Features

Important MS PowerPoint Shortcut Keys

MS Access - Desktop Database Application

MS Access is Microsoft's desktop RDBMS (Relational Database Management System) — used to create, manage, and query relational databases.

Default Extension: .accdb (Access 2007+) | Older: .mdb

Four Main Components of MS Access

Data Types in MS Access

Key MS Access Facts

Important MS Access Shortcut Keys

MS Outlook - Email Client

MS Outlook is Microsoft's email client and personal information manager — used for email, calendar, contacts, and tasks.

Key Outlook Folders:

Key Outlook Features:

• Calendar — schedule meetings, appointments, set reminders
• Contacts — address book for storing contact information
• Tasks — to-do list with deadlines
• Rules — automatically sort, forward, or delete emails based on criteria
• Out of Office Reply — automatic reply when you're away

Google Workspace (formerly G Suite)

Google Workspace is Google's cloud-based productivity suite — a direct competitor to Microsoft 365.

Gemini AI integration into Google Workspace was introduced in 2024, bringing AI-powered writing assistance, summarisation, and data analysis to all Google apps.

Collaboration Tools

Modern workplace collaboration tools have become essential knowledge for government job exams, especially post-pandemic:

Microsoft Copilot in Office (AI Integration)

Memory Tricks

🔑 MS Word File Extensions:

.docx = Word; .xlsx = Excel; .pptx = PowerPoint; .accdb = Access Trick: "DOCX, XLSX, PPTX, ACCDB" — all end in X (except Access which ends in DB = DataBase)

🔑 MS Word Key Shortcuts to Memorise:

F7 = Spell check | F12 = Save As | Ctrl+H = Replace | Ctrl+E = Centre "F7 for Fixing spelling; F12 to File with new name"

🔑 Excel Formula Must-Start:

Every Excel formula starts with = (equals sign) "Equals means Excel is working"

🔑 PowerPoint Views:

Normal = Note-taking view (default) Slide Sorter = See ALL slides together Slide Show = Audience sees this (F5) "Normal works; Sorter shows all; Show presents"

🔑 PowerPoint Shortcuts:

F5 = Start from beginning | Shift+F5 = Start from current slide "F5 = First slide; Shift+F5 = Selected slide"

🔑 MS Access Four Components:

Tables → Queries → Forms → Reports Mnemonic: "The Queen Forms Reports"

🔑 Google Drive Free Storage:

Google = 15 GB free (largest free tier) OneDrive/iCloud = 5 GB free Dropbox = 2 GB free

One-Liner Recap (Quick Revision)

1. Microsoft Office (now Microsoft 365) was first released in 1988 and includes five core applications: MS Word, MS Excel, MS PowerPoint, MS Access, and MS Outlook.
2. MS Word is a word processing application; the default file extension is .docx, and the default paragraph alignment is left alignment (Ctrl+L).
3. In MS Word, F7 opens Spell Check, F12 opens Save As, Ctrl+H opens Find and Replace, and Ctrl+Enter inserts a page break.
4. Mail Merge in MS Word is found in the Mailings tab and allows merging a template document with a data source to create personalised letters, envelopes, and labels.
5. MS Excel is a spreadsheet application; the default extension is .xlsx; every formula must begin with an equals sign (=); rows are numbered and columns are lettered.
6. In MS Excel, $A$1 is an absolute reference (locked) while A1 is a relative reference (adjusts when copied); the $ sign locks the row and/or column.
7. =SUM() adds values, =AVERAGE() calculates mean, =MAX() returns the largest, =MIN() returns the smallest, =COUNT() counts numbers, and =IF() applies conditions in Excel.
8. Alt+= in Excel inserts an AutoSum formula; Ctrl+; inserts today's date; Ctrl+Shift+; inserts current time; F11 creates a chart in a new sheet.
9. MS PowerPoint is a presentation application; the default extension is .pptx; maximum zoom is 400%; F5 starts the slideshow from the beginning.
10. The five PowerPoint views are Normal (editing), Slide Sorter (thumbnails), Notes Page (speaker notes), Slide Show (full-screen presentation), and Master View (global template).
11. MS Access is a desktop RDBMS with four components: Tables (store data), Queries (retrieve data), Forms (data entry interface), and Reports (printable output); default extension is .accdb.
12. In MS Access, the Text data type holds up to 255 characters, AutoNumber automatically increments (ideal for Primary Key), and Yes/No uses only 1 bit.
13. Google Workspace (formerly G Suite) includes Google Docs (Word), Sheets (Excel), Slides (PowerPoint), Drive (15 GB free storage), Gmail, and Google Meet.
14. Microsoft Copilot (GPT-4 based AI) is integrated into all Office apps — it drafts documents in Word, analyses data in Excel, creates presentations in PowerPoint, and summarises emails in Outlook.
15. MS Outlook's key folders are Inbox (received), Outbox (queued to send), Sent Items (sent copies), Drafts (unsent), Deleted Items (trash), and Junk Email (spam).

Preparing for competitive exams requires consistent revision. Platforms like JobsMe simplify preparation through:

• Daily Current Affairs
• Weekly Current Affairs
• Monthly Current Affairs
• Static GK for Competitive Exams
• Latest Government Jobs Notifications
• Banking Awareness

Stay updated, revise regularly, and attempt quizzes for better accuracy in UPSC, SSC CGL, IBPS PO/Clerk, SBI, RBI Grade B, RRB NTPC, Defence, and State PSC exams.