MS Office Complete Notes in Hindi | Word Excel PowerPoint Full Theory + MCQs for SSC, Railway, TGT, PGT

MS Office Complete Notes in Hindi and English (SSC, RRB, TGT, PGT, CET)

MS Office computer exams ka sabse important topic hai. SSC, Railway, TGT, PGT, Rajasthan Computer Teacher, Banking aur State exams me yeh topic bar-bar poocha jata hai.

Microsoft Office ek Office Productivity Suite hai jo documents, spreadsheets, presentations, database aur email management ke liye use hota hai.

---

📌 What is MS Office? / MS Office क्या है?

English: Microsoft Office is a collection of application software developed by Microsoft to perform office-related tasks.

Ms-office

Hindi: MS Office Microsoft द्वारा विकसित application software का समूह है जिसका उपयोग office से जुड़े कार्यों के लिए किया जाता है।

Main Components:

• MS Word
• MS Excel
• MS PowerPoint
• MS Access
• MS Outlook
• OneNote

---

📌 Features of MS Office

• User Friendly Interface
• GUI based (Graphical User Interface)
• Cloud Integration
• Automation using Macros
• Cross Platform Support

Exam Tip: GUI = Graphical User Interface

---

📘 MS WORD (Word Processing Software)

What is MS Word?

English: MS Word is a word processor used to create, edit, format and print documents.

Hindi: MS Word एक word processing software है जिसका उपयोग document बनाने, edit करने और print करने के लिए होता है।

Uses of MS Word

• Letter writing
• Resume creation
• Books & notes
• Reports

Example:

Job application letter typing in MS Word.

---

Important Features of MS Word

1. Formatting

• Bold, Italic, Underline
• Font size and color
• Alignment

2. Paragraph Formatting

• Indent
• Spacing
• Bullets and numbering

3. Page Layout

• Margins
• Orientation
• Columns

---

Mail Merge (Most Important)

English: Mail merge is used to create bulk personalized letters.

Hindi: Mail Merge का उपयोग एक ही format में कई letters बनाने के लिए होता है।

Example: School students ko admit card print karna.

Exam Question: Mail merge kis software me hota hai? → MS Word

---

Header and Footer

Page ke top aur bottom me text add karne ke liye.

Example: Page number.

---

Shortcuts

• Ctrl + B → Bold
• Ctrl + U → Underline
• Ctrl + P → Print
• Ctrl + Enter → Page break

---

📊 MS EXCEL (Spreadsheet Software)

What is Excel?

English: MS Excel is a spreadsheet program used for calculations and data analysis.

Hindi: MS Excel एक spreadsheet software है जिसका उपयोग गणना और data analysis के लिए होता है।

---

Structure of Excel

• Workbook → Excel file
• Worksheet → Sheet inside workbook
• Row → Numbers (1,2,3)
• Column → Letters (A,B,C)
• Cell → Intersection of row and column

Example: A1 = First cell

---

Formulas and Functions

Formula hamesha = sign se start hota hai.

Common Functions

• =SUM(A1:A10)
• =AVERAGE()
• =MAX()
• =MIN()
• =COUNT()

---

IF Function

Example:

=IF(A1>50,"Pass","Fail")

Marks check karne ke liye use hota hai.

---

VLOOKUP (Very Important)

Vertical search ke liye use hota hai.

Example: Roll number se student name find karna.

---

Pivot Table

Large data ko summarize karta hai.

Example: Monthly sales report.

Exam Favourite Question

---

Charts in Excel

• Bar Chart
• Pie Chart
• Line Chart

Data visualization ke liye use hota hai.

---

Excel Shortcuts

• Alt + = → AutoSum
• F2 → Edit cell
• Ctrl + Arrow → Jump data
• Ctrl + Shift + L → Filter

---

📽 MS POWERPOINT

What is PowerPoint?

English: PowerPoint is presentation software used to create slideshows.

Hindi: PowerPoint एक presentation software है जिसका उपयोग slides बनाने के लिए होता है।

---

Uses

• Teaching
• Business presentations
• Seminars

---

Important Terms

• Slide
• Transition
• Animation
• Slide Show

Difference:
Transition = Slide change effect
Animation = Object movement

