🧮 Day 59: MS Excel – Revision (Hinglish)
MS Excel – Revision (Hinglish)
👉 Aaj hum Excel ke important topics ka full revision karenge, jo exam aur practical dono ke liye perfect hai ✅
📌 1) Excel Basics
✅ MS Excel = Spreadsheet software
✅ Use:
Calculation
Marksheets
Reports
Charts
🔹 Basic Terms
Workbook = Excel file
Worksheet = Sheet
Row = Horizontal line (1,2,3…)
Column = Vertical line (A,B,C…)
Cell = Row + Column (A1, B2)
✏️ 2) Data Entry & Editing
Cell me data type karna
Edit = Double click / Formula bar
Copy (Ctrl + C), Paste (Ctrl + V), Cut (Ctrl + X)
AutoFill = Series banana
➕ 3) Basic Formulas
| Operation | Formula |
|---|---|
| Addition | =A1+B1 |
| Subtraction | =A1-B1 |
| Multiplication | =A1*B1 |
| Division | =A1/B1 |
🧮 4) Important Functions
✅ SUM
=SUM(A1:A10)
✅ AVERAGE
=AVERAGE(A1:A10)
✅ MAX
=MAX(A1:A10)
✅ MIN
=MIN(A1:A10)
✅ IF
=IF(A1>=50,"Pass","Fail")
🎨 5) Formatting Cells
Font, Alignment, Color
Border & Fill
Number Format
Ctrl + 1 = Format Cells
🔄 6) Sorting & Filtering
Sorting = Data ko order me arrange karna
Filtering = Specific data dikhana
📈 7) Charts & Graphs
Column Chart
Bar Chart
Line Chart
Pie Chart
Steps:
Insert Tab → Chart
🖨️ 8) Print Settings
Print Area
Orientation
Margins
Fit Sheet on One Page
🧪 Important Exam Questions
✅ Theory Questions
Excel kya hai?
Row, Column aur Cell kya hota hai?
Formula aur Function me difference?
SUM aur AVERAGE kya hai?
IF function ka use?
✅ Practical Questions
Ek marksheet banao
SUM, AVERAGE, MAX, MIN lagao
IF function se Pass/Fail nikalo
Chart banao
Print settings set karo
📝 Short Notes (Exam ke liye)
👉 Excel ek powerful tool hai calculation aur data analysis ke liye.