Chapter 11 MS Excel Basics

MS Excel ek spreadsheet software hai jo data ko organize, calculate aur analyze karne ke liye use hota hai. Microsoft Office suite ka ye ek powerful tool hai jisme rows, columns, formulas, tables aur charts ke through hum large data ko easily manage kar sakte hain. Is chapter me hum Excel ke basic features — Rows & Columns, Data Entry, aur Basic Formulas (SUM, AVERAGE) — ko step-by-step detail me samjhenge.

11.1 MS Excel Interface Overview (Basic Introduction)

MS Excel open karte hi aap ek grid-type sheet dekhte ho, jisme chhote boxes hote hain jinhhe cells kaha jata hai. Har cell ka ek unique address hota hai, jaise A1, B2, C5 etc.

Excel interface ke main parts:

1. Title Bar

Yahan aapka file name dikhai deta hai.
Default file name “Book1” hota hai.

2. Ribbon Tabs

Ribbon ke andar multiple tabs hote hain:

Home
Insert
Page Layout
Formulas
Data
Review
View

In tabs me tools arranged hote hain jo data format, calculate, analyze aur present karne ke liye use kiye jate hain.

3. Worksheet Area

Ye grid hota hai jisme aap kaam karte ho.
Rows & Columns milkar cells banate hain.

4. Formula Bar

Aap yahan koi bhi formula likh sakte ho.
Select kiye hue cell ka data yahin dikhta hai.

5. Sheet Tabs

Excel me ek workbook me multiple sheets hoti hain.
Sheet1, Sheet2, Sheet3 etc.

11.2 Rows & Columns (Step-by-Step Explanation)

Excel ka pura structure Rows aur Columns se milkar bana hota hai.

📌 Columns

Columns vertical hoti hain.
Alphabet ke letters se represent hoti hain (A, B, C... Z, AA, AB...).
Total 16,000+ columns hoti hain.

📌 Rows

Rows horizontal hoti hain.
Numbers se represent hoti hain (1, 2, 3…).
Excel me 10 lakh (1,048,576) rows hoti hain.

📌 Cells

Row aur column ke intersection ko cell kehte hain.
Jaise: A1, B3, D10 etc.

Row & Column ko Select karna

1. Column select

Kisi bhi column ka top letter (A, B, C) par click karo.
Pura column select ho jayega.

2. Row select

Row ke left side number (1, 2, 3) par click karo.
Puri row select ho jayegi.

3. Multiple rows/columns select

Click + Drag karke multiple rows/columns select kar sakte ho.
Ya Shift + Arrow keys bhi use kar sakte ho.

Rows & Columns Insert / Delete (Tools & Steps)

Column insert karna

Column letter par right-click karo.
“Insert” choose karo.
Naya column left side add ho jayega.

Row insert karna

Row number par right-click karo.
“Insert” choose karo.
Nayi row upar add hogi.

Delete row/column

Right-click → Delete

Resize row/column

Column boundary drag karke size badha/sikoda sakte ho.
Auto resize: Double click on boundary.

11.3 Data Entry in Excel (Step-by-Step Guide)

Excel ka main purpose hi data entry aur calculations karna hota hai.
Data text, numbers, date, time ya formulas ki form me ho sakta hai.

📌 Step 1: Cell select karo

Kisi bhi cell par click karo jahan data enter karna hai.

📌 Step 2: Typing start karo

Text likhna hai to letter type karo.
Number likhna hai to direct number type karo.
Date likhna hai to DD/MM/YYYY format me likho.

📌 Step 3: Enter press karo

Data cell me save ho jata hai.
Enter se cursor neeche move hota hai.
Tab se cursor right side move hota hai.

🔹 Data Edit karna

Cell select → Double click → Edit
Ya
Cell select → Formula bar me edit karo

🔹 Data Copy, Cut & Paste

Copy

CTRL + C

Paste

CTRL + V

Cut

CTRL + X

Ye features numerical tables banane me bohot useful hote hain.

11.4 Basic Formulas in Excel (SUM, AVERAGE)

Formulas Excel ki sabse powerful feature hoti hain.
Formulas always = sign se start hote hain.

Formula 1: SUM Function

Use:

Kisi range ka total calculate karna.

Syntax:


=SUM(range)

Example:

A1 se A5 ka total nikalna ho to:


=SUM(A1:A5)

Step by Step:

Empty cell select karo
=SUM( type karo
A1 se A5 drag karo
) close karo
Enter press karo

Result total show karega.

Formula 2: AVERAGE Function

Use:

Numbers ka average nikalna.

Syntax:


=AVERAGE(range)

Example:


=AVERAGE(B1:B5)