---

Slide Show Shortcut

F5 → Start slideshow

---

Slide Master

All slides ka design control karta hai.

---

🗄 MS ACCESS (Database Software)

What is Access?

English: MS Access is a database management system (DBMS).

Hindi: MS Access एक database management software है।

---

Database Objects

• Table
• Query
• Form
• Report

---

Primary Key

Unique identifier.

Example: Roll number

---

Foreign Key

Tables ko link karta hai.

---

Queries

• Select Query
• Action Query
• Parameter Query

---

📧 MS OUTLOOK

Email management software.

Features

• Send/Receive email
• Calendar
• Meetings

---

Email Protocols (Very Important)

• SMTP → Sending mail
• POP3 → Receiving mail
• IMAP → Sync mail

---

☁️ MS OFFICE 365 / MICROSOFT 365

Cloud based Office version.

Features

• Online Word
• OneDrive storage
• Real-time collaboration

---

OneDrive

Microsoft ka cloud storage.

Google Drive ka alternative.

---

📌 File Extensions (Exam Booster)

Software	Extension
Word	.docx
Excel	.xlsx
PowerPoint	.pptx
Access	.accdb

---

🔐 Security Features

• Password protection
• Read only mode
• Protected view
• Digital signature

---

📊 MS Office vs LibreOffice

Feature	MS Office	LibreOffice
Price	Paid	Free
Cloud	Yes	Limited
Popularity	Very High	Moderate

---

🎯 Exam Important Points

• Mail Merge → Word
• Pivot Table → Excel
• F5 → Slide show
• Primary key → Unique
• SMTP → Send mail

---

🔥 Previous Year Question Examples

Q1: Mail merge kis software me hota hai?
Ans: MS Word

Q2: Excel formula start hota hai?
Ans: =

Q3: Pivot table use hota hai?
Ans: Data summary

---

📚 Conclusion

MS Office computer exams ka backbone hai. Agar aap SSC, Railway, CET, TGT, PGT ya Rajasthan Computer Teacher ki preparation kar rahe hain, to MS Office ko deeply cover karna zaroori hai.

Focus karein:

• Shortcuts
• File extensions
• Mail merge
• Excel formulas
• Email protocols

Yeh notes aapko theory + exam dono me help karenge.

Advanced MS Office Notes in Hindi and English (TGT, PGT, SSC, Rajasthan Computer Teacher)

Yeh advanced notes un students ke liye hain jo basic MS Office se upar ka level prepare kar rahe hain — especially TGT, PGT, Computer Teacher, aur competitive exams.

---

📌 MS OFFICE ARCHITECTURE

English:

MS Office is built using a modular architecture where each application works independently but integrates with others via OLE (Object Linking and Embedding).

Hindi:

MS Office modular architecture par based hai jisme har application alag hoti hai lekin OLE ke through ek dusre se integrate hoti hai.

Example:

Excel chart ko Word document me embed karna.

---

📌 OLE (Object Linking and Embedding)

• Object Linking → Source file update hone par destination bhi update
• Object Embedding → Static copy embed hoti hai

Exam Trick: Dynamic data = Linking

---

📘 ADVANCED MS WORD

1️⃣ Styles and Themes

English: Styles are predefined formatting sets used to maintain consistency.

Hindi: Styles predefined formatting hoti hai jo document ko consistent banati hai.

Types:

• Paragraph Style
• Character Style
• Linked Style

---

2️⃣ Table of Contents (Auto)

Heading styles se auto generate hota hai.

Steps:
Apply Heading → References → TOC

---

3️⃣ Track Changes (Reviewing Tool)

Document editing history track karta hai.

Use Case: Legal drafting, academic review

---

4️⃣ Macros in Word

Macros repetitive tasks automate karte hain using VBA.

Example: Auto formatting official letters.

Exam Level: PGT

---

5️⃣ Document Protection Levels

• Read Only
• Password Encryption
• Restrict Editing
• IRM (Information Rights Management)

---

6️⃣ Advanced Find & Replace

Wildcards use kar sakte hain.

Example: All numbers replace with symbols.

---

📊 ADVANCED MS EXCEL

1️⃣ Data Types in Excel

