1️⃣ Microsoft Word (MS Word)
📚 What is MS Word?
MS Word एक word processing software है जो डॉक्युमेंट्स बनाने, एडिट करने, फॉर्मेटिंग करने, और प्रिंट करने के लिए उपयोग किया जाता है।
🔹 Key Features:
-
Text typing and editing (टेक्स्ट टाइपिंग और एडिटिंग)
-
Font style and size change (फॉन्ट स्टाइल और साइज बदलना)
-
Bold, Italic, Underline (टेक्स्ट को मोटा, तिरछा और रेखांकित करना)
-
Insert images, tables, charts (इमेज, टेबल और चार्ट जोड़ना)
-
Page layout and margins setting (पेज लेआउट और मार्जिन सेट करना)
-
Spell Check and Grammar Check (वर्तनी और व्याकरण जांच)
🔹 Common File Extension:
-
.doc (पुराना वर्जन)
-
.docx (नया वर्जन)
2️⃣ Microsoft Excel (MS Excel)
📚 What is MS Excel?
MS Excel एक spreadsheet software है जो डेटा स्टोर करने, संगठित करने, गणनाएँ करने, और डाटा एनालिसिस के लिए उपयोग होता है।
🔹 Key Features:
-
Data Entry in Cells (सेल्स में डाटा भरना)
-
Use of Formulas (सूत्रों का उपयोग)
-
Mathematical Calculations (गणितीय गणनाएँ)
-
Charts and Graphs creation (चार्ट और ग्राफ बनाना)
-
Data Sorting and Filtering (डेटा छाँटना और फिल्टर करना)
-
Pivot Tables (पीवट टेबल बनाना)
🔹 Common File Extension:
-
.xls (पुराना वर्जन)
-
.xlsx (नया वर्जन)
📚 Basic Examples
✏️ MS Word Example:
-
Creating a Resume (बायोडाटा बनाना)
-
Writing a Letter (पत्र लिखना)
-
Making a Report (रिपोर्ट तैयार करना)
✏️ MS Excel Example:
-
Making a Budget Sheet (बजट शीट बनाना)
-
Attendance Sheet (हाज़िरी शीट बनाना)
-
Sales Report with Charts (सेल्स रिपोर्ट बनाना चार्ट्स के साथ)
🖥️ Important Shortcut Keys
| Action | MS Word Shortcut | MS Excel Shortcut |
|---|---|---|
| Save File | Ctrl + S | Ctrl + S |
| Open File | Ctrl + O | Ctrl + O |
| Copy | Ctrl + C | Ctrl + C |
| Paste | Ctrl + V | Ctrl + V |
| Bold | Ctrl + B | Ctrl + B |
| Create New Document/Sheet | Ctrl + N | Ctrl + N |
❓ MCQs on MS Word and Excel
1. Which software is used for word processing?
-
a) MS Excel
-
b) MS PowerPoint
-
c) MS Word
-
d) MS Access
✅ Answer: c) MS Word
2. Which extension is used to save MS Excel 2016 files?
-
a) .doc
-
b) .xls
-
c) .ppt
-
d) .pdf
✅ Answer: b) .xls (or .xlsx for newer versions)
3. In MS Word, which shortcut is used to copy text?
-
a) Ctrl + P
-
b) Ctrl + C
-
c) Ctrl + X
-
d) Ctrl + V
✅ Answer: b) Ctrl + C
4. Which function is used in MS Excel to add numbers?
-
a) SUM()
-
b) ADD()
-
c) PLUS()
-
d) TOTAL()
✅ Answer: a) SUM()
5. Which software is best suited for making a budget?
-
a) MS Word
-
b) MS Excel
-
c) MS Paint
-
d) MS PowerPoint
✅ Answer: b) MS Excel
🎯 Summary (Quick Recap)
| MS Word | MS Excel |
|---|---|
| Document creation | Spreadsheet calculations |
| Used for writing | Used for data analysis |
| Text editing, formatting | Formulas, Charts, Sorting |
| .docx files | .xlsx files |
Practice Worksheet on MS Word (Basics)
1. Fill in the Blanks:
a) MS Word is a ____________ software.
b) The shortcut key to save a document is ____________.
c) The file extension of a Word file is ____________.
d) To make text bold, we press ____________ + ____________.
2. True or False:
a) MS Word is used to perform calculations. (True/False)
b) We can insert tables in MS Word. (True/False)
c) Shortcut for Paste is Ctrl + V. (True/False)
d) MS Word saves files in .ppt format. (True/False)
3. Match the Following:
| A | B |
|---|---|
| Ctrl + C | Save Document |
| Ctrl + S | Copy Text |
| Ctrl + N | Open New Document |
| Ctrl + P | Print Document |
4. Short Answer Questions:
-
What is the use of MS Word?
-
Write any two features of MS Word.
-
How can you insert an image in MS Word?
📝 Practice Worksheet on MS Excel (Basics)
1. Fill in the Blanks:
a) MS Excel is a ____________ software.
b) A single box in Excel is called a ____________.
c) To add numbers in Excel, we use the ____________ function.
d) The default file extension of an Excel 2016 file is ____________.
2. True or False:
a) MS Excel is used to create animations. (True/False)
b) Data can be sorted in MS Excel. (True/False)
c) SUM() is used for addition in Excel. (True/False)
d) A spreadsheet contains rows and columns. (True/False)
3. Match the Following:
| A | B |
|---|---|
| SUM() | Adds numbers |
| Ctrl + N | New Worksheet |
| Ctrl + S | Save Workbook |
| Cell | Intersection of Row & Column |
4. Short Answer Questions:
-
What is MS Excel mainly used for?
-
What is a Cell in Excel?
-
Write the formula to add A1 and A2 cells in Excel.
🌟 Bonus Task for Practice:
-
Create a simple "Letter to Principal" in MS Word.
-
Create a "Monthly Expense Sheet" in MS Excel with 5 items and calculate total expenses.
✅ How to use this Worksheet:
-
पहले Fill in the blanks से शुरुआत करें।
-
फिर True/False से concepts को पकड़ें।
-
Short answer से अपने basics क्लियर करें।
-
और अंत में, Bonus Task से प्रैक्टिकल प्रैक्टिस करें!