Hello friends, Aaj hum apko android mobile ki ek general problem ke bare me batane vale hai jo ki har kisi na kisi android mobile me hoti hai aur problem ko hum Preinstalled apps kahte hai. To dosto Aaj hum apko es post me Android mobile me pahle se installed App (Pre Install) ko uninstall kaise karte hai ki jankari dene vale hai es post me hum Aapko with Root or Without dono tariko se system apps ko uninstall karna sikhane vale hai agar Aap mobile ko Root nahi karna chahte hai aur inbuilt system Apps ko mobile se remove karna chahte hai to uska bhi tarika hume yaha bataya hai. 



Preinstalled Apps kya hote hai?

Preinstalled apps vo Apps hote hai jo hume kisi bhi new android mobile ko kharidne (Buy) par company ke dvara milte hai jaise - Amazon shopping app, paid games etc. Mobile company en apps ka promotion karne ke liye mobile me install karti hai aur user ko use karne ke liye kahti hai jisse en apps ki earning ho sake. Mobile me apps ko Pre install karne ke liye App's company ke dvara mobile company ko paisa diya jata hai jisse vo apna promotion to kar lete hai magar user ke interface ko effect karte hai. System App, mobile ki memory me fix hote hai aur yeh hamare mobile ki performance ko kam karte hai jisse hamara phone jald hi discharge hona, slow work karne jesi problem karne lag jata hai. Android mobile me Pre installed apps hamare mobile ki Ram ke sath hi storage ko bhi use karte hai jisse mobile hange hone jesi problem start hone lag jati hai. 


system-app-remove-karne-ka-tarika

1. Mobile ke System Apps ko Remove kaise kare? With Root

Root Require - Es method ko karne ke liye pahle Aapko apne mobile ka Root hona jaruri hai agar mobile root nahi hai to Aap es method se system app ko uninstall nahi kar sakte hai. 

STEP-:1  Sabse pahle Aapko apne mobile me King Super User download karna padega aur install karna hoga. Super user ko open kare aur Menu se App manager par click kare.
app-manager-select-kare
STEP-:2   ab apko upar ki side me User aur System Application ki 2 category show ho rahi hogi tab System Application ko open kare. Ab Aapko system me Installed sabhi system app show ho rahe honge jis kisi bhi app ko remove karna chahte hai use mark kare aur Uninstall par click kare.
app-remove-karne-ke-liye-app-uninstall-kare
 STEP-:3  Ab Super user ki aur se ek notification milega use Yes karke apps remove confirm kare. 
Great! Ab hamare mobile se selected system App remove ho chuka hai. To dekha dosto es tarike se hum apne android mobile se system me installed apps ko delete kar sakte hai.

Notice :- Android system aur Google play jesi services ko uninstall nahi kare sirf upyog me nahi aane vale app ko hi uninstall kare.

2. Pre-installed Apps ko Remove kaise kare? Without Root

Agar Aap apne mobile me inbuilt apps ko without Root kare karna chahte hai to iske liye Aapke pas Computer/laptop ka hona jaruri hai aur sath hi ek data cable jo ki aasani se avalible ho jati hai, mobile me USB debugging enable karna hogi. Usb debugging enable karne ke liye Developer mode me jaye aur  Usb debugging ko on kare agar Aapke computer me Developer mode show nahi ho raha hai to About phone me jaye aur Built number par 7 bar click kare.

STEP-:1  Computer ki help se inbuilt app ko remove karne ke liye apko apne computer me Debloater software download karna hoga aur computer me installed karna hoga.


STEP-:2  Ab mobile me USB plug kar usb debugging enable kare aur PC se attached kare.

STEP-:3  Ab software ko open kare to Aapko ek blank black windows show hogi tab Read Device par click kare.
STEP-:4  Ab mobile me installed sabhi software ek list me show honge us waqt inme se jis bhi software ko uninstall karna chahte hai use mark kare aur Software windows me dikh rahe remove button par click kare.

Ab mobile se inbuilt software remove ho chuke hai. To dekha dosto es tarike se hum apne mobile me se kisi bhi preinstalled software ko Bina Root kare computer ki help se badi hi aasani se remove kar sakte hai.  Aapko hamari yeh post kesi lagi hume comment karke jarur bataye aur ise apne dosto ke sath share bhi jarur kare.