• Text
• Number
• Date/Time
• Boolean
• Error values (#DIV/0)

---

2️⃣ Advanced Functions

Nested IF

=IF(A1>80,"A",IF(A1>60,"B","C"))

INDEX + MATCH

VLOOKUP ka alternative.

Why Better?

• Left lookup possible
• Faster performance

---

3️⃣ Logical Functions

• AND()
• OR()
• NOT()

Example:
=IF(AND(A1>50,B1>50),"Pass","Fail")

---

4️⃣ Text Functions

• LEFT()
• RIGHT()
• MID()
• LEN()
• CONCAT()

Example: Aadhaar masking.

---

5️⃣ Data Validation

Input restrictions lagata hai.

Example: Drop-down list for gender.

---

6️⃣ Conditional Formatting (Advanced)

• Icon sets
• Data bars
• Custom formulas

---

7️⃣ Pivot Table Deep Concept

Components:

• Rows
• Columns
• Values
• Filters

Advanced Use:

• Pivot charts
• Slicers
• Timelines

---

8️⃣ Power Query (Modern Excel)

Data import and transformation tool.

Used for: Data cleaning and ETL.

---

9️⃣ Power Pivot

Large datasets ke liye data modeling.

Exam Level: Advanced / PGT

---

🔟 Macros & VBA

Visual Basic for Applications Excel automation ke liye use hota hai.

Example: Attendance automation.

---

📽 ADVANCED POWERPOINT

1️⃣ Slide Master Deep Control

• Global fonts
• Logo placement
• Theme colors

---

2️⃣ Animation Pane

Animation sequence control karta hai.

• Trigger animations
• Delay control

---

3️⃣ Morph Transition (Modern Office)

Smooth object movement between slides.

---

4️⃣ Presenter View

• Notes visible to presenter only
• Timer
• Next slide preview

---

5️⃣ Export Options

• Video export (MP4)
• PDF
• Handouts

---

🗄 ADVANCED MS ACCESS

1️⃣ Database Design Concepts

• Entity
• Attribute
• Relationship

---

2️⃣ Keys in Database

• Primary Key
• Foreign Key
• Composite Key
• Candidate Key

---

3️⃣ Normalization

Data redundancy reduce karta hai.

Forms:

• 1NF → Atomic values
• 2NF → No partial dependency
• 3NF → No transitive dependency

Exam Favourite (PGT)

---

4️⃣ Queries Advanced

• Action Queries
• Update Query
• Delete Query
• Append Query

---

📧 ADVANCED OUTLOOK

1️⃣ Email Protocol Stack

• SMTP → Send
• POP3 → Download mail
• IMAP → Server sync

IMAP vs POP3:

• IMAP = Multi-device sync
• POP3 = Offline storage

---

2️⃣ Outlook Automation

• Rules
• Auto replies
• Calendar sharing

---

☁️ MICROSOFT 365 (CLOUD OFFICE)

1️⃣ Cloud Computing Integration

• SaaS model
• Subscription based

---

2️⃣ Real-time Collaboration

• Co-authoring
• Live cursor tracking
• Comments

---

3️⃣ OneDrive Deep Features

• Version history
• Auto backup
• Sharing permissions

---

🔐 SECURITY IN MS OFFICE

1️⃣ Encryption

AES-based encryption used.

2️⃣ Digital Signature

Authenticity verify karta hai.

3️⃣ Protected View

Internet files sandbox mode me open hoti hain.

---

📊 FILE FORMAT EVOLUTION

Old Format	New XML Format
.doc	.docx
.xls	.xlsx
.ppt	.pptx

Note: New formats are compressed and XML-based.

---

⚡ PERFORMANCE OPTIMIZATION

• Disable add-ins
• Use binary formats
• Reduce volatile formulas
• Optimize pivot cache

---

🎯 EXAM FOCUS (TGT/PGT)

• OLE concept
• Normalization
• Pivot tables
• Email protocols
• File formats
• Cloud Office

---

🔥 ADVANCED EXAM QUESTIONS

Q1: OLE ka full form?
Object Linking and Embedding

Q2: Excel me INDEX MATCH VLOOKUP se better kyu?
Left lookup possible

Q3: Normalization ka purpose?
Redundancy remove karna

Q4: IMAP ka benefit?
Multi-device sync

---

📚 Conclusion

Advanced MS Office knowledge aapko basic candidates se alag banata hai — especially teaching exams jaise TGT, PGT, aur Computer Instructor.

Focus karein:

• Excel advanced formulas
• Database concepts
• Cloud Office
• Security features
• Automation

Yeh notes advanced competitive exams ke liye perfect hain.

❓ MS Office FAQ (Frequently Asked Questions)

1. MS Office kya hai? / What is MS Office?

Hindi: MS Office Microsoft ka ek office productivity software suite hai jisme Word, Excel, PowerPoint jaise tools hote hain.
English: MS Office is a productivity software suite developed by Microsoft that includes Word, Excel, PowerPoint and other tools.

2. MS Office me kaun kaun se software hote hain?

MS Word, MS Excel, MS PowerPoint, MS Access, MS Outlook aur OneNote main components hain.

3. MS Word ka use kya hai?

MS Word document typing, resume, letters aur reports banane ke liye use hota hai.

4. Excel kis liye use hota hai?

Excel calculation, data analysis, charts aur formulas ke liye use hota hai.

5. Mail Merge kya hota hai?

Mail Merge MS Word ka feature hai jisse ek hi format me multiple letters banaye ja sakte hain.

6. Excel me formula kaise start hota hai?

Excel me har formula = (equal sign) se start hota hai.

7. PowerPoint ka use kya hai?

PowerPoint presentations banane ke liye use hota hai jaise teaching aur seminars.

8. MS Office kis company ka product hai?

MS Office Microsoft company ka product hai.

9. MS Office file extensions kya hote hain?

Word → .docx
Excel → .xlsx
PowerPoint → .pptx
Access → .accdb

10. MS Office exams me kahan useful hai?

MS Office SSC, Railway, Banking, CET, TGT, PGT aur Rajasthan Computer Teacher exams me important hai.

📘 MS Office 100 MCQs (SSC | RRB | TGT | PGT | CET)

1. MS Word is used for? / MS Word किस लिए प्रयोग होता है? (SSC)

A) Calculation

