Page 111 - FUNDAMENTALS OF COMPUTER

NPP

NPP MS-Word & Excel 111

Name Box Formula Bar

Fig. 2.33: A New Workbook

Entering information in a worksheet- dH©$erQ> _| BÝ\$m°_}eZ H$s E§Q´>r- Z§~g© Ed§ Q>oŠñQ>
numbers and text
Before entering the information in the dH©$erQ> _| BÝ\$m°_}eZ B§Q>a H$aZo go nyd©, gd©àW‘
worksheet, first learn the concept of 'Cell' which goc Ho$ H§$goßQ> H$mo g_P c|, Omo ~hþV ‘hËdnyU© h¡& goc
is very important. A Cell is a rectangular n§p³V Ed§ H$m°c_ Ho$ B§Q>agoŠeZ _| EH$ Am¶VmH$ma g§aMZm
structure at the intersection of a row and hmoVm h¡& {MÌ-2.34 Ho$ _Ü` _| EH$ ~m°Šg {XI ahm h¡,
column. In fig-2.34, a box seen in the middle {Ogo goc B2 H$h gH$Vo h¢, Š`m|{H$ `h H$m°c_-B VWm
refers to the cell B2, as it is intersection of column amo-2 H$m B§Q>agoŠeZ h¡& goc H$m Zm_ dH©$erQ> Ho$ D$na
B and row 2. The name of the cell is coâQ> gmBS> _| Am°Q>moo_o{Q>H$ {S>ñßco hmo OmEJm& goc _| BÝ\$m°_}eZ
automatically displayed on left side above the B§Q>a H$s OmVr h¡& BÝ\$m°_}eZ B§Q´>r hoVw goc na pŠcH$ H$a|,
worksheet. The information is entered into a Ohm§ AmnH$mo BÝ\$m°_}eZ H$s B§Q´>r H$aZm hmo Vmo Q>mBn H$aZm
cell. For entering information, just click on the àma§^ H$a|& BÝ\$m°_}eZ B§Q>a H$aZo Ho$ níMmV B§Q>a H$s àog
cell where you want to enter the information H$aZo na cmoAa goc na Om gH$Vo h¢ `m Q>¡~ H$s àog H$aZo
and start typing. After entering the na amBQ> goc na Om gH$Vo h¢& BÝ\$m°_}eZ B§Q>a H$aZo Ho$
information we can press Enter key to go the níMmV B§Q>a H$s àog H$aZo na cmoAa goc na Om gH$Vo h¢
lower cell or Tab key to go to the right cell. The `m Q>¡~ H$s àog H$aZo na amBQ> goc na Om gH$Vo h¢& goc _|
text or the numbers entered in the cell can be B§Q´>r {H$E JE Q>oŠñQ> `m Z§~g© H$mo goc na S>~c pŠcH$ Ho$
formatted by right-clicking over the cell. We _mÜ`_ go \$m°a_oQ>oS> H$a gH$Vo h¢& h_ S>oQ>, nag|Q>oO,
can set the information as Date, Percentage, Q>oŠñQ>, H$a§gr Am{X ê$n _| BÝ\$m°_}eZ goQ> H$a gH$Vo h¢&
Text, Currency etc. Whatever we type, is viewed Omo ^r h_ Q>mBn H$a|Jo, {MÌ-2.33 _| Xem©E AZwgma
in the formula bar as shown in fig-2.33. \$m°_y©cm ~ma _| XoI gH$Vo h¢&