Page 135 - FUNDAMENTALS OF COMPUTER

NPP

NPP MS-Word & Excel 135

Q.26. What are the advantage of applying a formula in a workbook? Give example.
dH©$~wH$ ‘| ’$m°‘y©bm Eßbm¶ H$aZo Ho$ bm^ ~VmE§& CXmhaU X|&
Q.27. How Predefined function from the library can be used in a formula? What is Argument?
Give examples and explain.
’$m°‘y©bm ‘| bmB~«oar go àr{S>’$mBÝS> ’§$³eZ H$m H¡$go Cn¶moJ hmo gH$Vm h¡? Am½¶y©‘|Q> ³¶m h¡? CXmhaU X| Ed§
g‘PmE§&
Q.28. How to move contents of cells or sheets at different places in the workbook?

dH©$~wH$ ‘| gob Ho$ H§$Q>|Q²>g erßQ²>g ¶m {d{^Þ ñWmZm| na H¡$go ‘yd hm|Jo?
Q.29. Explain in detail how rows and columns can be inserted in an existing sheet?

dV©‘mZ erQ> ‘| go amo Ed§ H$m°båg H¡$go BÝgQ>© hm|Jo? {dñVma go ~VmE§&
Q.30. Explain in detail how rows and columns can be deleted from an existing sheet?
dV©‘mZ erQ> ‘| go amo Ed§ H$m°båg H¡$go {S>{bQ> hm|Jo? {dñVma go ~VmE§&
Q.31. Enlist the steps to create Charts from the data of a sheet in Excel.

E³gob ‘| erQ> Ho$ S>mQ>m go MmQ>© {H«$EQ> H$aZo H$s à{H«$¶m H$mo MaU~Õ VarHo$ go ~VmE§&
Q.32. Describe different parts of a Chart in detail.

MmQ>© Ho$ {d{^Þ ^mJm| H$m {dñV¥V dU©Z H$a|&
Q.33. What do you mean by "Chart Tools"? What are the tabs in 'Chart Tools'? Explain their use.
''MmQ>© Qy>ëg'' go AmnH$m ³¶m Ame¶ h¡? MmQ>© Qy>ëg ‘| H$m¡Zgr Q>oãg hmoVr h¢? CZH$s Cn¶mo{JVm H$m dU©Z H$a|&
Q.34. What is 'Page Setup' group? Explain how page margin can be set by this group.

'noO goQ>An J«wn' ³¶m h¡? Bg J«wn Ûmam noO ‘m{O©Z H¡$go goQ> hmoVm h¡?
Q.35. Explain how Headers/Footers can be added in a worksheet. What is Custom Header/Footer
option?

dH©$erQ> ‘| hoS>g©/’w$Q>g© H¡$go ES> {H$E OmVo h¢? dU©Z H$a|& H$ñQ>‘ hoS>a/’w$Q>a Am°ßeZ ³¶m h¡?
Q.36. What is Print Preview of a Worksheet in excel? What properties it allows to change before
printing a worksheet?
E³gob ‘| dH©$erQ> H$m qàQ>ì¶y ³¶m hmoVm h¡? dH©$erQ> ‘| qàQ> H$aZo go nyd© H$m¡Zgr àm°nQ>uO go BZ‘| n[adV©Z {H$¶m
Om gH$Vm h¡?
Q.37. How Title rows can be repeated in each page of a worksheet during printing?

qàqQ>J Ho$ Xm¡amZ dH©$erQ> Ho$ à˶oH$ noO na Q>mBQ>b amo (n§p³V¶m§) {H$g àH$ma [anrQ> hmoVr h¡?
Q.38. What are Gridlines? How these lines can be removed from printout?
{J«S>bmBÝg ³¶m h¢? qàQ>AmCQ> go BÝh| {H$g àH$ma [a‘yd {H$¶m Om gH$Vm h¡?