B) Presentation

C) Document Typing

D) Database

✔ Correct: C) Document Typing

MS Word is a word processor used for creating documents. MS Word document बनाने के लिए प्रयोग होता है।

2. Default Excel extension? (RRB)

A) .docx

B) .xlsx

C) .pptx

D) .txt

✔ Correct: B) .xlsx

.xlsx is default Excel file format.

3. Formula begins with? (SSC)

A) #

B) =

C) @

D) *

✔ Correct: B) =

Excel formulas always start with = sign.

4. Mail Merge is feature of? (SSC)

A) Excel

B) Word

C) Access

D) Outlook

✔ Correct: B) Word

Mail merge is used to create bulk letters in MS Word.

5. PowerPoint is mainly used for? (SSC)

A) Spreadsheet

B) Presentation

C) Database

D) Email

✔ Correct: B) Presentation

MS PowerPoint is used for creating slides and presentations.

6. Which MS Office app is used for database? (RRB)

A) Word

B) Excel

C) Access

D) Outlook

✔ Correct: C) Access

MS Access is a database management system.

7. Ctrl + B shortcut is used for? (SSC)

A) Italic

B) Bold

C) Underline

D) Save

✔ Correct: B) Bold

Ctrl + B applies bold formatting in Word.

8. Which is NOT an MS Office software? (SSC)

A) Word

B) Excel

C) Photoshop

D) PowerPoint

✔ Correct: C) Photoshop

Photoshop is Adobe software, not MS Office.

9. VLOOKUP is used in? (CET)

A) Word

B) Excel

C) Access

D) Paint

✔ Correct: B) Excel

VLOOKUP searches data vertically in Excel tables.

10. Full form of PPT? (SSC)

A) Personal Presentation Tool

B) PowerPoint Presentation

C) Program Processing Tool

D) Printed Page Text

✔ Correct: B) PowerPoint Presentation

PPT refers to PowerPoint file.

11. Primary key ensures? (PGT)

A) Duplicate data

B) Unique record

C) Formatting

D) Printing

✔ Correct: B) Unique record