Step by Step:

Empty cell select karo
=AVERAGE( likho
Range drag karo
Bracket close karo
Enter press karo

Common Mistakes (Beginners ke liye Helpful Notes)

Formula me equal (=) lagana mat bhoolo.
Brackets open & close correct rakho.
Range select galat ho to calculation bhi galat hoga.
Text values sum nahi hoti, unhe numbers me convert karna hota hai.

11.5 Practice Example (Beginner-Friendly)

Example Data:

Name	Marks
Asha	45
Ravi	50
Mohan	40
Sita	60
Neha	55

Total Marks:


=SUM(B2:B6)

Average Marks:


=AVERAGE(B2:B6)

Ye practice beginner ko formulas samajhne me bohot help karta hai.

Conclusion

Excel ka basic use samajhna har student, teacher aur office worker ke liye essential hai.
Is chapter me aapne seekha:

✔ Rows & Columns kya hote hain
✔ Data entry kaise hoti hai
✔ SUM & AVERAGE jaise basic formulas
✔ Excel sheet ko manage karne ke fundamental steps

Agar aap ye basics master kar lete ho to Excel ka advanced level (charts, VLOOKUP, pivot table) bohot easy ho jata hai.

🔗 Internal Linking Section

Neeche diye gaye sabhi chapters ki short summary + internal link style description aap apne blog me use kar sakte ho. Yeh readers ko next chapters explore karne me help karega.

📍 Chapter 1: Introduction to Computers

Is chapter me computer ka basic introduction, parts of computer, input-output devices aur computer ke common uses ko explain kiya gaya hai. Ye chapter beginners ke liye perfect starting point hai.
https://beginnercomputeracademyfree.blogspot.com/2026/03/chapter-1-basic-corse-computer-kya-hota.html

📍 Chapter 2: Types of Computers

Isme Desktop, Laptop, Tablet aur Smartphone jaise computer types ko simple language me compare kiya gaya hai. Aapko pata chalega kaun sa computer kis use ke liye best hota hai.
https://beginnercomputeracademyfree.blogspot.com/2026/04/chapter-2-basic-course-computer-ke.html

📍 Chapter 3: Operating System Basics

Yahaan aap sikhenge Operating System kya hota hai, Windows ka interface, menu navigation aur basic system settings. Ye chapter computer chalane ki foundation strong karta hai.
https://beginnercomputeracademyfree.blogspot.com/2026/04/chapter-3-basics-software.html

📍 Chapter 4: Windows Basics

Is chapter me Windows start/ shutdown, desktop, icons, taskbar, mouse actions aur basic file–folder operations jaise copy, paste, rename, delete, restore sab step by step samjhaaya gaya hai.
https://beginnercomputeracademyfree.blogspot.com/2026/04/chapter-4-basic-computer-corse-windows.html

📍 Chapter 5: Typing Basics

Keyboard layout, home row keys, typing posture, typing practice methods aur speed improve karne ke tips detail me diye gaye hain. Beginners ke liye daily typing routine bhi suggest kiya gaya hai.
https://beginnercomputeracademyfree.blogspot.com/2026/04/chapter-5-typing-basics.html

📍 Chapter 6: Internet Basics

Is chapter me internet, browsers, Google search, email create + send steps aur online safety rules (virus, scam se bachav) sab detailed explained hain.
https://beginnercomputeracademyfree.blogspot.com/2026/04/chapter-6-internet-basics.html

📍 Chapter 7: MS Paint Basics

Yahaan aap MS Paint ka interface, basic tools (pencil, brush, shapes, eraser), colours aur simple drawing banana step-by-step seekhoge.
https://beginnercomputeracademyfree.blogspot.com/2026/04/chapter-7-ms-paint-basics.html

📍 Chapter 8: Notepad Basics

Is chapter me Notepad kya hota hai, plain text features, file save/open, word wrap, font settings aur basic uses explain kiye gaye hain — specially beginners ke liye perfect.
https://beginnercomputeracademyfree.blogspot.com/2026/04/chapter-8-notepad.html

📍 Chapter 9: WordPad Basics

WordPad me text formatting, font style, size, color, alignment, bullets, images insert karna aur document save karna sab easy language me samjhaaya gaya hai.
https://beginnercomputeracademyfree.blogspot.com/2026/04/chapter-9-wordpad.html

📍 Chapter 10: MS Office Word Basics (2010)

MS Word interface, new document create karna, typing, bold/italic/underline formatting, paragraph settings, page setup aur print settings jaise tools ko practical steps ke saath explain kiya gaya hai.
https://beginnercomputeracademyfree.blogspot.com/2026/04/chapter-10-ms-office-basics-2010.html