Cell, Row aur Column (Excel ki Asli Pehchaan) : Lesson 28 — ComputerSeekhoAurJobPao

Lesson 28: Cell, Row aur Column (Excel ki Asli Pehchaan)

Hinglish English हिन्दी

Is Lesson Mein Aap Kya Seekhenge

• 1. Column kya hota hai?
• 2. Row kya hoti hai?
• 3. Cell kya hoti hai?
• 4. Cell ka Address Kaise Banta Hai?
• Office Glossary

Jab aap Excel ki screen dekhte hain, toh bahut saare chhote-chhote boxes dikhai dete hain. Ye boxes hi Excel ka sabse important hissa hain. Excel ki poori duniya sirf 3 cheezon par tikki hoti hai: Column, Row aur Cell. Agar ye teen cheezein samajh aa gayi, toh Excel ka aadha concept clear ho jata hai।

1. Column (खड़ी लाइन)

Screen par jo lines upar se niche ki taraf ja rahi hoti hain, unhe Column kehte hain।

Pehchaan: Column ka naam hamesha Letters se hota hai: A, B, C, D, E…

📌 Example: Agar aap Column A mein hain, toh iska matlab hai ki aap Excel ki sabse pehli vertical line mein kaam kar rahe hain।

2. Row (लेटी हुई लाइन)

Screen par jo lines Left se Right ki taraf ja rahi hoti hain, unhe Row kehte hain।

Pehchaan: Row ka naam hamesha Numbers se hota hai: 1, 2, 3, 4…

• • Row 1 → sabse upar wali line
• • Row 2 → uske niche wali line

3. Cell (छोटा बॉक्स)

Jahan ek Column aur ek Row aapas mein milte hain, wahan jo chhota sa box banta hai use Cell kehte hain।

Excel mein aap jo bhi likhte hain — Naam, Number, Date ya Hisaab — sab kuch Cell ke andar hi likha jata hai।

4. Cell ka Address Kaise Banta Hai?

Excel mein har Cell ka apna ek address hota hai. Ye address 2 cheezon se milkar banta hai:

📌 Cell Address = Column ka Letter + Row ka Number

• Column A + Row 1 = A1
• Column B + Row 5 = B5

Iska matlab:

• • A1 → Column A aur Row 1 ka milne wala cell
• • B5 → Column B aur Row 5 ka milne wala cell

Isi address ki madad se Excel ko pata chalta hai ki data kahan likha gaya hai।

Office Glossary (Yaad Rakhne Wale Shabd)

• Vertical (वर्टिकल): Upar se niche wali line → Column
• Horizontal (हॉरिज़ॉन्टल): Left se Right wali line → Row
• Intersection: Jahan Row aur Column milte hain → Cell

💡 Ek chhoti tip: Excel = Boxes ka ghar. Har box = Cell. Aur har Cell ka apna address hota hai।

Aaj ki Practice (Sirf 5 Minute):
1. Excel kholiye aur Blank Workbook select kijiye
2. Mouse se kisi bhi cell par click kijiye
3. Dekhiye — wo kaun sa Column (A, B, C…) aur Row (1, 2, 3…) hai?
4. Dono ko milakar us cell ka naam boliye — jaise C4, D2, B7
5. Name Box mein dekhiye — kya wahan wahi naam likha hai jo aapne socha tha?
6. Ab 5 alag-alag cells par click karke unka address check kijiye

Is Lesson Mein Aapne Kya Seekha:

• Column kya hota hai — upar se niche wali vertical line, letters se pehchani jati hai
• Row kya hoti hai — left se right wali horizontal line, numbers se pehchani jati hai
• Cell kya hoti hai — jahan Column aur Row milte hain wahan banta chhota box
• Cell ka address kaise banta hai — Column letter + Row number
• Vertical, Horizontal aur Intersection ka matlab

← Previous Home Next →

---

Home | About | Index | Welcome | Contact | Privacy Policy