Dosto, Aaj hum Aapko Social Media networking site - Facebook ke bare me batane vale hai. Facebook ek sabse badi social media site hai jis par sabse jyada Users hai yeh logo ko ek dusre se connect karta hai. Downloaded Facebook App logo ek dusre se connect karne ke sath hi hume Photo, video, emotions, message sent and share karne ka bhi mouka deti hai yani ke hume Facebook par apne memorable photo, video, status apne friends aur har kisi ke sath me share kar sakte hai. Abhi bhi kuch desho me aise log hai jo Facebook ke bare me nahi jante hai ki facebook App download kaise karte hai. To dosto es post me hum Aapko Android Mobile me Facebook kaise download karte hai ya phir esa kahe ki Facebook install kaise karte hai ke bare me batane vale hai. How to Download Facebook in mobile in hindi. 
facebook-download-karne-ka-tarika

Facebook Kya hai? Facebook kisne banayi hai?



Facebook 4 February 2008 me launch kiya gaya tha jise Mark Juckerberg ne banaya tha pahle yeh ek bahut limited tha magar phir yeh logo ko pasand aata gaya aur dheere-dheere iski popularity badh gayi Abhi Year 2018 me India ke 250 Million User Facebook ka use karte hai aur uske Bad dusra number United States ke hai, United States ke 230 Million user hai yani ke India me sabse jyada facebook app download hota hai aur facebook ka upyog kiya jata hai aur acche se samjhne ke liye humne niche ek image share ki hai use dekhe. Es image me humne Number of Facebook user ki Counting show ki hai jise aap dekh kar samajh sakte hai ki kitne logo dvara facebook download, install aur Use kiya jata hai. Esliye hum aaj apko es post me facebook download karne ke tarike, facebook install kaise karte hai ke bare me batane vale hai.

facebook-user-ke-aadhar-par-2018-ke-aankde
Image source: statista.com

par pichle kuch dino pahle Facebook ki User Date leak Report mili thi jisme yeh bat saamne aayi ki Facebook apne user account ka data ko leak kar raha hai jisse user ki Privacy khatm ho rahi hai is bat ka pata chalne par dher sare users apna account band kar diya hai aur isse facebook ko bahut bada nuksan hua hai par facebook es par jald Security ko thik karne vali hai esliye chinta ki koi bat nahi hai.



Facebook kaise download kare?

Dosto Facebook ki popularity aur user ke bare me to aap jan hi chuke hai ab hum Aapko apne Android mobile me facebook kaise download karte hai aur facebook use karne ke tarike ke bare me batane vale hai.

Android Mobile me Facebook kaise download karte hai?

STEP-:1  Mobile me Play Store open kare aur upar dikh rahe search box me Facebook likh search kare agar apke mobile me play store open nahi ho raha hai to pahle Aapko Play store par apni id create karna hogi.
STEP-:2 Ab apke samne Facebook aur isse related app ki list open hogi tab original Facebook app ke icon ko select kare.

STEP-:3 Ab Aapko yaha par facebook ke screenshot aur rating show hogi phir Install button par click kare.



Install par click karne ke baad Aapke mobile me facebook download hone ki process start ho chuki hai. Download hone ke baad me Open par click kare. Facebook use karne ke liye apko facebook par account banana jaruri hai agar aap nahi jante hai ki Facebook par account kaise bante hai to hamari  post jarur padhe. 

Computer me Facebook kaise download kare?

Windows Computer me Facebook download karne ke liye apko Microsoft store se Facebook  download karna hoga par iske liye Microsoft Store par account hona chahiye. Direct store se Facebook par jane ke liye niche download button par click kare.



Agar aap Computer me bhi fb download karte hai to apko account to banana hi padega.  Facebook ki aur bhi jankari pane ke liye aap di gayi link par click kar sakte hai. Esi tarah ki new facebook updates apne mobile me pane ke liye aaj hi hume Email Subscribe/sign up kare yeh bilkul #Free hai.

Hi friends, Aaj hum Aapko Gb Whatsapp ka latest version ke bare me batane vale hai ki Apne Android mobile me GbWhatsapp ka latest version kaise download karte hai aur Gbwhatsapp kaise download karte hai. Gb whatsapp iski Feature and tools ki vajah se logo ke bich me kaphi famous hai kyonki yeh Original whatsapp ki sari limits ko khatm kar deta hai. Gb whatsapp ki Online hote huye bhi Online show nahi karna, message seen hone ke baad me bhi Seen ke blue tick show nahi hona, Writing status, Status UnSeen, Anti revoke ise kuch khas bana dete hai niche post me humne Gb whatsapp ke Sabhi latest feature ke bare me aur Gb whatsapp kaise download karne ke bare me detail se bataya hai.


