Page 119 - FUNDAMENTALS OF COMPUTER

NPP

NPP MS-Word & Excel 119

Fig. 2.42: The functions available through AutoSum command

4. Using Function Library: Many built-in 4. \§$ŠeZ cmB~«oar H$m Cn`moJ: \$m°_y©cm Q>¡~ Ho$ A§VJ©V
functions are available in Excel under the EŠgoc _| H$B© {~ëQ> BZ \§$ŠeÝg CncãY h¢& BÝh| \$m`Z|{e`c,
Formula tab. These are categorized as Financial, cm°{OH$c, Q>oŠñQ> Am{X _| {MÌ-2.43 _| Xem©E AZwgma
Logical, Text, etc. as in fig-2.43. When click on
a particular category, many functions related dJuH¥$V {H$`m J`m h¡& O~ h_ EH$ dJ© {deof na pŠcH$
to that category appear. By selecting the desired H$aVo h¢, àX{e©V dJ© go g§~§{YV H$B© \§$ŠeÝg Iwc OmVo h¢&
function and inserting the arguments we can Cn`wŠV \§$ŠeZ H$m M`Z H$a Ed§ Am½`y©_|Q> B§gQ>© H$a h_
use function at the desired location. Ano{jV ñWmZ na \§$ŠeZ H$m à`moJ H$a gH$Vo h¢&

Fig. 2.43: Function categories in the Formula tab
5. Using the Insert Function Command: 5. B§gQ>© \§$ŠeZ H$_m§S> H$m Cn`moJ: \$m_y©cm Q>¡~ _|
The Insert Function in the Formula tab allows Hw$N> H$sdS²>©g Ho$ gmW g{MªJ Ûmam \§$ŠeZ B§gQ>vJ H$m
inserting function by searching with some
keywords. When we click the Insert function Cn`moJ {H$`m Om gH$Vm h¡& O~ h_ B§gQ>© ’§$³eZ ~Q>Z na
button, a dialog box appears asking the user {ŠcH$ H$a|Jo, EH$ S>m`cm°J ~m°Šg Ho$ _mÜ`_ go nyN>m OmEJm
what sort of function he is searching for as in {H$ `yOa {H$g àH$ma H$m g{MªJ MmhVm h¡& {MÌ-2.44
fig-2.44. Enter some details for searching for a AZwgma \§$ŠeZ hoVw g{MªJ Ho$ {cE Hw$N> OmZH$mar B§Q>a H$a|
function and click on Go, a list will appear VWm Go na {ŠcH$ H$a|, {dñV¥V \§$ŠeÝg H$s {cñQ> gm_Zo
describing functions. We can choose from the {XIoJr& `{X H$moB© \§$ŠeZ Cn`wŠV cJVm hmo,Vmo M`Z H$a
list if some function suits us else search again
gH$Vo h¢ AÝ`Wm Cn`wŠV \§$ŠeZ {_cZo VH$ gM© eãX