Microsoft Ms Excel Button ki puri jankari.

0
194

Aaj Microsoft Excel ke tools ya buttons ke bare me janne vale hai. Ms excel, Microsoft office ka ek Software hai jiska prayog Data calculation aur data ke analysis ke liye hota hai. Excel Spreadsheet me calculation ke liye Formulas ki ek bahut badi library hoti hai. Isme Enter kiye huye data ko arrange karne ke liye Command ki list hai. Excel button me bahut sare fiction, formulas, tools hone ke karan yeh software logo ko bahut pasand karte hai. Is post me hum aapko Spread Sheet ki Basic jankari dene vale hai jisme hum apko batayenge ki Ms excel kesa dikhta hai.

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 ek spreadsheet program hota hai jisme data ko Tabular form me enter kar sakte hai. 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 button ki jankari

Microsoft MS Excel button jankari hindi me.

Ms excel ke kuch version hote hai jisse excel ki limit kam ya jyada bhi ho sakti hai. 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. Chaliye ab excel button ke bare me jante hai.

ms-excel-tools-ke-name
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: Excel button me 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.

Kuch aur excel button

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. Jis name se Aapne file save kar di hai to Title bar me name show hoga.
Ribbon: Excel button me yeh menu Bar ke niche hota hai es bhag me menu bar me jo vikalp hote hai. 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. 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.
  2. Shape:apne Aap badlav ko adjust kar leta hai. Jab copy paste ya auto fill ka use hota hai. Example: C12.
  3. 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.
  4. Mixed:dono ka prayog kar sakta hai. Example: C$12 or $C12

LEAVE A REPLY

Please enter your comment!
Please enter your name here