Normal whatsapp ki tarha hum ise Play store se download nahi kar sakte hai kyonki yeh play store aur whatsapp ki policy ko break karta hai esliye hum ise play store se download nahi kar sakte hai agar aap bhi Gb whatsapp ka latest v. download karna chahte hai to es post ko jarur padhe es post me humne Latest Gbwhatsapp ki link di hai agar aap abhi gb whatsapp use kar rahe hai aur use update kar rahe hai to vo dusri language me download ho raha hoga to Aapko chinta karne ki koi jarurat nahi hai niche humne link di hai jise click karke hum English language me download kar sakte hai.
GB-WHATSAPP-LATEST-VERSION-DOWNLOAD-KARE-KA-TARIKA

Latest Gb Whatsapp ke feature

  1. Hide online status, Blue Ticks, Double Tick, Status Seen, Writing Status, Recording, Blue Microphone
  2. Anti Revoke- with notification
  3. DND mode
  4. Message Scheduler
  5. Broadcast messages to groups
  6. Send larger Videos than normal WhatsApp
  7. Let You Able to Send Apk and Zip Files Directly
  8. Lets you Download WhatsApp Status
  9. Clean Log files
  10. Copy-able Status   
  11. Custom chat with different password
  12. Hide Chat in whatsapp Top bar wih Pattern lock-Secret Trick
  13. Change App font and Custom Themes
  14. Media Sharing Mods
  15. Main/Chats Screen Mod, Conversation Screen Mod

Gb Whatsapp kaise download karte hai?



Jesa ki maine abhi upar bataya ki hum ise Play store se download nahi kar sakte hai ise hum Google par kuch link se download karna hota hai.


Gb Whatsapp kaise install kare?

Dosto Gb whatsapp ko bhi normal whatsapp ki tarah insall kar sakte hai aur isko install karne ki steps bhi bahut aasan hai par agar apko nahi aata hai to humne niche iski steps batayi hai inhe follow karte jaye aur kuch hi steps me apke mobile me bhi install ho jayega.

STEP-:1 Upar di gayi link se pahle apne mobile me Gb whatsapp download kar lijiye aur use open kar lijiye.

STEP-:2 App install karne ke liye pahle apko device se permission lene ke liye kaha jayega tab setting par click kare aur Unknown source ko enable kare.

STEP-:3 Enable karne ke baad apko Install par click karna hai kuch hi samay me Gb whatsapp install ho jayega.


To dekha dosto es tarike se hum apne mobile me GB whatsapp ka latest version install kar sakte hai. ab agar apko Whatsapp par account banana hai aur agar aap nahi jante hai to aap hamari Whatsapp par account kasie banaye post ko padh lijiye isme apko bas step1 ko chhod dena hai aur baki sabhi steps ko aise hi follow karna hai jesa ki post me bataya hai.

Aaj ka hamara topic hai Backlinks ji ha aaj hum aapko batane wale hai ki backlinks kya hai aur backlinks kaise banate hai aur Back Links blog ke SEO Search Engine Optimization ke liye kyo jaruri hoti hai and iski madad se hum kaise search engine me achchi rank pa sakte hai, ye sabhi jankari is post ki madad se gum aapko dene wale hai kyoki aap blog bana kar blogging me success ana chahte ho to iske liye ye jaruri hai ki aapko search engine se traffic mile aur search engine se traffic tab hii milega jab aapki post SEO ho aur blog ke seo me ek sabse jaruri chij hoti hai backlinks aapke aas jitni jyada backlinks hogi to aapke  blog ki post ko google aur dusre search engine me utni hi jyada achchi rnk milegi.To chaliye ab hum samjh lete hai ki Backlinks kya chij hai.
Blog-ke-liye-Backlinks-kaise-banaye

Backlinks  kya hai ?

Jab bhi hum apni website par kisi dusri website ya webpage k link dete hai aur fir jo bhi hamari website par aata hai aur hamare blog se wo us website ya webpage par jata hai to us wbsite ya blog ko hamari website se backlink mil jati hai, kahne ka sidh matlab hai ki jab hm apni post me kisi website ki link dale aur hamare readers us link par click kare to us website ki backlink ban jati hai to ye hai backlinks ki defination i hope ki aapko samajh agaya hoga ki backlinks kya hai, ab backlink keval ek tarah ki nahi hoti hai iske bhi kai type hote hai jinki jankari niche di hui hai.

Type of Backlinks ?