Primary key uniquely identifies each record.

12. Ctrl + S is used for? (SSC)

A) Save

B) Print

C) Copy

D) Cut

✔ Correct: A) Save

Ctrl + S saves the current file.

13. Which chart shows parts of whole? (SSC)

A) Bar

B) Pie

C) Line

D) Column

✔ Correct: B) Pie

Pie chart represents percentage distribution.

14. Which key edits active cell in Excel? (RRB)

A) F1

B) F2

C) F5

D) F7

✔ Correct: B) F2

F2 edits active cell in Excel.

15. Which view is default in PowerPoint? (SSC)

A) Slide Sorter

B) Normal View

C) Notes View

D) Reading View

✔ Correct: B) Normal View

Normal view is default editing view.

16. Absolute reference example? (SSC)

A) A1

B) $A$1

C) A$1

D) $A1

✔ Correct: B) $A$1

$ symbol locks row and column.

17. SMTP stands for? (SSC)

A) Simple Mail Transfer Protocol

B) Secure Mail Transfer Protocol

C) System Mail Tool Protocol

D) Simple Message Transfer Process

✔ Correct: A) Simple Mail Transfer Protocol

SMTP is used for sending emails.

18. Slide transition occurs? (SSC)

A) On text

B) Between slides

C) On chart

D) On table

✔ Correct: B) Between slides

Transition applies between slides.

19. Animation applies to? (SSC)

A) Slide change

B) Objects

C) Database

D) Printer

✔ Correct: B) Objects

Animations are applied to objects.

20. Which is email client? (SSC)

A) Word

B) Outlook

C) Excel

D) Paint

✔ Correct: B) Outlook

MS Outlook manages emails.

21. Ctrl + P is used for? (SSC)

A) Paste

B) Print

C) Preview

D) Page break

✔ Correct: B) Print

Ctrl + P opens print dialog.

22. Workbook contains? (SSC)

A) Slides

B) Worksheets

C) Tables

D) Reports

✔ Correct: B) Worksheets

Workbook is collection of worksheets.

23. Default PowerPoint extension? (RRB)

A) .pptx

B) .docx

C) .xlsx

D) .accdb

✔ Correct: A) .pptx

.pptx is PowerPoint file format.

24. Data arranged in rows and columns is? (SSC)

A) Slide

B) Spreadsheet

C) Paragraph

D) Chart

✔ Correct: B) Spreadsheet

Spreadsheet organizes data in rows and columns.

25. Which is cloud storage by Microsoft? (CET)

A) Google Drive

B) Dropbox

C) OneDrive

D) iCloud

✔ Correct: C) OneDrive

OneDrive is Microsoft's cloud storage service.

26. Ctrl + C is used for? (SSC)

A) Cut

B) Copy

C) Close

D) Center

✔ Correct: B) Copy

Ctrl + C copies selected text or object.

27. Ctrl + V is used for? (SSC)

A) View

B) Paste

C) Save

D) Print

✔ Correct: B) Paste

Ctrl + V pastes copied content.

28. Ctrl + X is used for? (SSC)

A) Exit

B) Cut

C) Copy

D) Delete

✔ Correct: B) Cut

Ctrl + X cuts selected text.

29. Which function calculates average? (SSC)

A) SUM

B) AVG

C) AVERAGE

D) MEAN

✔ Correct: C) AVERAGE

AVERAGE() calculates mean value in Excel.

30. =SUM(A1:A5) does what? (RRB)

A) Multiplies

B) Adds values

C) Finds average

D) Counts cells

✔ Correct: B) Adds values

SUM adds numbers in range A1 to A5.

31. IF function is used for? (SSC)

A) Formatting

B) Logical test

C) Printing

D) Charting

✔ Correct: B) Logical test

IF evaluates condition and returns value.

32. Which tab contains font options in Word? (SSC)

A) Insert

B) Home

C) View

D) Review

✔ Correct: B) Home

Home tab includes font and paragraph tools.

33. Which feature checks spelling? (SSC)

A) Grammar Tool

B) Spell Check

C) AutoCorrect

D) Find

✔ Correct: B) Spell Check

Spell Check identifies spelling mistakes.

34. Red wavy line in Word indicates? (SSC)

