Page 118 - FUNDAMENTALS OF COMPUTER

NPP

118 Fundamentals of Computers NPP

There are many ways the functions can be dH©$erQ> _| \§$ŠeÝg Ho$ Cn`moJ Ho$ H$B© VarH|$ h¡:
used in a worksheet:
1. If you remember the name of the function 1. `{X Amn \§$ŠeZ H$m Zm_ OmZVo h¢ Am¡a Am½`y©_|Q>
and know the arguments, you can directly type OmZVo h¢, Vmo S>m`aoŠQ>cr Amn goc `m \$m°_y©cm ~ma _|
the formula in the cell or at the formula bar. \$m°_y©cm Q>mBn H$a gH$Vo h¢& nhco = gmBZ Q>mBn H$aZm
Don't forget to type = sign first. For example,
when you type =MAX(C1:C20) and press the Zht ^yc|& CXmhaU Ho$ {cE, `{X Amn = MAX (C1 :
Enter key the greatest of values of the cells from C20) Q>mBn H$a B§Q>a H$s àog H$a|Jo, Vmo C1 go C20 goëg
C1 to C20 will be displayed. The expression can _| go A{YH$V‘ d¡ë`y àX{e©V hmo OmEJr& {ZåZX{e©V AZwgma
also be used in a large formula as shown below. EH$ ~‹S>o \$m°_y©co _| EŠgàoeZ H$m ^r Cn`moJ hmo gH$Vm h¡&

= MAX(C1:C20) + MIN(B1:B20)
2. The Formula bar also helps us in using 2. \$m°_y©cm ~ma \§$ŠeÝg Ho$ Cn`omJ _| Am½`y©_|Q> B§gQ>©
functions and inserting arguments. When we H$aZo _| h_mam ghm`H$ h¡& O~ h_ BŠdc gmBZ Q>mBn H$a|Jo
type Equal sign and first letter of the function VWm \§$ŠeZ Ho$ Zm_ H$m àW_ Aja Q>mBn H$a|Jo, eãXm| Ho$
name, the list of functions starting with the
letter appears. We can choose the needed gmW-gmW \§$ŠeÝg {cñQ> ^r {XIZm àma§^ hmo OmEJr&
function from the list as in fig-2.41. Now, type {MÌ-2.41 _| Xem©E AZwgma {cñQ> _| go Amdí`H$ \§$ŠeZ
left parenthesis and select the cells for H$m M`Z H$a gH|$Jo& A~ coâQ> H$moï>H$ Q>mBn H$a| VWm
arguments. The cell references will autom- Am°½`y©_|Q²>g hoVw goëg {gcoŠQ> H$a|& goc ao\$a|gog Am°Q>mo_o{Q>H$cr
atically appear in the formula. Now, closed the \$m°_y©cm _| {XIZo cJ|Jo& A~ H$moï>H$ ~§X H$a X|&
parenthesis.

Fig. 2.41: List of functions appearing in the formula bar

3. Using Commands to create function: 3. \§$ŠeÝg {H«$EQ> H$aZo hoVw H$_m§S²>g H$m à`moJ: \$m°_y©cm
We can use commands to create our functions _| h_mao \§$ŠeÝg {H«$EQ> H$aZo hoVw h_ H$_m§S²>g H$m à`moJ H$a
in the formula. For example, The AutoSum
command in Editing group of the Home tab gH$Vo h¢& CXmhaU Ho$ {cE, hmo_ Q>¡~ Ho$ E{S>qQ>J J«wn _|
contains many function like Sum, Average, Min, AutoSum H$_m§S> _| H$B© \§$ŠeÝg O¡go Sum, Average,
and Max as in fig-2.42. Min VWm Max {MÌ-2.42 _| Xem©E AZwgma em{_c h¡&