Backlinks keval ek tarah ki nahi hoti hai aur ye hamare liye backlinks banane se pahle janna jaruri hai ki hame kis tarah ki backlinks banani hai ye kitne tarah ki hoti hai.

1. Link Juice
Link juice SEO ki dunia me bahut jaruri hai ye wo link hai jo jab hum apni site ko dusri link par add karte hai to google us website ko rank dene ke liy e chake karta hai aur is tarah ki link ko link juice kahte hai aur ye search engine me rank dilane me aham role nibhati hai.

2. Internal Links
Internal links ka matlab jab hum apni post me kisi aur post ka link jo hamari hi website ya blog me ho tois tarah ki links Internal Link kahte hai.

3. External Links
External link wo link hoti hai jo hum apni website me dete hai par wo kisi dusre blog ya website ki link hoti hai.

4. Nofollow Links
Jab hum apni post m koi link dete hai aur koi upar click kare aur wo link dusre pag me open no hokar usi page me khul jaye to esi link ko NoFollow link kahte hai

5. Dofollow Links
Ye wo links hoti hai jo hm apne blog ki post me add karte hai par jab bhi koi us par click karta hai hai to ye ek dusre page me ya PopUp page me open hoti hai to is tarah ki links Do Follow Links hoti hai

6. Low Quality Links
Yani kijab bhi koi aapki site ka link kahi crash ya galat website ya fir kisi spam site par add ho jaye aur koi vyakti waha se aapki site par aa jaye to is tarh bane links Low Quality links kahlate hai

7. High Quality Links
Isme esi links aati hai jab koi dusri site hamari site ko promote kare aur kahe ki is link par click kare aur waha se aapko 10-12 visitors mil jaye to is tarah ke Link High Quality Backlinks hoti hai.

8. Anchor Text Link
Jab aap kisi link ko anchor text jaise SEO, Click, me koi link jodte ho to wo anchor text link kahlati hai Friend to ye the links ke itne sare types. Ab hum janenge ki backlinks Blog Seo ke liye kyo jaruri hai.


BackLinks kyo jaruri hai

Dosto backlink ek esi chij hai jo kisi bhi keyword ke sath search engine me top rank dila sakti hai isliye ye bahut jaruri bhi hai aur bahut importent bhi hai hum aapko iske seo me jaruri hone ke kuch khas karan bata rahe hai.

Iski sabse achchi baat hai ki aapki website aur blog search engine me bahut jaldi index hoti hai aur aapki post mushkil se din me achchi rank ke sath index ho jati hai. Wo kya hai ki jab aap koi quality post likhte hai aur aapko us post par ummid se kam rank milti hai to iska matlab hai ki aapke paas backlinks ki kami hai ya fir aapke paas backlinks hai hi nahi. Isliye backlink fast indexing me bahut madad karti hai.

Agar aap bloging me success hona chahte hai to iske liye jaruri hai ki aapke apne blog ke liye jyada se jyada quality backlinks banaye kyoki yahi chij aapki site ko internet par top rank dilane me madad karti hai ise hum blogging success paane ka shortcut bhi kah sakte hai.


Traffic increase kaise kare

Aakhir me mai aapse yahi kahunga ki aap jyada se jyada backlinks banane ki koshish kare par backlinks banane ke chakkar me koi esi gadbad na kare ki aapko search engine se penalty bhugatni pad jaye aur aapki website ya blog ko search engine se block kar diya jaye. Isliye me yahi kahunga ki aap backlinks banane ke liye sahi tarika apnaye. agar aap quality backlinks banana chahte ho To hum aapko yaha par jo tips bata rahe hai unhe follow karke aap quality backlinks bana sakte hai.

backlinks banane ke kuch aasan tarike

Backlinks banane ke kuch sortcut bhi hai jiski madad se aap kuch hi der me apne blog ke liye bahut sari backlinks bana sakte hai Internet par esi bahut sari website hai jo aapko kuch hi minute me hajaro backlinks banane ka dava karti hai par me aapko batadu ki agar aap is tarah se back links bana bhi le to isse aapko aur apke blog ko koi fayda nahi hogaulta apke website ki ranking gir jayegi kyoki is tara se bani back links quality backlinks nahi hoti hai aur isi wajah se hamare blog ke seo par bura asar padta hai.

1. Website Blog par Comment karna

