Page 116 - FUNDAMENTALS OF COMPUTER

NPP

116 Fundamentals of Computers NPP

Press Enter to get the result as 20 displayed goc _| àX{e©V n[aUm_ 20 àm{ßV hoVw B§Q>a àog H$a|&
in the cell. Now, if you select the cell, check A~ `{X AmnZo goc {gcoŠQ> {H$`m h¡ Vmo \$m°_y©cm ~ma na
what is displayed at the formula bar? Š`m àX{e©V hmoJm?

2.23 Using Cell References in the 2.23 \$m°_y©cm _| goc ao\$a|gog H$m Cn`moJ
Formula
Cell reference refers to the column name goc [a’$a|g H$m Ame` goc Ho$ H$m°c_ Zm‘ Ed§ amo Ho$
and the row number of the cell. For example, Z§~a go h¡& CXmhaU Ho$ {cE, goc H$m goc ao\$a|g {MÌ-
the cell reference of cell displayed in fig-2.39 is
B2. When we insert the cell reference in the 2.39 _| B2 h¡& O~ h_ \$m°_y©cm _| goc ao\$a|g H$s E§Q´>r
formula, the current value in the cell is H$aVo h¢, goc H$m dV©_mZ _yë` H$åß`yQ>oeZ hoVw Am°Q>mo_o{Q>H$cr
automatically taken for computation. The cell Am OmVm h¡& goc ao\$a|g Ma H$m H$m_ H$aVm h¡& CXmhaU
reference works as a variable. For example, {MÌ-2.39 _| àX{e©V h¡& h_Zo goc ao\$a|g A2 = 20 VWm
look at the fig-2.39. We have entered in cell B2 = 100 E§Q>a {H$`m& h_| A2 × B2 H$åß`yQ> H$aZo hoVw
references A2=20 and B2=100. We want to apply
formula in the cell C2 to compute A2 x B2. The goëg C2 _| \$m°_y©cm Aßcm` H$aZm h¡& goc C2 _| \$m°_y©cm
steps for applying the formula at the cell C2 is: Aßcm` H$aZo Ho$ MaU h¡:
1. Assuming the values in the cells A2 and B2 1. goëg A2 VWm B2 H$m _yë` nhco hr B§Q>a H$a {c`m
are already entered, we click on cell C2. We h¡& h_ C2 pŠcH$ H$a|Jo& h_ S>m`aoŠQ>cr \$m°_y©cm =
can directly enter the formula =A2*B2 in
the cell C2. Press enter to get the result. As A2 * B2 goc C2 _| bmJy H$a|Jo& [aOëQ> Ho$ {cE
we type, the formula is visible in the B§Q>a àog H$a|& Q>mBn {H$E AZwgma \$m°_y©cm ~ma _|
formula bar. \$m°_y©cm àX{e©V hmoJm&
2. Alternatively, we select the cell C2 and 2. d¡H$pënH$ ê$n _| h_ goc C2 {gcoŠQ> H$aVo h¢ VWm
type the Equal to sign in the cell. Now, goc _| ~am~a H$m {MÝh S>mcVo h¢& A~ A2 {gcoŠQ>
select cell A2, the cell reference A2 is H$aVo h¡, goc ao\$a|g A2 ñdV… (=) {MÝh Ho$ ~mX Am
automatically place after (=) sign. Insert
multiplication sign * (Asterisk) and select OmEJm& JwUm {MÝh * (Eo[ñQ´>H$) B§gQ>© H$a| VWm EpñQ´>H$
cell B2 to place the cell reference just after * gmBZ Ho$ Vwa§V ~mX goc ao\$a|g Ho$ ñWmZ H$mo B2
* sign. {gcoŠQ> H$a|&
3. Now press Enter to get the result 2000 in 3. A~ goc _| [aOëQ> 2000 àmpßV Ho$ {cE B§Q>a àog
the cell. When you select the cell C2 and H$a|& O~ Amn C2 goc {gcoŠQ> H$a|Jo, \$m°_y©cm ~ma
look at the formula bar, you will see the
formula =A2*B2. Whenever we change H$mo XoI|& Amn XoI|Jo \$m°_y©cm = A2 * B2 & O~ h_
values in the cells A2 and B2, the result is A2 VWm B2 H$s d¡ë`y ~Xc|Jo C2 _| [aOëQ> ^r
automatically changed in C2. Am°Q>mo_o{Q>H$ ~Xc OmEJm&