Page 110 - FUNDAMENTALS OF COMPUTER

NPP

110 Fundamentals of Computers NPP

1987. The latest version is Excel 2016. Excel is ZdrZV_ de©Z EŠgoc-2016 h¡& EŠgoc H$m Cn`moJ g§ñWmZm|
extensively used by organizations to enter their Ûmam AnZo S>mQ>m, S>mQ>m Ho$ H¡$cŠ`ycoeZ H$aZo, S>mQ>m H$m
data, perform calculations on these data, {díbofU H$aZo, {d{dY [anmoQ>© ~ZmZo VWm {díbofU S>mQ>m Ho$
analyze the data, create various reports, and
prepare charts from the analyzed data. MmQ²>©g ~ZmZo _| {H$`m OmVm h¡&

2.19 Introduction to workbook and 2.19 dH©$~wH$ VWm dH©$erQ> H$m n[aM`
work-sheet

A workbook is a file that contains many dH©$~wH$ EH$ \$mBc hmoVr h¡, {Og_| g§~§{YV S>mQ>m
worksheets keeping interrelated data. Each aIZo H$s H$B© dH©$erQ²>g hmoVr h¢& àË`oH$ dH©$erQ> _| n§p³V¶m±
worksheet contains a grid of rows and columns. Ed§ H$m°c_ H$s EH$ {J«S> hmoVr h¡& n§p³V 1, 2, 3 VWm
The rows are numbered as 1, 2, 3, and so on and H«$_e: AmJo Ed§ H$m°cåg A, B, C… Z, AA, AB,… Ed§
the columns are named as A, B, C… Z, AA,
AB,… and so on. To create a new workbook just H«$_e: AJ«H«$_ _| hmoVo h¢& ZB© dH©$~wH$ {H«$EQ> H$aZo hoVw
click on the Office button at the top left corner EŠgoc qdS>mo Ho$ Q>m°n coâQ> H$m°Z©a Ho$ Am°{\$g ~Q>Z H$mo
of the Excel window and then click on the New pŠcH$ H$a| VWm ~mX _| Ý`y ~Q>Z na pŠcH$ H$a|& O~ {MÌ-
button. When a dialog box appears as in fig- 2.32 _| Xem©E AZwgma S>m`cm°J ~m°Šg gm_Zo AmEJm,
2.32, Double-Click on 'Blank Workbook' to get {MÌ-2.33 _| Xem©E AZwgma ZB© dH©$~wH$ IwcVo hr 'ãc¢H$
a new workbook opened as in fig-2.33. By default dH©$~wH$' na S>~c pŠcH$ H$a|& {S>\$m°ëQ> Ûmam VrZ dH©$erQ²>g
three worksheets Sheet1, Sheet2, and Sheet3
are opened in a workbook but we can add more erQ>-1, erQ>-2 VWm erQ>-3 dH©$~wH$ _| Iwc OmE§Jr
by clicking on the right side of Sheet3. We can na§Vw h_ erQ>-3 Ho$ amBQ> gmBS> na pŠcH$ na Bg_| Am¡a
also rename the worksheet by right clicking on ^r H$B© ES> H$a gH$Vo h¢& dV©_mZ Zm_m| na amBQ> pŠcH$ H$a
the existing name. h_ dH©$erQ²>g H$mo arZo_ ^r H$a gH$Vo h¢&

Fig. 2.32: Opening a New Workbook