Mere hisab se back links ko banane ka sabse aasan tarika agar koi hai to wo hai comment karna par iska matlab ye nahi hai ki aap kahi par bhi comment karke backlink banane me safal ho jayenge aapko blog se releted blogs par hi comment karna hai aap keval un blog par hi comment kare jo aapke blog ke topic par hi likhte ho. Ab aapko ek baat ka dhyan rakhna hoga ki aapko comment karna kis tarah se kyoki agar aapne kisi blog par comment kar bhi di to ye jaruri nahi hai ki koi us comment par click karke aapke blog par aayega isliye aap comment me koi esa sawal puche ki jo bhi use read kare to wo aapke blog par visit jarur kare agar esa hota hai to aapko backlinks mil jayegi.

2. Guest Posting 

Aapko ye baat pata honi chahiye ki agar Back Links banane ka agar sabseachcha koi tarika hai wo hai Guest Posting karna , ye ek esa tarika hai jo aapko High Quality ki Back Links to dilata hai hi sath hi aapke blog ka ka traffic increase karta haipar ye tarika jyad tar logo ko pasand nahi aata hai kyoki bahut log sochte hai dusre ke liye post likhne se achcha hai ki apne blog par post likhe, par esa nahi hai aap ise try kar sakte hai aap kisi ese popular blog jo aapke blog se releted ho guest post karta ho to us par ek guest post karke dekhe aapko isse jarur fayda hoga.

3. Backlinks Exchange 

Ye bada hi aasantarika hai backlinks banane ke liye, is tarh sebacklinks banane ke liye aapko new bloggers ko dhundhna hoga jinhone abhi abhi bloggeng shuru ki hai uske baad aap usne deal karke unke blog me apne blog ka link aur apne blog me unka link add kare jisse dono ko fayda hoga aur aapko ek quality back link bhi mil jayegi is tarah se aap apne blog ke liye bahut sare links bana loge aur aapke dusre bloggers se achche reletion banenge.

4. Fourms

Ek tarika ye bhi hai jisse aap aasani se blog ke liye bakclinks bana sakte ho. Aur ye tarika hai ki aap Internet par jo popualarwebsite hoti hai wo apne blog ke liye ask form banate hai jaha par aap apna sawaal puch sakte ho aur apne blog ka link bhi add kar sakte ho jisse ki log aapke blog par click karenge aur aapko backlinks mil jayenge.


5. SEO Friendly Article 

SEO Friendly post likhne par bhi aapko backlinks milne ke chances hote hai kyoki agar aapka post seo hua to dusre bloggers bhi us post ka link apni post me de sakte hai jisse ki aapko back links mil sakte hai. Isliye aap yahi koshish kare ki aapka post SEO Friendly ho.

6. Social Media

Jaisa ki social media hamare blog ka traffic badane bahut madad karti hai thik vaise hi aap sabhi social network par aap apne blog ka link add kare jisse aapko yah se bhi backlink mil sake aur social media se milne wala link bahut hi high quality ka hota hai. Aap apne blog ki post me upar niche social media ke share button add kare taki log aapki post ko share kare aur aapko backlinks milne ke chance aur bad jaye, ek baat yaad rakhe ki koi bhi uhi aapkji post share nahi karega is liye aap apnie article me iapni post ko share karne ki Request kare jisse visitors aapki post ko share kare.


Guys i hope ki aap logo ko samajh me aa gya hoga ki backlinks kaise banate hai wo bhi quality back links   aap apni mehnat se backlinks banaye koi bhi esa tarika na apnaye jisse ki aapki website ki Ranking down ho jaye.

Agar aapko hamara post pasand aayaaur aapko hame hamari mehnat ka kuch inaam dena hai to aap hamari is post ko jyada se jyada share kare.

Namskar Dosto, Aaj hum Microsoft Excel ke bare me janne vale hai jise shortcut me Ms Excel bhi kaha jata hai. Ms excel, Microsoft office ka ek Software hai jiska prayog Data calculation aur data ke analysis ke liye hota hai. Ms Excel Spreadsheet me calculation ke liye Formulas ki ek bahu badi library hoti hai aur Enter kiye huye data ko arrange karne ke liye Command ki list hai. Ms excel ke bahut sare fiction, formulas aur tools hone ke karan yeh software logo ko bahut pasand kiya jata hai aur har jagah Ms excel ka use kiya jata hai. Es post me hum aapko Spread Sheet ki Basic jankari dene vale hai jisme hum apko batayenge ki Ms excel kesa dikhta hai aur Excel ke kis area ko kya name se jana jata hai aur ms excel ke upyog ke bare me bhi batane vale hai.
ms-excel-sheet-kya-hai

Computer me Ms Excel kaise open karte hai?