A) Grammar error

B) Spelling error

C) Formatting error

D) Hyperlink

✔ Correct: B) Spelling error

Red underline shows spelling mistake.

35. Green underline shows? (SSC)

A) Spelling

B) Grammar

C) Hyperlink

D) Style

✔ Correct: B) Grammar

Green underline indicates grammar issue.

36. Which view shows slide thumbnails? (SSC)

A) Normal

B) Slide Sorter

C) Reading

D) Notes

✔ Correct: B) Slide Sorter

Slide Sorter shows all slides together.

37. Slide Master controls? (PGT)

A) Single slide

B) All slides design

C) Animation

D) Charts

✔ Correct: B) All slides design

Slide Master controls layout globally.

38. Which object stores data in Access? (SSC)

A) Form

B) Table

C) Query

D) Report

✔ Correct: B) Table

Tables store records in Access.

39. Query is used for? (SSC)

A) Data retrieval

B) Typing

C) Printing

D) Drawing

✔ Correct: A) Data retrieval

Query retrieves filtered data.

40. Form in Access is used for? (SSC)

A) Printing

B) Data entry

C) Backup

D) Coding

✔ Correct: B) Data entry

Forms provide user-friendly entry interface.

41. Report in Access is used for? (SSC)

A) Data storage

B) Printing output

C) Calculation

D) Editing

✔ Correct: B) Printing output

Reports format data for printing.

42. POP3 is used for? (SSC)

A) Sending mail

B) Receiving mail

C) Formatting

D) Database

✔ Correct: B) Receiving mail

POP3 downloads emails to device.

43. IMAP differs from POP3 because? (PGT)

A) Works offline only

B) Syncs across devices

C) Sends mail

D) Deletes mail

✔ Correct: B) Syncs across devices

IMAP keeps emails synced on server.

44. Ctrl + Z is used for? (SSC)

A) Undo

B) Redo

C) Save

D) Zoom

✔ Correct: A) Undo

Ctrl + Z reverses last action.

45. Ctrl + Y is used for? (SSC)

A) Undo

B) Redo

C) Paste

D) Copy

✔ Correct: B) Redo

Ctrl + Y repeats last undone action.

46. Alt + = in Excel does? (SSC)

A) Delete

B) AutoSum

C) Filter

D) Save

✔ Correct: B) AutoSum

Alt + = inserts SUM automatically.

47. Ctrl + Arrow in Excel does? (SSC)

A) Scroll slowly

B) Jump to data edge

C) Select row

D) Delete cell

✔ Correct: B) Jump to data edge

Moves to last filled cell in direction.

48. Which is presentation view mode? (SSC)

A) Slide Show

B) Table view

C) Draft

D) Layout

✔ Correct: A) Slide Show

Slide Show runs the presentation.

49. Which feature protects document with password? (SSC)

A) Encrypt

B) Compress

C) Merge

D) Align

✔ Correct: A) Encrypt

Encryption secures file with password.

50. Which Office version is cloud-based? (CET)

A) Office 2007

B) Office XP

C) Microsoft 365

D) Office 2003

✔ Correct: C) Microsoft 365

Microsoft 365 provides cloud Office apps.

51. Nested IF is used for? (PGT)

A) Single condition

B) Multiple conditions

C) Chart making

D) Formatting

✔ Correct: B) Multiple conditions

Nested IF handles more than one logical condition inside another IF.

52. INDEX function returns? (PGT)

A) Row number

B) Cell value from position

C) Column width

D) Chart type

✔ Correct: B) Cell value from position

INDEX returns value of a cell in a specified position.

53. MATCH function is used to? (PGT)

A) Add values

B) Search position

C) Format cell

D) Delete row

✔ Correct: B) Search position

MATCH returns the relative position of a value in a range.

54. INDEX + MATCH is better than? (PGT)

A) SUM

B) VLOOKUP

C) COUNT

D) IF

✔ Correct: B) VLOOKUP

INDEX + MATCH is more flexible than VLOOKUP.

55. Data Validation is used for? (SSC)

A) Printing

B) Restrict input

C) Chart

D) Sorting

✔ Correct: B) Restrict input

Data Validation limits the type of data entered.

