Page 120 - FUNDAMENTALS OF COMPUTER

NPP

120 Fundamentals of Computers NPP

by changing the search criteria until the desired ~Xc-~Xc H$a nwZ: gM© H$a gH$Vo h¢& OK na àog H$a|
function is created. Press OK and insert Ed§ S>m`cm°J ~m°Šg H$s ghm`Vm go Am½`y©_|Q²>g B§gQ>© H$a|&
arguments with the help of dialog box.

Review the recommended
results and select a function.
Then Click OK

Fig. 2.44: Insert Function Dialog Box

2.25 Moving and Copying Data 2.25 S>mQ>m _yd Ed§ H$m°nr H$aZm
We can use Cut and Paste commands to H$Q> Ed§ noñQ> H$_m§S²>g Ho$ Cn`moJ go h_ dH©$~wH$ _|
move data from one place to another place in S>mQ>m EH$ ñWmZ go Xÿgao ñWmZ na _yd H$a gH$Vo h¡& H$m°nr
the workbook. The Copy command can also be H$_m§S> Ûmam h_ S>mQ>m H$s _pëQ>nc H$m°nrO H$aZo _| Cn`moJ
used to make multiple copies of the data. The
smallest workbook area which contains our H$a gH$Vo h¢& ñ_m°coñQ> dH©$~wH$ E[a`m {Og_| h_mam S>mQ>m
data is the cell. There are many options for hmoVm h¡, Cgo goc H$hVo h¡& goc Ho$ S>mQ>m H$mo _yd Ed§ H$m°nr
moving and copying data of the cell: H$aZo Ho$ H$B© Am°ßeÝg {ZåZmZwgma h¢:
1. Select the cells to be moved or copied. Press 1. _yd Ed§ H$m°nr {H$E OmZo dmco goëg H$mo {gcoŠQ> H$a|&
Ctrl + x for Cut and Ctrl + c for copy. Now, H$Q> hoVw Ctrl + x Ed§ H$m°nr hoVw Ctrl + c àog H$a|&
place the cursor where you want to put A~ AmnH$mo {Og {H$gr ñWmZ na Amo[aOZc goëg
the contents of the original cell and press Ho$ H§$Q>|Q²>g aIZm hmo, H$g©a co OmE§ Ed§ noñQ> H$aZo
Ctrl + v for Paste. When you select the hoVw Ctrl + v àog H$a|& O~ Amn goëg Ho$ H§$Q>|Q²>g
contents of cells, the action is seen by
dashed rectangle around the area. H$mo {gcoŠQ> H$a|Jo, E[a`m Ho$ Mmamo Amoa EH$ S>¡íS>
a¡ŠQ>|Jc Ûmam EŠeZ {XI OmVm h¡&
2. The action in the step-1 can also be 2. ñQ>on-1 H$s EŠeZ hmo_ Q>¡~ Ho$ ZrMo {XI aho {Šcn
performed using the buttons of the
~moS>© goŠeZ Ho$ ~Q>Ýg Ho$ Cn`moJ go ^r na\$m°_© H$s