Microsoft Office 2007 Past Exam Papers PDF

Tilak Maharashtra Vidyapeeth 2016 Microsoft Office 2007 MS-OFFICE ~Xb WmoS>ogo Amnë`m X¡Z§{XZ Business _Ü`o, Office _Ü`o, H$m`m©b`m_Ü`o Ho$bo OmUmao H$m_ AmVm H$m°åß`wQ>a Ho$bo OmVo. Computer Mm dmna `m H$m_mgmR>r Ho$ë`m_wio H$m_mV AMwH$Vm `oVo. Computer da...

Tilak Maharashtra Vidyapeeth 2016 Microsoft Office 2007 MS-OFFICE ~Xb WmoS>ogo Amnë`m X¡Z§{XZ Business _Ü`o, Office _Ü`o, H$m`m©b`m_Ü`o Ho$bo OmUmao H$m_ AmVm H$m°åß`wQ>a Ho$bo OmVo. Computer Mm dmna `m H$m_mgmR>r Ho$ë`m_wio H$m_mV AMwH$Vm `oVo. Computer da Ho$bobo _Yrb H$m_ `mbmM Am°{\$g A°Q>mo_oeZ (Office Automation) Ago åhUVmV. Documentation, Calculation, Presentation `m {d{dY H$m_mgmR>r Microsoft `m H§$nZrZo EH$ Package V`ma Ho$bo Amh. Ë`mbmM MS-Office åhUOoM Microsoft Ago åhUVmV. MS-Office À`m Amd¥Ë`m 1) MS-Office 4.3 2) MS-Office 97 3) MS-Office 2000 4) MS-Office XP 5) MS-Office 2003 6) MS-Office 2007 MS-Office _Yrb Application 1) MS-World 2) MS-Excel 3) MS-PowerPoint 4) MS-Access 5) MS-Outlook 6) MS-FrontPage MS-OFFICE Manual Page 1  Tilak Maharashtra Vidyapeeth 2016 Microsoft Word MS-Word Mr d¡{eîQ²>`o 1) Q>mB©n Ho$boë`m _°Q>aMr ì`dpñWV _m§S>Ur H$aUo, n°aJo «m\$ VgoM XmoZ bmB©Z_Ü`o `mo½` A§Va R>odUo 2) EH$Xm Q>mB©n Ho$bobm _°Q>a H$mhr Xwê$ñVr H$amd`mMr Agë`mg Vr H$aVm `oVo. 3) ho AmnmoAmn ñnoqbJ MoH$ H$aVo 4) EH$Xm Q>mB©n Ho$boë`m _°Q>aÀ`m AZoH$ à{V H$mT>Vm `oVmV. 5) _°Q>a \$mB©b_Ü`o goìh H$ê$Z R>odVm `oVmo. OoUoH$ê$Z Vmo Ho$ìhmhr AmonZ H$ê$Z qàQ> H$mT>Vm `oVo. 6) Amdí`H$Vo à_mUo {MÌ, {d{dY AmH¥$Ë`m, AmboI B. _°Q>a_Ü`o Q>mH$Vm `oVmV. MS-Word Start-> Programs -> Microsoft Office -> Microsoft Office Word 2007 MS-Word gwê$ Pmë`mda Imbrb JmoîQ>r {XgVmV. 1) Title Bar - Microsoft Word À`m {dS>moO_Ü`o gdm©V da Document1- Microsoft word Ago Q>m`Q>b Agbobr {Zir nQ²>Q>r {XgVo. `mbmM Q>m`Q>b ~ma Ago åhUVmV. `m dê$Z AmnU H$moUV`m \$mB©b_Ü`o d H$moUË`m A°pßbHo$eZ (ñnm°âQ>doAa) _Ü`o H$m_ H$arV AmhmoV Ë`m~X²>Xb _m{hVr H$iVo. Q>m`Q>b~ma À`m gdm©VeodQ>r COì`m hmVmg Minimeximize /Restore Am{U Close ho ~Q>Êg AgVmV. MS-OFFICE Manual Page 2  Tilak Maharashtra Vidyapeeth 2016 2) Menu Bar - Ms -Word _Ü`o AmnU Á`m gw{dYm dmnaVmo Ë`m Options `m ñdê$nmV dmnaVmo. Ho Am°ßeÝgMm Zwgma doJdoJù`m _oZw_Ü`o g_mdoe H$aÊ`mVAmbm Amho. CXm. File, Edit, View, Insert, Format… B. 3) Standard Toolbar - Standard Toolbar da File _oZwVrb d BVa H$mhr _oZwVrb Am°ßeZ `mMo em°Q>©H$Q²>g> ~Q>Êg AgVmV Á`m Am°ßeZ Mm dmnaZoh_r hmoVmo Ë`m§Zm _oZw_YyZ dmnaÊ`mg Omo doi bmJVmo Vmo dmMmdm åhUyZ hm Qw>b~ma ~ZdÊ`mV Ambm Amho. 4) Formatting Toolbar- Formatting Toolbar `m eãXmda à{H«$`m H$aUmam Qw>b~ma Amho Ogo H$s eãXm§Zm ~moëS>, BQ>mbrH$H$aUo, dmŠ`m§Zm ì`dpñWV goQ> H$aUo, eãXm§Zm doJdoJù`m ñQ>mB©b_Ü`o goQ>H$aUo d eãXm§Mr gmB©O bhmZ _moR>r H$aUo B. 5) Ruler Line - ê$ba bmB©Z åhUOo EH$ àH$maMr ñHo$b (_moOnQ²>Q>r ) Amho. Ms- World _Ü`o KoVboë`m Left, Right, Top, Bottom _m{O©Z {H$Vr gmoS>m`Mr ho H$iVo. VgoM Q>m°n goQ>tJ {H$Vr A§Vamda H$am`Mr ho g_OVoo. 6) Scroll Bar - Amnë`mbm EH$mdoir nmZmMm g§nwU© ^mJ ñH«$sZda {XgV ZgVm. Aem doir Ë`m ^mJmbm Imbr da COdrH$S>o, S>mdrH$S>o gaH${dÊ`mgmR>r Scroll bard Mm Cn`moJ hmoVmo. 7) Cursor - g_moa {XgUmao noOda EH$ bwH$bwH$ (pãb¨H$)H$aUmar C^r aofm {XgVo {Vbm H$g©a Ago åhUVmV. Vr Á`m {R>H$mUr Amho VoWyZ Vwåhr Q>mB©n H$ê$ eH$Vm qH$dm VoWyZ AjaImoS>y XoIrb eH$Vm. 8) Drawing Toolbar - S>´m°BªJ Qw>b~ma da Insert Menu Vrb Am°ßeÝgMo em°Q©H$Q²>g AgVmV. Ë`mMm dmna H$ê$Z S>m°Š`w_|Q> _Ü`o AmH¥$Ë`m pŠbn AmQ>©, Q>mH$Vm `oD$ eH$VmV. MS-OFFICE Manual Page 3  Tilak Maharashtra Vidyapeeth 2016 Document _Ü`o Q>mH$bobm Am`V, dVwi © , ñQ>ma B. AmH¥$Ë`m§Zm a§J> XoÊ`mgmR>r,Am{U 3D-B\o$ŠQ> XoÊ`mgmR>r hr ~Q>Uo AgVmV. 9) Status Bar - pñH«$Zda gdm©V Imbr EH$ AmS>dr nQ²>Q>r {XgVo Ë`m nQ²>Q>rbm Status Bar Ago åhUVmV. AmnU gÜ`m H$moUË` nmo{OeZbm H$m_ H$aV AmhmoV Vo `m dê$Z g_OVo. VgoM Amnbm H$g©a gÜ`m H$moUË`m {R>H$mUr Amho ho hr g_OVo. CXm. Page 3 `mMm AW© H$g©a nmZ Z§. 3 da Amho. 3/10 `mMm AW© S>m°Š`w_oQ> _Ü`o EHy$U 10 nmZo AmhoV d Ë`mVrb 3 è`m nmZmda AmnU H$m_ H$arV AmhmoV. File Menu 1) New (Ctrl+N)- ZdrZ ZdrZ H$moar \$mB©b CKS>Ê`mgmR>r`m Am°ßeZMm Cn`moJ hmoVmo. 2) Save (Ctrl + S) AmnU V`ma Ho$bobr \$mB©b word _Yrb \$mB©b goìh H$aÊ`mgmR>r Save hm Option dmnaVmV. Oa Amnë`m \$mB©bbm AJmoXa Zmd {Xbobo Agob Va Ë`m \$mB©b_Ü`o Oo ~Xb goìho Ho$bo OmVrb, Va \$mB©bbm Zmd {Xbobo Zgob Va save as Mm S>m`bm°J ~m°Šg g_moa {Xgob Ë`mV \$mB©bMo Zmd Q>mB©n H$éZ VgoM bmoHo$eZ XodyZ OK ~Q>U Xm~mdo. 3) Save as – gÜ`m Mmbw Agboë`m \$mB©bbm AmUIr EH$m Xwgè`m ZmdmZo goìh H$am`Mo Agë`mg hm Option dmnaVmV. Ë`mgmR>r 1) File -> save as 2) Save in g_moa Amnë`mbm Á`m \$moëS>a_Ü`o Document goìh H$am`Mo Agob Ë`m \$moëS>aMo Zmd {gboŠQ> H$amdo. 3) File Name `m ~m°Šg _Ü`o File bm H$moUVo Zmd Úm`Mo Vo Zmd Q>mB©n H$am. 4) Ë`m Z§Va Save ~Q>U Xm~mdo. MS-OFFICE Manual Page 4  Tilak Maharashtra Vidyapeeth 2016 4) Open (Ctrl+O) ApñVËdmV Agboë`m \$mB©ëgn¡H$s EImXr \$mB©b CKS>Ê`mgmR>r Open hm Am°ßeZ dmnaVmV. 1) File -> Open 2) Look in `m g_moa Amnë`mbm Á`m Folder _Yrb File CKS>md`mMr Amho Vo Folder {gboŠQ> H$amdo. 3) Ë`m \$moëS>a _Yrb gd© \$mB©b²gMr {bñQ> g_moa {Xgob. Ë`mVrb hdr Agbobr \$mB©b pŠbH$ H$am. 4) Open ~Q>U Xm~m. 5) Close – CKS>bobr qH$dm gÜ`m H$m_ H$aV Agbobr \$mB©b ~§X H$aÊ`mgmR>r Close hm Am°ßeZ dmnaVmV. 6) Page Setup - `m Am°ßeZZo Vwåhr ZdrZ \$mB©b_Ü`o H$m_ gédmV H$aÊ`mnwdu àW_ Amnë`mbm nmZmMr gd© goQ>tJ H$amdr bmJVo Am{U Vr goQ>tJ Page Setup hm Am°ßeZ dmnéZ H$aVmV. Page setup _Ü`o Vwåhr Margin, Papersize, Layout _Ü`o Vwåhmbm noO C^o nm{hO H$s AmS>do ho gd© Am°ßeZ Vwåhr Page setup _Ü`o dmnaVm `oVmV. Margins - _m{O©Z åhUOo g_mg. `m_wio noOÀ`m COì`m, S>mì`m, daÀ`m d ImbÀ`m gd© ~mOy§Zm H$moar OmJm gmoS>md`mMr goQ>tJ H$aVm `oVo. Top - nmZmÀ`m daMm g_mg {H$Vr nmhrOo ho Top Margin `oWyZ R>adVm `oVo. Bottom - nmZmÀ`m ImbMm g_mg {H$Vr nm{hOo ho Bottom Margin `oWyZ R>adVm `oVo. Left - nmZmÀ`m S>mì`m ~mOyMm g_mg {H$Vr nmhrOo ho Left Margin `oWyZ R>adVm `oVo. Right - nmZmÀ`m COì`m ~mOyMm g_mg {H$Vr nmhrOo ho Right Margin `oWyZ R>adVm `oVo. Gutter - `m Am°ßeZìXmao Binding gmR>r Left Margin ì`{V[aŠV H$mhr A§Va gmoS>Vm `oVo. Aem A§Vamg Gutter Ago åhUVmV. MS-OFFICE Manual Page 5  Tilak Maharashtra Vidyapeeth 2016 Paper Size – A4, Legal, Letter, Envolope B. àH$maÀ`m nona gmB©O Ms-word _Ü`o CnbãY AmhoV. Ë`mVrb nm{hOo Vr gmB©O {ZdS>Vm `oVo. Orientation – Orientation _YyZ H$mJXmMr _mS>Ur C^r (Portrait) qH$dm AmS>dr (Landscape ) R>adVm `oVo. 7) Print Preview -`m H$_m§S>Zo Vwåhr V`ma Ho$bobo Document Printing _Ü`o H$go `oB©bVo nmhVm `oVo. 8) Print - Ooìhm Vwåhmbm \$mB©bMr qàQ> H$mT>m`Mr Agob Voìhm Vr \$mB©b AmonZ H$ê$Z hr H$_m§S> dmnabr OmVo. 9) Exist - `m H$_m§S>À`m ghmæ`mZo Ms - Word _YyZ ~mhoa nS>Vm `oVo. na§Vw Mmbw \$mB©b goìh Ho$bobr Zgë`mg EH$ Message `oVmo, Do you want to save the changes Yes or No ? Aem doir ~Xb goìh H$amd`Mo Agë`mg Yes ~Q>U Xm~m ~Xb goìh H$am`Mo Zgë`mg No ho ~Q>U Xm~m. Edit Menu 1) Undo (Ctrl+ Z)- `m AmYr Ho$bo H$m_ Cancel H$aÊ`mgmR>r hm Am°ßeZ dmnaVmV. 1) Redo (Ctrl+ Y)- `m AmYr Ho$bo H$m_ Cancel H$aÊ`mgmR>r hm Am°ßeZ dmnaVmV. Save hm Option dmnaVmV. Oa Amnë`m \$mB©bbm AJmoXa Zmd {Xbobo Agob Va Ë`m \$mB©b_Ü`o Oo ~Xb goìho Ho$bo OmVrb, Va \$mB©bbm Zmd {Xbobo Zgob Va save as Mm S>m`bm°J ~m°Šg g_moa {Xgob Ë`mV \$mB©bMo Zmd Q>mB©n H$éZ OK ~Q>U Xm~mdo. 3) Save as – gÜ`m Mmbw Agboë`m \$mB©bbm AmUIr EH$m Xwgè`m ZmdmZo goìh H$am`Mo Agë`mg hm Option dmnaVmV. Ë`mgmR>r 1) File -> save as MS-OFFICE Manual Page 6  Tilak Maharashtra Vidyapeeth 2016 2) Save in g_moa Amnë`mbm Á`m \$moëS>a_Ü`o Document goìh H$am`Mo Agob Ë`m \$moëS>aMo Zmd {gboŠQ> H$amdo. 3) File Name `m ~m°Šg _Ü`o File bm H$moUVo Zmd Úm`Mo Vo Zmd Q>mB©n H$am. 4) Save ~Q>U Xm~mdo. 4) Cut & Paste – \$mB©b_Yrb EImXm _OHw$a, {MÌ qH$dm Autoshape EH$m OmJodéZ Xwgè`m OmJoda Copy H$amd`mMm Agë`mg Imbrb ñQ>oßg dmnam. 1) àW_ Vmo _°Q>a qH$dm {MÌ {gboŠQ> H$am. 2) Edit -> Copy qH$dm Ctrl+C ~Q>U Xm~m. 3) Copy Ho$bobm _°Q>a {OWo Paste H$am`Mm Amho, VoWo Cursor Ý`m. 4) Edit -> Paste qH$dm Ctrl+V ~Q>U Xm~m. 5) Clear- {gboŠQ> Ho$bobm _°Q>a H$mTy>Z Q>mH$Ê`mgmR>r hm Am°ßeZ dmnaVmV. Ë`mgmR>r {H$~moS>©darb Delete H$s dmnabr Var MmbVo. 6) Select All (Ctrl+A) – Vw_À`m Document _Yrb gd© _OHw$a EH$mM doir {gboŠQ> H$aÊ`mgmR>r Select All dmnaVmV. 7) Find (Ctrl+F) - `m Am°ßeZÀ`m gmhmæ`mZo Vwåhmbm Document _Yrb EImÚm _OHw$am_Yrb nmhrOo VmoM eãX emoYmd`mMm Agë`mg Vmo emoYVm `oVmo. MS-OFFICE Manual Page 7  Tilak Maharashtra Vidyapeeth 2016 8) Replace - `m Am°ßeZÀ`m gmhmæ`mZo Find Ho$boë`m eãXm§EodOr Xwgam eãX ~Xbw eH$Vmo. 9) Go To - `m Am°ßeZÀ`m gmhmæ`mZo AmnU Document _Ü`o H$moUË`mhr Page da, Line da, Table da, Section da EH$X_ OmD$ eH$Vmo. View Menu 1) Normal - `m H$_m§S>ìXmao \$mB©b_Yrb _OHy$a hm Normal View _Ü`o {Xgw bmJVmo. Oa hm Am°ßeZ Agob Voìhm Typing d Formatting Mo H$m_ A{YH$ gmono hmoVo. \$ŠV `m_Ü`o Vwåhmbm Page Setting, (Ruler Line déZ Left, Right Margin goQ> H$aUo B.) H$aVm `oUma Zmhr. 2) Web Layout View - `m H$_m§S>ìXmao dS>©_Yrb EImXo S>m°Š`w_|Q> Web Browser _Ü`o Ogo {Xgbo ho nhm`Mo Agë`mg `m H$_m§S>Mm dmna H$amdm. 3) Print Layout - `m H$_m§S>ìXmao Vwåhr Mmby \$mB©b _Yrb _OHy$amÀ`m nmZmdarb pñWVr A{YH$ AMyH$ H$iw eH$Vo. H$maU {àÝQ> boAmD$Q> `m H$_m§S> _Ü`o Vertical d Horizontal `m XmoÝhr Ruler Lines {XgV AgVmV. 4) Outline View - `m H$_m§S>ìXmao Vwåhr Mmby \$mB©b_Yrb _OHw$amMr gmYmaU Outline R>adVm `oVo. OmñV bm§~rMm O_Hy$a H«$_mZo bmdÊ`mgmR>r `m ìô`wMm Cn`moJ hmoVmo. Insert Menu MS-OFFICE Manual Page 8  Tilak Maharashtra Vidyapeeth 2016 1) Break – H$mhr doim EImÚm H$m°b__Ü`o qH$dm noO_Ü`o Imbr EImXo {MÌ, \$moQ>mo, A°Q>moeon Q>mH$Ê`mgmR>r _moH$ir OmJm gmoS>mdr bmJVo. VgoM EH$m Chapter Mm _°Q>a nmZmÀ`m AÜ`m©daM g§nVmo. AmVm Ë`mnwT>rb ZdrZ Chapter Mr gwédmV ZdrZ nmZmda H$am`Mr Agë`mgm Vmo Page qH$dm Column Break H$amdm bmJVmo. Ë`mgmR>r Insert -> Break hm Am°ßeZ dmnamdm. 2) Page Numbers – Amnë`m S>m°Š`w_|Q>À`m àË`oH$ nmZmda> Printing H$aVodoir Page Number `oÊ`mgmR>r `m Am°ßeZMm Cn`moJ H$amdm. Ë`mV Imbrb n`m©` AgVmV. Position - Top of the Page (Header) Bottom of the Page (Footer) Alignment - Left / Right qH$dm center Inside qH$dm Outside 3) Symbols - `m Am°ßeZÀ`m ghmæ`mZo Document _Ü`o Cursor Position À`m OmJr Windows Zo nwadbobo EImXo {MÝh qH$dm Special Character Insert H$aVm `oVo. Ë`mgmR>r a) àW_ Cursor bm Position Úm. b) Insert -> Symbol pŠbH$ H$am. c) Dialogue Box _Yrb Font _Ü` Wingdings, Webdings `mn¡H$s EImXm {ZdS>m d) nm{hOo Ë`m {gå~m°bbm pŠbH$ H$éZ OK ~Q>U Xm~m. 4) Picture - Insert _oZw_Yrb `m H$_m§S>À`m _XVrZo Amnë`m Document _Ü`o ClipArts, Auto Shapes,Word Arts, Scanner Scan Ho$bobo {MÌ B. Q>mH$Vm `oVmV. MS-OFFICE Manual Page 9  Tilak Maharashtra Vidyapeeth 2016 Clip Art – hm Am°ßeZ pŠbH$ Ho$bo AgVm Amnë`mbm Ms-word _Ü`o V`ma Agboë`m {MÌm§Mr `mXr {Xgob. Ë`mVrb H$moUË`mhr {MÌmda pŠbH$ H$am åhUOo Vo {MÌ Document _Ü`o Ambobo {Xgob. From File - `m Am°ßeZÀ`m _XVrZo H$m°åß`wQ>a_Ü`o goìh Agbobo \$moQ>moJ«mâg qH$dm BVa {nŠMa \$mB©b BÝgQ>© H$aVm `oVo. Ë`mgmR>r Insert -> Picture -> From File -> \$mB©b emoYm -> Insert ~Q>U Xm~m. Auto Shapes – dS>©_Ü`o Agboë`m AmH¥$Ë`m BÝgQ>© (g_m{dîQ>) H$aVm `oVmV. CXm. à. EImÚm Autoshape _Ü`o _°Q>a H$gm Q>mB©n H$amdm. CËVa - 1) Ë`m Auto shape da _mD$g nmB©ÝQ>a ZoD$Z amB©Q> ~Q>U Xm~m. 2) g_moa `oUmè`m {bñQ> _YyZ Add Text hm Am°ßeZ pŠbH$ H$am. åhUOo Cursor A°Q>moeonÀ`m _Ü`o bwH$ bwH$ H$aVmZm {Xgob. VoWo Amnbm _°Q>a Q>mB©n H$am. àíZ. EImXo {MÌ qH$dm Autoshape EH$m OmJodéZ Xwgè`m OmJoda H$go hbdmdo? CËVa - 1) àW_ Ë`m {MÌmda pŠbH$ H$am. 2) Format -> Picture -> Layout Q>°~ pŠbH$ H$am. 3) Z§Va MS-OFFICE Manual Page 10  Tilak Maharashtra Vidyapeeth 2016 `mn¡H$s Behind Text qH$dm Infront of Text hm n`m©` pŠbH$ H$am. Am{U OK ~Q>U Xm~m. 4) Z§Va {MÌmda _mD$g nm°B©ÝQ>a Zobm AgVm. Vmo (\$moa hoS>oS> A°amo) _Ü`o ~Xbbm OmVmo. Vmo VgmM pŠbH$ H$éZ S´>°J H$amdm. Format Menu Matter Mo Formatting åhUOo _°Q>aMr OmJm R>adUo, EImXm _°Q>a R>iH$ (Bold), AYmoao{IV (Underline), doJ doJù`m diUm§Mm H$aUo, doJdoJù`m gmB©OMm hdm Agob Va Ë`m _°Q>abm Vo B\o$ŠQ> XoUo `m gd© à{H«$`m§Zm \$m°a_°Q>tJ Ago åhUVmV. à- _°Q>aMr AbmB©Z_|Q> H$er H$amdr ? CËVa - gd© àW_ Á`m _°Q>aMr AbmB©Z_|Q> H$am`Mr Amho Ë`mda ŠbrH$ H$éZ H$g©a VoWo AmUmdm Z§Va...... n{hbr nÜXV- nÜXV-> 1) Format Menu Vrb Paragraph Option ŠbrH$ H$am. 2) g_moaÀ`m S>m`bm°J ~m°Šg _Yrb Alignment `m Combo-box _YwZ Left, Right, Centered qH$dm Justified `mn¡H$s hdm Vmo Am°ßeZ {ZdSy>Z OK pŠbH$ H$am. Xwgar nÜXV - Formatting Toolbar darb Imbrb ~Q>Um§Mm dmna H$amdm. MS-OFFICE Manual Page 11  Tilak Maharashtra Vidyapeeth 2016 {Vgar nÜXV - Key Board Short Cut key dmnéZ Ctrl + L - Left Alignment Ctrl + R - Right Alignment Ctrl + E - Center Alignment Ctrl + J - Justify Alignment àíZ XmoZ Amoit_Yrb A§Va H$go dmT>dmdo ? CËVa - gd© àW_ _°Q>a {gboŠQ> H$éZ ¿`mdm Z§Va n{hbr nÜXV 1) Format Menu Vrb Paragraph Option ŠbrH$ H$am. 2) g_moaÀ`m S>m`bm°J ~m°Šg _Yrb Line Spacing `m Combo-box _YyZ Single, 1.5 Line, Double, Multiple, At Least qH$dm Exactly `mn¡H$s hdm Vmo Am°ßeZ {ZdSy>Z OK pŠbH$ H$am. Xwgar nÜXV - Key Board Cut key dmnéZ Ctrl + 1 Single Ctrl + 2 Double Ctrl + 5 1.5 Lines àíZ - Ajam§Mr Size, Font, Font Style, Font B. H$go ~Xbmdo ? CËVa – 1) Size ~XbUo n{hbr nÜXV - Format -> Font -> Size MS-OFFICE Manual Page 12  Tilak Maharashtra Vidyapeeth 2016 Xwgar nÜXV - Formatting Tool bar darb Font Size `m ~Q>Umda pŠbH$ H$amdo. {Vgar nÜXV - Shortcut Keys dmnéZ Size dmT>{dÊ`mgmR>r Ctrl + ] Size H$_r H$aÊ`mgmR>r Ctrl + [ 2) Font Style ~XbUo n{hbr nÜXV - Format -> Font -> Size Regular - gmYo Ajao H$aÊ`mgmR>r Bold - R>iH$ Ajao H$aÊ`mgmR>r Italic - {Vanr Ajao H$aÊ`mgmR>r Bold Italic - R>iH$ d {Vanr Ajao H$aÊ`mgmR>r Xwgar nÜXV - Formatting Tool bar darb `m ~Q>Umda pŠbH$ H$amdo. {Vgar nÜXV - Key Board Short Cut key dmnéZ Bold - Ctrl + B Italic - Ctrl + I Underline - Ctrl + U 3) Font ~XbZo - \$m°ÝQ> åhUOo Ajam§Mo diU {Vgar nÜXV - Format -> Font -> Font CXm. Times New Roman Arial Courier New MS-OFFICE Manual Page 13  Tilak Maharashtra Vidyapeeth 2016 Monotype Cursivle Impact Xwgar nÜXV - Formatting Toolbar darb `m H$å~mo ~m°Šg da pŠbH$ Ho$bo AgVm doJ doJio \$m°ÝQ> Ë`m§À`m {d{dY diUm§gh {XgVrb Ë`mVrb `mo½` pŠbH$ H$amdm. {Vgar nÜXV – Ctrl + D hr em°Q>©H$Q> H$s dmnabr AgVm Font gmR>rMm S>m`bm°J ~m°Šg Open hmoVmo. 4) Ajam§Zm a§J XoÊ`mgmR>r Format -> Font -> Font Color qH$dm Formatting Toolbar darb `m H$å~mo ~m°Šg da pŠbH$ H$éZ 5) Ajam§Zm BVa H$mhr B\o$ŠQ²>g XoÊ`mgmR>r A. H«$. B\o$ŠQ> CXmhaU A) Strike Through Lux Rs. ? 12.00 Am) Double Strike Through Lux Rs. ? 12.00 B) Super Script Coca-Colatm, 25=32, 21st B©) Sub Script H2SO4, H2O MS-OFFICE Manual Page 14  Tilak Maharashtra Vidyapeeth 2016 C) Shadow TMV D$) Outline E) Emboss TTM MVV Eo) Engrave T TMMV V Amo) Small Caps tilak maharashtra vidyapeeth Am¡) All Caps TILAK MAHARASHTRA VIDYAPEETH 6) XmoZ Ajam§_Yrb A§Va H$_r OmñV H$aUo Ajam§Zm {gboŠQ> H$éZ Format -> Font ho Am°ßeZ {ZdS>mdo. Z§Va g_moa {XgUmè`m S>m`bm°J ~m°Šg _Yrb Line Spacing hm Tab pŠbH$ H$am. Ë`mVrb. Spacing g_moarb Expanded ho Am°ßeZ {ZdS>ë`mg Ajam§_Yrb A§Va dmT>ob Am{U Condensed ho Am°ßeZ {ZdS>ë`mg Ajam§_Yrb A§Va H$_r hmoB©b. Scale _Yrb Percentage +, - OmñV Ho$ë`mg Ajam§Mr OmS>r +, - hmoVo. Position g_moarb Raised ho Am°ßeZ {ZdS>ë`mg {gboŠQ> Ho$bobr Ajao da gaH$Vrb Am{U Lowered ho Am°ßeZ {ZdS>ë`mg {gboŠQ> Ho$bobr Ajao Imbr gaH$Vrb 7) Animation Effects _°Q>aMo àoPoÝQ>oeZ A{YH$ AmH$f©H$ hmoÊ`mgmR>r Ë`mbm Animation Effect hr XoVm `oVmV. Ë`mgmR>r _°Q>a {gboŠQ> H$éZ Format -> Font -> Text -> Effects hm Q>°~ pŠbH$ H$am. MS-OFFICE Manual Page 15  Tilak Maharashtra Vidyapeeth 2016 8) Bullets And Numbering – S>m°Š`w_oÝQ> _Yrb `mXrbm Bullets qH$dm Z§~atJ XoÊ`mgmR>r A) àW_ Vr list {gboŠQ> H$am. Am) Z§Va Format -> Bullets and Numbering hm Am°ßeZ pŠbH$ H$am. B) g_moa {XgUmè`m S>m`bm°J ~m°Šg _YyZ `mo½` ñQ>mB©b {ZdS>m 9) Border and Shading – noObm qH$dm n°aoJ«m\$, Q>o~b B. bm ~m°S>©a XoÊ`mgmR>r `m Am°ßeZMm dmna H$aVmV. Ë`mgmR>r Format -> Border and Shading -> Page Border Setting - None - {Xbobr ~m°S>©a H$mTy>Z Q>mH$Ê`mgmR>r Box - Page ^modVr ~m°Šg `oVmo. Shadow - Border bm Shadow `oVo 3D - 3 Dimensional Effect Border Style – {d{dY àH$maÀ`m ~m°S>©g© Color - ~m°S>©aMm H$ba ~XbÊ`mgmR>r Width - ~m°S>©aMr OmS>r H$_r-OmñV H$aÊ`mgmR>r MS-OFFICE Manual Page 16  Tilak Maharashtra Vidyapeeth 2016 Art - _Yrb doJdoJio S>rPmB©Ýg dmnéZ b½Z n{ÌHo$gmaIr AmH$f©H$ ~m°S>©a Q>mH$Vm `oVo. 10) Columns - \$m°a_°Q>_Ü`o Columns Q>mH$Ê`mgmR>r ñQ>oßg - A) gd©àW_ _°Q>a EH$ gbJ Q>mB©n H$éZ ¿`mdm. Am) Z§Va Amnë`mbm Omo _°Q>a H$m°b_ \$m°a_°Q>_Ü`o ¿`m`Mm Amho Vmo. Select H$amdm. B) Format -> Columns pŠbH$ H$am. (i) Presets - `m_Ü`o Amnë`mbm _°Q>a One, Two, Three, Left, Right `m n¡H$s H$moUË`m àH$mamV ~gdm`À`m Vo R>adVm `oVo. (ii) No. of Columns – VrZnojm OmñV H$m°båg hdo AgVrb Voìhm dmnamdo. (iii) Spacing - XmoZ H$m°b_ _Yrb A§Va H$_r OmñV H$aÊ`mgmR>r (iv) Width - H$m°b_Mr OmS>r {ZpíMV H$aÊ`mgmR>r (v) Line Between – XmoZ H$m°båg_Ü`o C^r bmB©Z hdr Agë`mg Ë`m g_moarb MoH$ ~m°Šg _Ü`o √ pŠbH$ H$amdo. MS-OFFICE Manual Page 17  Tilak Maharashtra Vidyapeeth 2016 11) Drop Cap - Ý`wOnona qH$dm _°JPrZ_Ü`o gd©gmYmaUnUo _°Q>aÀ`m AJXr gwédmVrMo Aja BVa Characters nojm AmH$mamZo WmoS>o _moR>o d H°${nQ>b_Ü`o AgVo. 1) àW_ _°Q>a {gboŠQ> H$amdm. 2) Format -> Drop Cap 12) BackGround - S>m°Š`w_|Q>Mo àoPoÝQ>oeZ AmH$f©H$ hmoÊ`mgmR>r Back ground XoVm `oVo A) Format -> Backgraound -> hdm Vmo H$ba {ZdS>m Am) Format -> Backgraound -> AmUIr a§JN>Q>m {ZdS>Ê`mgmR>r More Colors Option B) Format -> Background -> Fill Effects -> g_moa {XgUmè`m S>m`bm°J ~m°Šg_Ü`o Imbrb Mma Q>°~ {XgVrb. 13) Change Case – Q>mB©n Ho$bobm _°Q>a Z ImoS>Vm Small {bnrMo Capital {bnr_Ü`o qH$dm Capital {bnrMo Small {bnr_Ü`o énm§Va H$aÊ`mgmR>r Change Case hm Am°ßeZ Cn`moJr nS>Vmo. Ë`m_Ü`o Imbrb n`m©` AmhoV. MS-OFFICE Manual Page 18  Tilak Maharashtra Vidyapeeth 2016 a) Sentence case – {gboŠQ> Ho$boë`m _°Q>a_Yrb àË`oH$ dmŠ`mMo n{hbo Aja Capital _Ü`o d BVa Aja Small {bnrV ~Xbbr OmVmV. b) Lower case – {gboŠQ> Ho$boë`m _°Q>a_Yrb gd© Ajao Small {bnrV ~Xbbr OmVmV. c) UPPER CASE – {gboŠQ> Ho$boë`m _°Q>a_Yrb gd© Ajao Capital {bnrV ~Xbbr OmVmV. d) Title Case- àË`oH$ eãXmMo n{hbo Aja Capital d BVa Ajao Small _Ü`o ~Xbbo OmVmV. e) tOGGLE cASE – àË`oH$ eãXmMo n{hbo Aja Small d BVa Ajao Capital _Ü`o ~Xbbo OmVmV. MS-EXCEL MS-OFFICE Manual Page 19  Tilak Maharashtra Vidyapeeth 2016 Microsoft Office Excel 2007 Excel {df`r WmoS>o - ì`dhmamV Am°{\$g_Ü`o ~arM, H$mhr _m{hVr hr Tabular Format (Q>o~bÀ`m ñdénmV) {bhÿZ R>odbr Va Vr g_Om`bm qH$dm Ë`m _m{hVr_Ü`o VwbZm H$am`bm gmono OmVo. CXm. _wbm§Mo doJdoJù`m {df`m§_Yrb _mŠg©, H§$nZrVrb H$m_Jmam§Mo nJma - nÌ (Salary Sheet), Sales Report, Income Statement, Expense Report B. _m{hVr. Aem _m{hVrVrb Spreadsheet qH$dm Worksheet Ago åhUVmV. Excel Mmby H$aÊ`mMr nÜXV Start -> Programs -> Microsoft Office -> Microsoft Office Excel 2007 Excel À`m {XgUmè`m JmoîQ>r - MSOFFICE à_mUo Excel _Ü`ohr Title Bar, Menubar, Standard, Toolbar, Formatting, toolbar B. Qy>b~mg© {XgVmV. Formatting Toolbar À`m Imbr Formula Bar AgVmo. `m ~mada gwê$dmVrbm Name box AgVmo. `m Name Box _Ü`o Current Cell Mm Address {XgVmo. Ë`m Z§Va = Mo ~Q>U {XgVo, Formula Bar À`m Imbr C^o AmS>do aH$mZo Agbobo EH$ [aH$m_o Worksheet {XgVo. Worksheet åhUOo H$m` ? Toolbar Format _Ü` åhUOoM Q>o~b À`m ñdénmV _m{hVr ^aÊ`mgmR>r `m erQ>Mm Cn`moJ H$aVmV. `m erQ>_Ü`o C^o d AmS>do aH$mZo AgVmV. `mVrb Cä`m aH$mÝ`m§Zm Columns d AmS>ì`m aH$mÝ`m§Zm Rows Ago åhUVmV. Work Sheet _Ü`o EHy$U 256 Columns Am{U 65536 Rows AgVmV. `m_Ü`o àË`oH$ Column bm EH$ Column Name qH$dm Column Heading AgVo. CXm. A, B, C, D, E, ……… Ago eodQ>À`m MS-OFFICE Manual Page 20  Tilak Maharashtra Vidyapeeth 2016 Column Mo Zmd IV Ago AgVo. Ë`mMà_mUo àË`oH$ Row bm EH$ Row number Dmla. CXm. 1,2,3….. `m à_mUo eodQ>À`m Row bm 65536 Agm No. AgVmo. `m {eâQ>_Ü`o EH$ Row d EH$ Column {_iyZ EH$ Mm¡H$moZ V`ma Pmbobm AgVmV. `m Mm¡H$moZmbm Cell (gob) Ago åhUVmV. àË`oH$ gmR>r EH$ {Xbobo AgVo. CXm. H$aVmZm àË`oH$ doir n{hë`m§Xm {dMmamV KoVbo OmVo d Z§Va CXm. `mMm AW© _Yrb Formula Bar À`m Imbr C^o AmS>do aH$mZo Agbobo EH$ [aH$m_o Worksheet {XgVo. 4) EImXm g§nyU© Column {gboŠQ> H$aÊ`mgmR>r - Mouse Pointer Ë`m Column À`m Zmdmda VoWyZ Mouse Zo pŠbH$ H$amdo. 5) EImXm g§nyU© Row {gboŠQ> H$aÊ`mgmR>r - Mouse Pointer Ë`m Row number da ZoD$Z Mouse Zo pŠbH$ H$amdo. 6) g§nyU© Worksheet {gboŠQ> H$aÊ`mgmR>r - n{hë`m Row number darb d n{hë`m Column Name À`m S>mdrH$S>o Agboë`m H$moè`m Mm¡H$moZmda Mouse Pointer Zo pŠbH$ H$amdo. EH$m Cell _Yrb _°Q>a Xwgè`m gob _Ü`o Copy H$aÊ`mgmR>r 1) àW_ Á`m gob_Yrb _°Q>a H$m°nr H$am`Mr Vmo {gboŠQ> H$am. 2) Edit -> Copy qH$dm Ctrl + C hm Am°ßeZ {ZdS>m. 3) Á`m gob _Ü`o hm _°Q>a noñQ> H$am`Mm Vmo {gboŠQ> H$am. 2) Edit -> Paste qH$dm Ctrl + V hm Am°ßeZ {ZdS>m. Excel _Ü`o dmnabr OmUmar {d{dY àH$maMr Predifined Functions 1) Sum - `m function _wio AmnU OodT>o Cells specify Ho$bo AgVrb Ë`m gd© gobMr ~oarO Ho$br OmVo. CXm. :- = sum (1st Cell : Last Cell ) MS-OFFICE Manual Page 21  Tilak Maharashtra Vidyapeeth 2016 = sum (D5 : D15 ) åhUOoM D5 Vo D15 `m goëg_Yrb g§»`mMr ~oarO Ho$br OmB©b. 2) Average - `m function _wio AmnU OodT>o Cells specify Ho$bo AgVrb Ë`m gd© gobMr gamgar H$mT>br OmVo. CXm. :- = Average (1st Cell : Last Cell ) = Average (D5 : D15 ) åhUOoM D5 Vo D15 `m goëg_Yrb g§»`mMr gamgar Ho$br OmB©b. 3) Max - `m function _wio AmnU OodT>o Cells specify Ho$bo AgVrb Ë`m gd© gobg² _YyZ gdm©V _moR>r g§»`m Hw$R>br Amho Vr Amnë`mbm {_iVo. CXm. :- = Max (1st Cell : Last Cell ) = Max (D5 : D15 ) åhUOoM D5 Vo D15 `m goëg_Yrb gdm©V _moR>r g§»`m Or Amho Vr {_iob. 4) Min - `m function _wio AmnU OodT>o Cells specify Ho$bo AgVrb Ë`m gd© gobg² _YyZ gdm©V _moR>r bhmZ g§»`m Hw$R>br Amho Vr Amnë`mbm {_iVo. CXm. :- = Min (1st Cell : Last Cell ) = Min (D5 : D15 ) åhUOoM D5 Vo D15 `m goëg_Yrb gdm©V bhmZ g§»`m Or Amho Vr {_iob. Format Menu 1) Cells – {gboŠQ> Ho$boë`m Cells _Yrb _m{hVrMr ñQ>mB©b (Font, font style, Font Colour ) B. ~Xb H$aÊ`mgmR>r hm Am°ßeZ dmnaVmV. Ë`m_Ü`o Imbrb à_mUo Am°ßeÝg dmnaVm `oVmV. MS-OFFICE Manual Page 22  Tilak Maharashtra Vidyapeeth 2016 Number Formats (a) Number – {gboŠQ> Ho$boë`m Cells _Yrb g§»`mMo H$_r OmñV H$aÊ`mgmR>r g_moa hdo VodT>o Q>mB©n H$amdo CXm. XmoZ gmR>r Am{U 2,355,345 Aem ñdénmV hOma Z§Va Comma ( , ) {MÝh Úmd`mMo Agë`mg Use 1000 Separator `m Am°ßeZ g_moarb ~m°Šg _Ü`o √ H$amdr. Date Format A{gboŠQ> Ho$boë`m Cell _Yrb VmarI {d{dY ñdê$nmV XmIdVm `oVo. Text Format – {gboŠQ> Ho$boë`m Cells _Yrb _m{hVr Amho Ë`mM ñdê$nmV {XgVo Oar Vr EImXr g§»`m Agob. CXm. Oa EImÚm gob_Ü`o 0.00 hr g§»`m Q>mH$ë`mg Vr \$ŠV 0 {Xgob. VgoM 0002 Aer g§»`m Q>mH$ë`mg Vr \$ŠV 2 {Xgob. Ë`mgmR>r àW_ Vmo gob {gboŠQ> H$am Am{U Format -> Cells -> Number _YwZ Text hm Format pŠbH$ H$am Allignment –Cells _Yrb _m{hVrMr ì`dpñWV _m§S>Ur H$aÊ`mgmR>r dmnaVmV. `m _Ü`o nwT>rb Am°ßeÝg AgVmV. MS-OFFICE Manual Page 23  Tilak Maharashtra Vidyapeeth 2016 A) Oa EImÚm gobMr _m{hVr Ë`m gob_Ü`o g§nyU©nUo ~gV Zgob, Va AmnU Ë`m H$m°b_Mr gmB©O dmTdyZ Vr _m{hVr Ë`m gob_Ü`o g§nyU©nUo ~gdy eH$Vmo. na§Vw nyU© H$m°b_Mr gmB©O _°Ý`wAbr dmT>dÊ`mEodOr Vr _m{hVr, Ë`m H$m°b_Mr gmB©O Amho VodT>rM R>oD$Z Ë`m_Ü`o EH$mnojm OmñV bmB©Z_Ü`o ~gdVm `oVo. ~) `m Am°ßeZ_Ü`o Oa EImÚm gob_Yrb _°Q>a Ë`mM gob_Ü`o ~gV Zgob Va _°Q>a Mr gmB©O Ë`m gob_Ü`o ~gy eHo$b EdT>r Ho$br OmVo. H$) EH$ qH$dm EH$mnojm OmñV gobg² {_iyZ EH$Ì H$ê$Z EH$M gob ¿`md`mMm Agob Va `m Am°ßeZMm dmna Ho$bm OmVmo. gob_Yrb _°Q>a {VaH$m qH$dm C^m H$am`MmAgë`mg Vmo gob {gboŠQ> H$ê$Z _Yrb `m Am°ßeZMm dmna H$aVmV. Border - `m Q>°~_wio {gboŠQ> Ho$boë`m gobbm {d{dY àH$maÀ`m Border Q>mH$Vm `oVmV. 2)Column Mr Width H$_r OmñV H$aÊ`mgmR>r - àW_ da pŠbH$ H$ê$Z {gboŠQ> H$am. Z§Va hm Am°ßeZ {ZdS>m. Z§Va Q>mHy$Z ~Q>U Xm~m. MS-OFFICE Manual Page 24  Tilak Maharashtra Vidyapeeth 2016 3) Row Mr Height H$_r OmñV H$aÊ`mgmR>r - àW_ da {ŠbH$ H$ê$Z {gboŠQ> H$am Z§Va hm Am°ßeZ {ZdS>m. Z§Va Q>mHy$Z ~Q>U Xm~m. 4) Active Sheet Mo Zmd ~XbÊ`mgmR>r - Format -> Sheet -> Rename Sheet À`m Q>°~da H$g©a Amë`mZ§Va Amnë`mbm hdo Agbobo Zmd Q>mB©n H$éZ Enter Xm~mdo. 5) Auto Format - Excel Zo Amnë`mbm H$mhr Readymade Formats CnbãY H$éZ {Xbobo Amho. Ë`m§À`m _XVrZo Q>o~bbm Automatic Formating (Font, Fontstyle, Bold, Italic, Borders, Background B.) Ho$br OmVo. Ë`m gmR>r Format _oZwVrb Autoformat hm Am°ßeZ pŠbH$ H$amdm. Z§Va g_moa {XgUmè`m {d{dY àH$mam§_YyZ `mo½` àH$ma {ZdS>m d OK pŠbH$ H$am. MS-OFFICE Manual Page 25  Tilak Maharashtra Vidyapeeth 2016 6) Conditional Formating - åhUOo R>am{dH$ gob gmR>r EImXr Condition XoUo. d Vr Condition nwU© Pmbr VaM Excel Ë`m Cell gmR>r R>adbobm Format Assign H$aob. CXm. Cell _Yrb _mŠg© 40 nojm Agë`mg Vo bmb H$ba_Ü`o, d 40 qH$dm 40 nojmOmñV Agë`mg Vo {Zù`m a§JmV ¿`m`Mo Agë`mg Imbrb à_mUo H¥$Vr H$amdr- 1) Á`m `ob_Ü`o _mŠg© AmhoV Vo gd© goëg {gboŠQ> H$am. 2) Format->Conditional formatting hm Am°ßeZ {ZdS>m. 3) Z§Va g_moa {XgUmè`m Dialogue Box _Ü`o Imbrbà_mUo qH$_Vr ^amì`mV 4) OK ~Q>U Xm~m. Insert Menu 1) Cells- `m H$_m§S>ìXmao {gboŠQ> Ho$boë`m Cell À`m OmJr ZdrZ Blank Cell/Blank Row/ Blank Colum Insert H$aVm `oVmo. Cells Insert H$aVmZm Ë`m OmJr Agboë`m _yi Cells _Yrb _°Q>a nwT>o R>H$bm`Mm H$s Imbr T>H$bm`Mm Vo Shift Cells Right/Down `m Option Zo R>a{dVm `oVo. MS-OFFICE Manual Page 26  Tilak Maharashtra Vidyapeeth 2016 2) Row - Oa EImXr ZdrZ Bank Row Insert H$aÊ`mgmR>r àW_ Á`m Row À`m daVr ZdrZ Row hdr Amho, Ë`m Row À`m Z§~ada pŠbH$ H$ê$Z Vr Row {gboŠQ> H$am. Z§Va Insert _oZwVrb Row hm Am°ßeZ pŠbH$ H$am. 3) Columns - Oa EImXr ZdrZ Bank Column Insert H$aÊ`mgmR>r àW_ Á`m Column À`m AJmoXa ZdrZ Column hdm Amho, Á`m Column À`m Zmdmda pŠbH$ H$ê$Z Vmo Column {gboŠQ> H$am. Z§Va Insert _oZwVrb Column hm Am°ßeZ {gboŠQ> H$am. 4) Worksheet - Oa EImXr ZdrZ Bank Worksheet Insert H$aÊ`mgmR>r àW_ Á`m Worksheet À`m AJmooXa ZdrZ Worksheet hdo Amho, Ë`m Worksheet À`m Zmdmda pŠbH$ H$ê$Z Vo Worksheet {gboŠQ> H$am Z§Va Insert _oZwVrb Worksheet hm Am°ßeZ pŠbH$ H$am. 5) Chart - Active Sheet _Yrb _mhrVrda AmYmarV Chart (J«m\$) V`ma H$aÊ`mgmR>r hr H$_m§S> dmnaVmV. CXm. A) Column Chart - Mma _hmZJam§Mo Vmn_mZ Xe©dUmam AmboI XmIdÊ`mgmR>r Imbrb à_mUo H¥$Vr H$amdr. 1) n«W_ Imbrb à_mUo EH$ Q>o~b V`ma H$amdm. City Min Max Mumbai 17 25 New Delhi 12 20 Chennai 21 29 Kolkatta 19 28 2) Table {gboŠQ> H$ê$Z Insert _oZwVyZ Insert _oZyVwZ Chart hm Am°ßeZ {ZdS>m. g_moa Amboë`m Dialogue Box _YyZ Colums hm Chart type {ZdSy>Z Next Button Xm~m. MS-OFFICE Manual Page 27  Tilak Maharashtra Vidyapeeth 2016 3) nwÝhm Next ~Q>U Xm~m. 4) nwÝhm EH$Xm Next ~Q>U Xm~m. MS-OFFICE Manual Page 28  Tilak Maharashtra Vidyapeeth 2016 5) g_moa {XgUmè`m S>m`bm°J ~m°Šg _Ü`o Chart title – Temperature of City, Category (x) axix –City, Am{U Value (Y) axix- Temp Ago Q>mB©n H$ê$Z Next Am{U Ë`mZ§Va Finish ho ~Q>U Xm~mdo. Ë`mMà_mUo AmnU Line Chart, Pie Chart B. àH$maMo Chart V`ma H$ê$ eH$Vmo. 6) Function - worksheet _Ü`o _m{hVrda doJdoJù`m J{UVr à{H«$`m$`m H$aÊ`mgmR>r Excel _Yo Amnë`mbm ~arM doJdoJir Functions {Xbobr AmhoV. CXm. Sum, Average, Max, Min Uppe, lower, Count, if. B. 7) Comment - EImÚm gob_Yrb _m{hVr~Úb A{YH$ _m{hVr XoÊ`mgmR>r Ë`m gobbm Comment XoVm `oVo. CXm. EImÚm Column _Yo _m{hVr ^aÊ`m AmJmoXa Ë`m gobda pŠbH$ Ho$ë`m~amo~a Amnë`mbm Imbrbà_mUo Message {XgVmo.Ë`mgmR>r Cell Mr a|O {gb|Q> H$am. d Insert _oZwVyZ Comment ¿`m. Z§Va Comment Type H$am. Am{U {eQ>da BVaÌ pŠbH$ H$ê$Z ¿`m. MS-OFFICE Manual Page 29  Tilak Maharashtra Vidyapeeth 2016 8) Picture - `m H$_m§S>À`m _XVrZo AmnU db© à_mUo ClipArt, WordArt, Autoshapes B. àH$maMo Graphics Q>mHy$ eH$Vmo. Microsoft Office 2007- Powerpoint Powerpoint `m packages À`m ZmdmVM Ë`mMm AW© Amho. “The package which gives power to the debating point”. Agm `m n°Ho$OMm AW© åhUVm `oB©b. hëbrÀ`m OmhramVrÀ`m d ì`dgm`rH$ `wJmV, àË`oH$ {R>H$mUr àË`oH$ business bm, Managerial Authority bm, Salesman bm, àË`oH$ {R>H$mUr Debating H$amdo bmJVo (~mobmdo bmJVo). H$maU `m Debating _wioM Amnë`m Project Mm, Idea Mm Scheme Mm Mm§Jbm n[aUm_ J«mhH$m§À`m d Ë`m§À`m _Zmda hmoVmo d Ë`m n«moOoŠQ> Mm In Mm§Jbm hmoVmo Am{U n`m©`mZo ì`dgm` dmT>m`bm _XV hmoVo. na§Vw ZwgË`m Debating Zo H$m_ ^mJV Zmhr. Ë`m_wio _J BVa Presentation Material CXm. Slids, Handouts etc. `m§Mr _XV ¿`mdr bmJVo. Amnbm _wX²Xm lmoË`m§À`m _Zmda q~~dÊ`mgmR>r ~amo~aM `mMmhr dmna hëbr ^anya Ho$bm OmVmo. EImÚm Marketing campaign qH$dm Office Meeting _Ü`o Debating H$aVmZm Aem Computerized Slideshow Mr _XV hmoVo. Powerpoint `m package _YyZ Agm Slideshow Amnë`mbm V`ma H$aVm `oVmo. Powerpoint A) Start -> Programs -> Microsoft Office -> Microsoft Office 2007 Powerpoint. B) Z§Va Blank Presentation hm àH$ma {gboŠQ> H$ê$Z OK ~Q>U Xm~m. Slide Mo formating 1) Font : _°Q>aMm Font, Format Menu _Yrb Font, Command dmnê$Z qH$dm Formatting toolbar _Yrb Option ìXmao ~XbVm `oVo. MS-OFFICE Manual Page 30  Tilak Maharashtra Vidyapeeth 2016 2) Bullets and Numbering – word : à_mUoM {gboŠQ> Ho$boë`m {bñQ> bm bullets numbering XoÊ`mgmR>r `m Am°ßeZMm Cn`moJ hmoVmo. 3) Line Spacing : XmoZ Amoit_Yrb A§Va R>a{dÊ`mgmR>r `m Am°ßeZMm Cn`moJ hmoVmo. 4) Replace Font : Format _oZwVrb Replace Font hr Command dmnê$Z _Yrb EImÚm {d{eîQ> Font _Ü`o Agbobo g§nyU© Text Xwgè`m EImÚm {d{eîQ> Font _Ü`o ~XbVm `oVo. Slide Layout : Insert Pmboë`m Slide Mm Layout (àH$ma), Oa Change H$am`Mm Agob Va `m H$_m§S>bm {ŠbH$ H$amdo. 6) Slide Design : `m Command bm pŠbH$ Ho$ë`mZ§Va gd© ñbmB©S>²g bm doJdoJù`m H$baMo design apply H$aVm `oVo. MS-OFFICE Manual Page 31  Tilak Maharashtra Vidyapeeth 2016 7) Background : Format Menu _Yrb `m Am°ßeZÀ`m ghmæ`mZo Mmbw ñbmB©S>À`m g§nyU© ~°H$J«mD§$S>bm EImXm a§J XoVm `oVmo. Insert Menu 1) New Slide ( Ctrl + M ) : ZdrZ ñbmB©S> Insert H$aÊ`mgmR>r `m H$_m§S>bm pŠbH$ H$amdo. 2) Duplicate Slide (Ctrl + D) : H$mhrdoim XmoZ ñbmB©S>_Yrb _°Q>a d BVa JmoîQ>r ~è`mMem gma»`m AgVmV. \$ŠV EImX Xwgè`m Amoir_Ü`o ~Xb AgVmo. Aem doir AmnU n{hë`m ñbmB©S> Duplicate Copy V`ma H$ê$ eH$Vmo. àW_ hdr Vr ñbmB©S> {gboŠQ> H$am Am{U Edit _oZwVrb Duplicate hr H$_m§S> {gboŠQ> H$amdr, åhUOo Mmby ñbmB©S>Mr EH$ H$m°nr Ë`mImbr V`ma hmoB©b. 3) Symbol - Keyboard : Zgbobo {MÝh Insert H$aÊ`mgmR>r `m Am°ßeZMm Cn`moJ hmoVmo. 4) Picture - Slide _Ü`o Clipart, WordArt, Autoshapes : Q>mH$Vm `oVmV. 5) Movies and Sounds – ñbmB©S>_Ü`o H$mhr - Pre –recorded sounds, video clips ‹Q>mH$Ê`mgmR>r `m Am°ßeZMm Cn`moJ H$aVmV View Option 1) Normal View : gd©gmYmaUnUo, EImXr ñbmB©S> V`ma Ho$ë`mda Ë`m_Ü`o _°Q>a Q>mB©n H$aÊ`mgmR>r `m view Mm Cn`moJ hmoVmo. `m view _Ü`o EH$m doir EH$M ñbmB©S> {Xgy eH$Vo. nyU© Pmbobr ñbmB©S> H$er {Xgob ho slide show _Ü`o nm{hbo OmVo. MS-OFFICE Manual Page 32  Tilak Maharashtra Vidyapeeth 2016 2) Slide sorter view : `m view _Ü`o ZIm EdT²>`m N>moQ>`m AmH$mamV Thumbnail Slides {XgVmV. `m view _Ü`o slides Mm H«$_ ~XbVm `oVmo. Mmby \$mB©b_Ü`o OodT²>`m ñbmB©S>g² V`ma Pmë`m AgVrb. VodT²>`mM ñbmB©S>g² `m view _Ü`o {XgVmV. 3) Slide show view : AmnU V`ma Ho$boë`m ñbmB©S>g² EH$mnmR>monmR> EH$ ñH«$sZda nmhÊ`mgmR>r Slide show view `m Am°ßeZMm Cn`moJ hmoVmo. 4) Notespages view - Slideshow ~amo~a Footnote ^mfU AWdm Q>mMU Q>mB©n H$aÊ`mgmR>r `m view Mm Cn`moJ hmoVmo. 5) Master slide – Background, logo, font – B. JmoîQ>r VgoM date, page number d BVa H$mhr JmoîQ>r, `m presentation file _Yrb gd© slides gmR>r common hì`m Agë`mg Master slide Mm Cn`moJ hmoVmo. Master slide da Ho$bobo ~Xb gd© ñbmB©S>da n[aUm_ H$aVmV. 6) Header and Footer – àË`oH$ ñbmB©S>da H$mhr JmoîQ>r CXm. date, footer, fixed text hì`m AgVmV Ë`m§Zm Q>mH$Ê`mgmR>r hm Am°ßeZ dmnaVmV. Slide Show - (F5) AmnU V`ma Ho$boë`m ñbmB©S²>g EH$mnmR>monmR> EH$ ñH«$sZda nmhÊ`mgmR>r Slide Show - Mm Cn`moJ hmoVmo. MS-OFFICE Manual Page 33  Tilak Maharashtra Vidyapeeth 2016 Slide Show - ho gd© animation effect {Xë`mZ§Va Amnë`m Slide Show ~XX²b H$mhr Options Amnë`mbm Setup H$ê$Z R>odmdo bmJVmV. `mgmR>r Slide Show `m _oZy_YyZ `m H$_m§S>bm pŠbH$ H$amdo Reherse Timing - Amnë`mbm Slide gmR>r timing fix H$aÊ`mgmR>r powerpoint Zo hr AmUIr EH$ facility {Xbobr Amho. Hide Slide - Slide show Mo doir EImXr Slide Amnë`mbm Show H$am`Mr Zgob Va Vr Slide select H$ê$Z Slide show `m _oZwVyZ hide slide bm {ŠbH$ H$am. Custom Animation 1. gd©àW_ Á`m Text bm qH$dm Object bm Animation Effect Úmd`mMm Amho Vmo {gboŠQ> H$am. 2. Slide Show `m _oZw_YyZ Command bm pŠbH$ Ho$ë`mZ§Va Window À`m COì`m hmVmbm Add Effect ho ~Q>U {Xgob. `m ~Q>Umda pŠbH$ H$am. 3. Ë`mVyZ Entrance, Emphasis, Exit qH$dm Motion Path n¢H$s `mo½` àH$ma {ZdS>m. 4. Entrance, Emphasis, Exit qH$dm Motion Path `m§Mo g~Q>mB©ßg n¢H$s hdm Vmo àH$ma {ZdS>m. MS-OFFICE Manual Page 34  Tilak Maharashtra Vidyapeeth 2016 MS-OFFICE Manual Page 35