56. Conditional Formatting is used to? (SSC)

A) Delete data

B) Highlight data

C) Save file

D) Encrypt

✔ Correct: B) Highlight data

Conditional formatting applies formatting based on conditions.

57. Which key inserts new worksheet? (SSC)

A) Shift + F11

B) Ctrl + F11

C) Alt + F11

D) F11

✔ Correct: A) Shift + F11

Shift + F11 inserts a new worksheet.

58. Macro is used for? (PGT)

A) Manual typing

B) Automation

C) Drawing

D) Printing

✔ Correct: B) Automation

Macros automate repetitive tasks.

59. VBA stands for? (PGT)

A) Visual Basic for Applications

B) Virtual Basic Access

C) Visual Backup Application

D) Variable Based Access

✔ Correct: A) Visual Basic for Applications

VBA is programming language for Office automation.

60. Section Break allows? (SSC)

A) Same formatting

B) Different formatting

C) Delete page

D) Save file

✔ Correct: B) Different formatting

Section break allows different formatting in document.

61. Footnote appears at? (SSC)

A) Document end

B) Page bottom

C) Header

D) Footer

✔ Correct: B) Page bottom

Footnote appears at bottom of page.

62. Endnote appears at? (SSC)

A) Page bottom

B) Document end

C) Header

D) Chart

✔ Correct: B) Document end

Endnote appears at end of document.

63. Which key opens Find dialog? (SSC)

A) Ctrl + F

B) Ctrl + H

C) Ctrl + G

D) Ctrl + P

✔ Correct: A) Ctrl + F

Ctrl + F opens Find feature.

64. Ctrl + H opens? (SSC)

A) Help

B) Replace

C) Header

D) Highlight

✔ Correct: B) Replace

Ctrl + H opens Find & Replace dialog.

65. Protected View is used for? (SSC)

A) Safe opening

B) Editing

C) Printing

D) Formatting

✔ Correct: A) Safe opening

Protected View opens downloaded files safely.

66. One-to-Many relationship means? (PGT)

A) One record linked to many

B) Many linked to one only

C) No relation

D) Duplicate key

✔ Correct: A) One record linked to many

One primary key relates to multiple foreign keys.

67. Normalization removes? (PGT)

A) Formatting

B) Redundancy

C) Charts

D) Animation

✔ Correct: B) Redundancy

Normalization removes duplicate data.

68. Which form is first normal form? (PGT)

A) 1NF

B) 2NF

C) 3NF

D) BCNF

✔ Correct: A) 1NF

1NF removes repeating groups.

69. Presenter View shows? (SSC)

A) Notes to presenter

B) Only slide

C) Database

D) Code

✔ Correct: A) Notes to presenter

Presenter view shows speaker notes.

70. Co-authoring allows? (CET)

A) Single user edit

B) Multiple users edit

C) Delete file

D) Backup only

✔ Correct: B) Multiple users edit

Cloud Office allows real-time collaboration.

71. Version History is used for? (CET)

A) Delete file

B) Restore older version

C) Encrypt file

D) Print

✔ Correct: B) Restore older version

Version history restores previous file versions.

72. Ctrl + Shift + L applies? (SSC)

A) Filter

B) Save

C) Delete

D) Copy

✔ Correct: A) Filter

Ctrl + Shift + L toggles filter.

73. Hyperlink shortcut? (SSC)

A) Ctrl + K

B) Ctrl + L

C) Ctrl + U

D) Ctrl + I

✔ Correct: A) Ctrl + K

Ctrl + K inserts hyperlink.

74. Header appears at? (SSC)

A) Top of page

B) Bottom

C) Center

D) Slide

✔ Correct: A) Top of page

Header is placed at top of document page.

75. Footer appears at? (SSC)

A) Top

B) Middle

C) Bottom

D) Chart

✔ Correct: C) Bottom

Footer is placed at bottom of page.

76. Excel me AutoSum shortcut? (SSC)

A) Ctrl + S

B) Alt + =

C) Ctrl + A

D) F2

✔ Correct: B) Alt + =

Alt + = inserts AutoSum quickly.

77. MS Word me spelling check key? (RRB)

A) F5

B) F7

C) F9

D) F1

✔ Correct: B) F7

