Page 117 - FUNDAMENTALS OF COMPUTER

NPP

NPP MS-Word & Excel 117

Fig. 2.39: Applying formula using cell references

2.24 Using Functions 2.24 \§$ŠeÝg H$m à`moJ
A function uses predefined formula to \§$ŠeÝg H$m à`moJ Ano{jV d¡ë`y H$mo H¡$ëŠ`ycoQ> H$aZo
calculate some desired value. For example, if _| àr{S>\$mBÝS> \$m°_y©cm Ho$ {cE {H$`m OmVm h¡& CXmhaU Ho$
we want to compute average of certain numbers {cE, `{X h_| Hw$N> {d{eîQ> Z§~am| H$m EdaoO H$åß`yQ> H$aZm
then we can use AVERAGE function specifying
the source of numbers. AVERAGE(A1:A10) will hmo V~ h_ Z§~g© Ho$ gmog© ñno{g\$m` H$aVo hþE EdaoO
compute automatically the average of all values \§$ŠeZ H$m à`moJ H$aVo h¢& AVERAGE(A1 : A10) g^r
from cells A1 through A10. We need not to d¡ë`yO H$m EdaoO Am°Q>mo_o{Q>H$ H$a XoJm, Omo A1 go A10 ‘|
write formula for adding all values and then h¡& h_| g^r d¡ë`yO H$mo Omo‹S>Zo VWm 10 go ^mJ XoZo hoVw
divide by 10. Thus, functions save our time and \$m°_y©cm {cIZo H$s Amdí`H$Vm Zht hmoJr& AV: \§$ŠeÝg
make the formula size smaller. Hundreds of h_mam g_` ~MmVo h¢ Ed§ \$m°_y©cm gmBO N>moQ>m H$a XoVo h¢&
such built-in functions or library functions are Bg Vah Ho$ H$B© V¡`ma \§$ŠeÝg `m cmB~«oar \§$ŠeÝg
available in Excel. In this example, the range EŠgoc _| CncãY h¡& Bg CXmhaU, _| a|O A1 : A10
A1:A10 is called the argument of the function.
Each function may have its argument. Thus, \§$ŠeZ H$m Am°½`y©_|Q> H$hm OmEJm& àË`oH$ \§$ŠeZ Ho$ nmg
while using function we use at least three parts CgH$m Am°½`y©_|Q> hmoZm Mm{hE& AV: \§$ŠeÝg H$m à`moJ
as shown in fig-2.40. In this diagram the H$aVo g_` {MÌ-2.40 _| Xem©E AZwgma h_ H$_ go H$_
function SUM(B3:B12) computes sum of all VrZ ^mJm| H$m Cn`moJ H$aVo h¢& Bg {MÌ _| SUM(B3:B12),
values in the cells B3 through B12. B3 go B12 VH$ g^r d¡ë`yO H$m ¶moJ H$aVm h¡&

Equal sign
Function Name Argument
Fig. 2.40: Function parts