MICROSOFT EXCEL START

Start->all programs->microsoftoffice->microsoft excel office 2007 pe jaise hi hum click karte hai to excel ki nai window open ho jaati hai, jaisa ki image me diya hai.




WORK BOOK

Workbook ms excel me ek document hai, isme totally 255 worksheets hoti hai, aur excel kholne par jo hume dikhai deti hai vo bi-default 3 sheet hi hoti hai.

SPREAT SHEET

Spreat advance excel me jo page hote hai unko kaha jata hai, inka dusra naam worksheet bhi hota hai, ms excel 2007 me total 16,384 column hote hai aur total rows 10,48,576 hoti hai, row aur column ka jaha par ek dusre se joint hota aur jaha cursor hai uss area ko cell kaha jata hai, jaise example ke tour pe A column aur 1 number cell milakar A1 ki ek cell ban jati hai, cell me data text ki jaankari ko hum store karte hai aur yeh excel sheet ki bahut hi important aur sabse micro unit hoti hai, hame jo address rows & column ke sequance se milta hai vo uss cell ka reference number hota hai, jaise ki A1, A2, B1, B2 ityadi, harek cell ka apna ek uniq address hota hai.

CELL REFERENCE

Cell reference jyaadatar 4 type ke hote hai, harek cell ka ek apna address hota hai jo ki uniq hota hai, jiske help se cell ki value ko hum access kar sakte hai. chaliye dekhte hai ki yeh 4 types kon konse hote hai.

1. RELATIVE REFERENCE

Cell refrence row aur column ko agar sequence me likha jaye to iska rusult samne aata hai, jaise ki iski ek cell ke reference me dusri cell ka reffrence pehli wali cell ke according change hota hai, agar hum iska use karte hai to counting easy ho jaati hai aur ye manual tarike se fast bhi ho jati hai, cell reffrence likhne ke tarike jaise ki a1, b1, c1, d1, e1 hai.

2. ABSOLUTE REFERENCE

Absolute reference ke karan ek cell ka reference kisi dusre cell ke reference ke sath change nahi hota kyuki isme reference ko dollar sign $ ke sath me liya jata hai, jaise ki $A$1, $B$1, $C$1, $D$1 etc.

3. RELATIVE AND ABSOLUTE REFERENCE

Relative & absolute refence me column dusri cell ke refence me change ho jata hai, but row change nahi hoti, kyuki isme column relative aur row absolute ho jati hai jaise ki, A$1, B$2, C$3, D$4 etc.

4. ABSOLUTE & RELATIVE REFERENCE

Isme row change hoti rehti hai lekin column apni jagah fix rehta hai aur isme column ko absolute aur row relative key hota hai, jaise ki, $A1, $B1, $C1, $D1 etc.

Ramesh Singh

Hello Dosto ! Mera Naam Ramesh Singh Hai. Main Ek Passionate Blogger Hun. Ye Website Maine Banai Hai. Is Website Par Main Longo Ko Hindi Me Jankari Deta Hun Aur Unki Help Karta Hun. Read More

Leave a Reply

Your email address will not be published. Required fields are marked *