F7 runs spelling & grammar check.

78. Access file extension? (SSC)

A) .accdb

B) .mdbx

C) .dbx

D) .ppt

✔ Correct: A) .accdb

Modern Access databases use .accdb.

79. Excel me active cell kya hoti hai? (TGT)

A) Colored cell

B) Selected cell

C) Hidden cell

D) Locked cell

✔ Correct: B) Selected cell

Active cell is the currently selected cell.

80. PowerPoint me slide sorter view use hota hai? (SSC)

A) Edit text

B) Rearrange slides

C) Add animation

D) Add notes

✔ Correct: B) Rearrange slides

Slide sorter helps manage slide order.

81. Excel me MAX function kya karta hai?

A) Minimum value

B) Maximum value

C) Average

D) Count

✔ Correct: B) Maximum value

MAX returns highest value.

82. Ctrl + P shortcut? (RRB)

A) Paste

B) Print

C) Preview

D) Page setup

✔ Correct: B) Print

Ctrl + P opens print dialog.

83. Word me indent control kaha hota hai?

A) Home tab

B) Layout tab

C) Insert tab

D) Review tab

✔ Correct: B) Layout tab

Indent and margins are in Layout.

84. Excel me column identify hota hai?

A) Numbers se

B) Letters se

C) Symbols se

D) Colors se

✔ Correct: B) Letters se

Columns use letters like A, B, C.

85. Excel me row identify hoti hai?

A) Letters

B) Numbers

C) Codes

D) Symbols

✔ Correct: B) Numbers

Rows are numbered 1,2,3…

86. Word me watermark kaha se add hota hai?

A) Design

B) Insert

C) Home

D) File

✔ Correct: A) Design

Watermark is under Design tab.

87. PowerPoint file extension older version?

A) .ppt

B) .pptx

C) .ppsx

D) .doc

✔ Correct: A) .ppt

Old PowerPoint used .ppt.

88. Excel me COUNT function kya karta hai?

A) Text count

B) Numbers count

C) Letters count

D) Words count

✔ Correct: B) Numbers count

COUNT counts numeric values only.

89. Word me Ctrl + Enter?

A) Line break

B) Page break

C) Paragraph break

D) Tab

✔ Correct: B) Page break

Ctrl + Enter inserts page break.

90. Outlook kis category ka software hai?

A) Spreadsheet

B) Email client

C) Database

D) Drawing

✔ Correct: B) Email client

Outlook is used for email management.

91. Excel me formula bar kaha hoti hai?

A) Bottom

B) Top

C) Right

D) Left

✔ Correct: B) Top

Formula bar is above worksheet.

92. PowerPoint me notes kaha likhte hai?

A) Notes pane

B) Slide pane

C) Task pane

D) Ribbon

✔ Correct: A) Notes pane

Notes pane is for presenter notes.

93. Word me header/footer kaha se add hota hai?

A) Insert

B) Home

C) Layout

D) Review

✔ Correct: A) Insert

Insert tab contains header/footer.

94. Excel me SUM ka kaam?

A) Multiply

B) Add numbers

C) Divide

D) Count

✔ Correct: B) Add numbers

SUM adds numeric values.

95. Word me zoom control kaha hota hai?

A) Status bar

B) Ribbon

C) Toolbar

D) Menu bar

✔ Correct: A) Status bar

Zoom slider is in status bar.

96. Excel me cell reference example?

A) 1A

B) A1

C) AA

D) 11

✔ Correct: B) A1

Cell reference = Column + Row.

97. PowerPoint me F5 ka use?

A) Edit slide

B) Start slideshow

C) Save file

D) Print

✔ Correct: B) Start slideshow

F5 starts slideshow from beginning.

98. Excel me filter ka use?

A) Hide data

B) Show specific data

C) Delete data

D) Encrypt data

✔ Correct: B) Show specific data

Filter displays selected records.

99. Word processor example?

A) Excel

B) Word

C) Access

D) Paint

✔ Correct: B) Word

MS Word is word processing software.

100. MS Office kis company ka product hai? (SSC)

A) Google

B) Microsoft

C) IBM

D) Apple

✔ Correct: B) Microsoft

MS Office is developed by Microsoft.