Excel ko open karna bahut hi aasan iske liye apko jyada kuch bhi karne ki jarurat nahi hai bas niche batai steps ko follow karte jaye aur Aapke computer/laptop me bhi Excel open ho jayega.



STEP-:1  Taskbar ke Left side me dikh rahe Start button par click kare ab Aapke samne Start menu open ho jayega.

STEP-:2  Ab Start menu me All program par click kare.

STEP-:3  Ab yaha par apko installed software ki list show hogi tab isme apko Microsoft office ke name ka folder search karna hai aur us par click karna hai ab apko Microsoft Excel 2007 ke name se file show hogi us par click kar dijiye.
Ab Aapke computer me Ms excel khul chuka hai aap chahe to es file par Rigth click karke Desktop par iska shortcut bhi bana sakte hai jisse aap kabhi bhi ise aasani se open kar sakte hai. 

Ms Excel kya hai? MS Excel ki jankari hindi me.

Ms excel ek spreadsheet program hota hai jisme data ko Tabular form me enter kar sakte hai aur usme excel ke function aur formulas ko bhi apply kar sakte hai. Yeh ek Spreadsheet program hai jisme hum bahut bade Data ko bhi badi hi aasani se manager kar sakte hai. Ms excel ke kuch version hote hai jisse excel ki limit kam ya jyada bhi ho sakti hai aur sath hi ms excel software version ke hisab se excel file ke extension bhi alag-alag ho sakte hai. yaha humne tools aur unki position ke name bataye hai aur bataya ki unhe kis name se jana jata hai.
ms-excel-tools-ke-name
Software: Microsoft Excel
Extension: 1997-2003(.xls), 2007-2016 (.xlsx)

Work Book - Excel ki ek file ko Work Book kaha jata hai ek Work book kai sari sheets ka group hoti hai. Excel work book me pahle se 3 Sheet hoti hai- Sheet1, Sheet2, Sheet3.

Worksheet - Ek worksheet Cells ka collection hoti hai jaha par hum apne data ko rakhte hai aur manipulate karte hai. hum ek work book me kitni bhi work sheet ko khol sakte hai.

Row, Column and Cell- Sheet me kai sari aadi (Horizontal) line hoti hai jise Row kahte yeh Sheet me by default 1,2,3 name se hoti hai aur Ek Column cells ka khada block hota hai jo ki A,B, C ke name se hota hai ise Column kaha jata hai.

Function and formula: Fuction kisi kam ko karne ke liye kuch Arguments ke sath pahle se set reserved hote hai. Fuction ya to =  ya + ke chinh se start hote hai. Formulas jati se jatil saval ko aasani se hal karne ki trick hai. formula bhi ya to = ya + ke chinh se start hota hai.

Forumla Bar: Ye ek tarah ka bar hota hai jaha par hum apne hisab se formula ko likh sakte hai. Hum formula ya function ko yaha se bhi badal sakte hai.


Name Box: Yeh box formula bar ke Left side hota hai jo har Cell, chart ya Object ki status batata hai.

Scroll Button/Bar: Scroll Button ka prayog sheet par speed se ek jagah se dusri jagah par move karne ke liye kiya jata hai.

Title Bar: Title Bar ms excel ke sabse upar ka bhag hota hai isme file ka name show hota hai default me iska name Book1 ke name se show hota hai agar file ko save kar dete hai to jis name se Aapne file save kar di hai to Title bar me name show hoga. 

Ribbon: yeh menu Bar ke niche hota hai es bhag me menu bar me jo vikalp hote hai ko isme dikhya jata hai.   

Active Worksheet: Present me hum jis sheet ko open karte hai aur jis par work karte hai use Active worksheet kaha jata hai.

Sheet Tab: yeh ek tab hoti hai jaha par sabhi worksheet ka name show hota hai aur yaha se hum kisi bhi Sheet par ja sakte hai.


Type of Cell Address:-
  1. Referential: yeh formula me sabse adhik use hone vala cell Reference hai. Relative cell reference basic cell reference hai jo apne Aap badlav ko adjust kar leta hai jab copy paste ya auto fill ka use hota hai. Example: C12.
  2. Absolute: Kabhi kabhi esi situation aati hai jab copy paste ya auto fill ka prayog karne ke baad bhi kisi cell reference ko roke rahna hota hai tab Dollar ($) chinh ka prayog karke kisi column ya Row ko Reference se roka ja sakta hai. Example:- $C$12.
  3. Mixed: dono ka prayog kar sakta hai. Example: C$12 or $C12