open office - wordpress.com · yt insert menu ™t manual break command ™e {ŒŒÚte current...
TRANSCRIPT
Open Office
Open OfficeModule - 7
Linux system rðrðÄ application ™u support fhu Au. Linux Operating System {tk Open office software W…÷çÄ Au, su Ëk…qýo…ýu ÔÞðËtrÞf ‚u{s þiûtrýf y™u Œhuf ûtuºt{tk W…Þtu„e yuðwk applicaion software Au. Open office {tk word processor, spreadsheet application y™u presentation software ™tu Ë{tðuþ ÚttÞ Au.
Open Office (package) (Open Office org package) {tk Microsoft Office ™e ƒÄe s file open ÚtE þfu Au. yt{ ‚u MS-Office ËtÚtu ËtBÞ‚t Ähtðu Au.
Linux system office application ™u support fhu Au. Linux OS {tk Open office ™u open fhðt {txu Applications menu ™u click fh‚tk “office” option òuðt {¤u Au. yt “Office” option …h click fh‚tk ‚u™t submenu {tk Open Office program - Word Processor, Spreadsheet, Presentation òuðt {¤u Au. su «tu„út{ …h Âõ÷f fheþwk ‚u «tu„út{ ytu…™ Útþu.
Introduction...
OpenOffice.org Word Processorytu…™ yturVË{tk ytðu÷ ðzo «tuËuËh «tu„út{ yu yu{yuË yturVË (Ms-office) {tk ytðu÷ ðzo (word) «tu„út{ suðtu s Au.
Word Processor
Word Processor ™wk ftÞoûtuºt {tR¢tuËtu^x ðzo ËtÚtu ½ýwk ËtBÞ‚t Ähtðu Au.
VtR÷ {u™q{tk ŒM‚tðus™u open fhðt, save fhðt ‚Útt PDF (…ezeyuV) MðY…u r™ftË fhðt {txu™t Export as
PDF suðt f{tLztu yt…ðt{tk ytÔÞt Au. su Ë{„ú ŒM‚tðus™u ÷t„w …tze þftÞ Au. VtE÷ {u™q™wk ftÞoûtuºt {nŒTykþu ytu…™ytìrVË™tk ÷„¼„ ƒÄt s «tu„út{{tk Ë{t™ òuðt {¤u Au.
yurzx {u™q{tk fhu÷t ftÞtuo™u hŒ fhðt {txu undo (y™zw) f{tLz, {trn‚e þtuÄðt fu ƒŒ÷ðt {txu Find & Replace (VtRLz yuLz rhÃ÷uË) f{tLz y™u ŒM‚tðus™e ËwÄthýt {txu™t f{tLz yt…ðt{tk ytÔÞt Au.
ÔÞq {u™q{tk ŒM‚tðus™t Œu¾tð™u r™Þkrºt‚ fhe þftÞ ‚u {txu™t f{tLz yt…ðt{tk ytÔÞt Au.
ELËxo {u™q{tk ŒM‚tðus™t nuzh, Vqxh, ‚the¾ y™u Ë{Þ, r[ºttu suðt ½xftu W{uhðt™t f{tLz yt…ðt{tk ytÔÞt Au.
Vtu{uox {u™q{tk ŒM‚tðus™e Ëkh[™t {txu™t f{tLz suðt fu MxtR÷ y™u Vtu{uo®x„, Vfht™e „tuXðýe ‚Útt ¢r{f fu y¢r{f ÞtŒe ð„uhu rðfÕ…tu yt…ðt{tk ytÔÞt Au.
{tk rðrðÄ {u™qƒth™tu W…Þtu„ :
Computer World Publication1
xuƒ÷ {u™q{tk ŒM‚tðus{tk ftuüf yux÷u fu xuƒ÷ W{uhðt ‚Útt ‚u{tk ËwÄtht fhðt {txu™t ‚{t{ f{tLz yt…ðt{tk ytÔÞt Au.
xwÕË {u™q{tk þ猙e òuzýe ‚…tËðe, fMx{tEÍ (customize) y™u yLÞ rðfÕ…tu yux÷u fu options suðe ËwrðÄtytu yt…ðt{tk ytðe Au.
rðLztu {u™q{tk yuf fh‚tk ðÄw ŒM‚tðuòu™u yuf ËtÚtu M¢e™ …h „tuXððt {txu™t f{tLz yt…ðt{tk ytÔÞt Au.
ßÞthu nuÕ… {u™q{tk Word Processor «tu„út{™tu Ëk…qýo …rh[Þ ‚u{s Word Processor™tk Œhuf rðfÕ…™e {trn‚e y™u ‚u™tu W…Þtu„ fuðe he‚u fhðtu ‚u™e [tu¬Ë {trn‚e yt…ðt{tk ytðe Au.
ftuE…ý ytŒuþ™tu W…Þtu„ Íz…Úte xw÷ îtht fhðt {txu MxtLzzo xw÷ƒth W…Þtu„{tk ÷uðt{tk ytðu Au. su{ fu,
ŒM‚tðus™tu Ëk„ún fhðt {txu Ëuð (save) ƒx™ …h Âõ÷f fhðe.
MxtLzzo xw÷ƒth™e ™e[u òuðt {¤‚t Vtu{uoxª„ xw÷ƒth îtht ½xftu™e Ëkh[™t xw÷ îtht fhðt{tk ytðu Au. su{ fu, ftuE yuf þçŒ …h æÞt™ Œtuhðt {txu ‚u þ猙u ½uhtu yux÷u fu bold (ƒtuÕz) fhðt {txu Vtu{uoxek„ xw÷ƒth{tk B ƒx™ …h Âõ÷f fhðe.
File Menu …h Âõ÷f fhe, New f{tLz …h Âõ÷f fh‚tk rðrðÄ rðfÕ…tu òuðt {¤u Au, ‚u{tkÚte Text Document rðfÕ… …h Âõ÷f fhðe.
™ðe VtE÷ ƒ™tððe :
™ðt ŒM‚tðus{tk sYhe {trn‚e xtE… fÞto ƒtŒ ‚u™tu ftÞ{e Ëk„ún fhðt {txu ŒM‚tðus™u Ëuð (save) fhðtu sYhe Au.
VtE÷ yux÷u fu ŒM‚tðus™tu fBÃÞqxh{tk ftÞ{e Ëk„ún fhðt {txu VtE÷ {u™q™tk Ëuð (save) rðfÕ… …h Âõ÷f fhðe.
suÚte Save As ™wk ztÞ÷tu„ ƒtuût òuðt {¤u Au. ynª, ŒM‚tðus™wk ÞtuøÞ ™t{ xtR… fhe save ƒx™ …h Âõ÷f fhðe. suÚte yt…u÷ ™t{ {wsƒ ŒM‚tðus™tu Ëk„ún ÚtE òÞ Au.
Ëk„ún ÚtÞu÷ ŒM‚tðus™u .odt (ztux ytu ze xe) yuõËxuLþ™ ÷t„u Au.
ŒM‚tðus™tu Ëk„ún fhðtu
ytu…™ ytìrVË™e rðþu»t‚t yu Au fu ‚u{tk {tE¢tuËtu^x ðzo™e VtE÷™u ÷¾e fu ðtk[e þftÞ Au.
ytu…™ ytìrVË{tk, htExh îtht ‚iÞth fhu÷ ŒM‚tðus™u {tE¢tuËtu^x ðzo™t MðY…™e VtE÷{tk Ëk„ún fhðt {txu VtE÷ {u™q{tk Ëuð yÚtðt Ëuð yuÍ (Save yÚtðt Save as) ™t rðfÕ… …h Âõ÷f fhðe. Save ™t rðLztu{tk VtE÷
{tE¢tuËtu^x ðzo™tk MðY…u ŒM‚tðus™tu Ëk„ún fhðtu
OpenOffice
Computer World Publication2
xtE… (file type) ™tk rðfÕ…{tk yuhtu (‚eh) …h Âõ÷f fh‚tk zÙtu…ztW™ {u™q òuðt {¤u Au. yt {u™q{tkÚte ðzo VtE÷™wk MðY… (type) ™¬e fhe, Save ƒx™ …h Âõ÷f fh‚tk VtE÷ {tE¢tuËtu^x ðzo MðY…u Ëk„ún ÚtE sþu.
y„tW ƒ™tððt{tk ytðu÷e VtE÷™u ytu…™ fhðt {txu MxtLzzo xw÷ƒth …h òuðt {¤‚t ytu…™ (open) ƒx™ …h Âõ÷f fh‚tk VtE÷ ytu…™ fhe þftÞ Au.
ynª òuðt {¤‚t ztÞ÷tu„ ƒtuût{tk VtE÷™tu Ëk„ún fhu÷ ntuÞ ‚u VtuÕzh ytu…™ fh‚t òuðt {¤‚e EÂåA‚ VtE÷ …h Âõ÷f fhðe. íÞthƒtŒ open ™t ƒx™ …h Âõ÷f fh‚tk VtE÷ òuðt {¤u Au.
ð‚o{t™ VtE÷ ytu…™ fhðe
ytu…™ ytìrVË ŒM‚tðus™u PDF yux÷u fu Portable Document Format MðY…u r™ftË fhe þftÞ Au. PDF
MðY…u Ëk„ún fhðt{tk ytð‚e VtE÷ {q¤¼q‚ VtE÷™e ‚w÷™t{tk ytuAe søÞt htufu Au {txu ‚u ðÄw «[r÷‚ ƒ™e Au. PDF MðY…™e VtE÷™u yu¢tuƒux hezh yÚtðt PDF MðY…™e VtE÷ open fhe þf‚tk yLÞ «tu„út{ îtht ðtk[e þftÞ Au.
ŒM‚tðus™u PDF MðY…u r™ftË fhðt {txu VtE÷ {u™q{tk™t yuõË…tuxo yuÍ …ezeyuV (export as PDF) ™t rðfÕ… …h Âõ÷f fhðe. suÚte, òuðt {¤‚t ztÞ÷tu„ ƒtuût{tk VtE÷™wk r™rù‚ ™t{ y™u MÚtt™ ™¬e fhe, Export ƒx™ …h Âõ÷f fhðe.
PDF MðY…u r™ftË fhðwk
Cut, Copy, Paste
Cut command ™tu W…Þtu„ Text ™u ƒeS søÞtyu ÷E sðe ntuÞ yux÷u fu Move fhðe ntuÞ íÞthu ÚttÞ Au.
yt Command ™e {ŒŒÚte Select fhu÷ Text fu Graphics ™u Cut fhe þftÞ Au. yt Cut fhu÷ ¼t„ Clipboard {tk Store ÚtE òÞ Au. Document {tkÚte Cut fhu÷ ¼t„™u ƒesu MÚtt™u Paste fhe þftÞ Au.
Cut Ctrl + X
Ëti «Út{ document {tk sYhe ¼t„ mouse îtht yÚtðt keyboard (Shift + Arrowkey) ðzu select fhtu.
íÞthƒtŒ click document {tk select fhu÷ ¼t„ Œqh ÚtE òÞ Au. su™u document {tk ftuE ƒeò MÚtt™u Paste f{tLzÚte Move fhe þftÞ Au.
"Edit Menu" {tk "Cut" command …h fhe yÚtðt "Ctrl + X" yt…ðtÚte
1
2
OpenOffice
Computer World Publication3
yt Command ™e {ŒŒÚte Select fhu÷ ftuE [tu¬Ë Text ™u Copy fhe þftÞ Au. yt {txu Menu" {tk "Copy" command …h click fhðtÚte yÚtðt "Ctrl + C" yt…ðtÚte select fhu÷ ¼t„™e copy fhe þftÞ Au.
"Edit
Copy Ctrl + C
yt Command ™e {ŒŒÚte y„tW Copy fu Cut Command Úte Select fhu÷ Text ™u Document {tk paste fhe þftÞ Au.
Document {tk su søÞtyu Paste fhðwk ntuÞ ‚u MÚtt™u cursor ÷E sE "Edit Menu" {tk "Paste" command …h click fhðtÚte yÚtðt "Ctrl + V" command yt…ðtÚte cursor position …h select fhu÷ ¼t„ paste ÚtE òÞ Au.
Paste Ctrl + V
yt ™e {ŒŒÚte text ™e formatted fu unformatted copy ™u paste fhe þftÞ Au. Ët{tLÞ he‚u yt…ýu Copy fhu÷ text ™u paste fheþwk íÞthu unformatted copy Útþu. ßÞthu Paste special ™e {ŒŒÚte formatted y™u unformatted yu{ ƒk™u he‚u copy fhe þftÞ Au.
ynª Ëti «Út{ ftuE text ™u select fhe copy yt…ðwk [Œt.‚., Bold, Italic] íÞthƒtŒ ‚u™e Copy fhe Paste Special {tk sE òu "Formatting" …h click yt…eþwk ‚tu text ™u su formatting fÞwO nþu [Œt.‚., Bold, Italic] ‚u ËtÚtu paste Útþu.
command
Paste Special Ctrl + Shift + V
yt Command ™e {ŒŒÚte Document {tk fhðt{tk ytðu÷t ËwÄtht ðÄtht suðt fu Text Insert fhðe, Text Copy fhðe, Text Move fhðe, Text ™u Delete fhðe ð„uhu ftuE…ý «fth™t Changes fÞto ntuÞ ‚tu ‚u Record Option ™e {ŒŒÚte Record fhe þftÞ Au.
Edit Menu {tk Changes command …h click fhtu. Record Option …h Click fh‚tk ‚u™e yt„¤ Selection ™e (3) r™þt™e ytðþu.
Current Document {tk (Editing fhðwk) VuhVth fhðt Œt.‚. Text Insert fhðe, Copy fhðe, Delete fhðwk, Format Change fhðe,.... ð„uhu
Project Record... Option îtht Protection Password yt…ðtu su ytuAt{tk ytuAtu 5 (Five)
Character ™tu ntuðtu sYhe Au. Show (Command) …h Click fhðtÚte Show Option yt„¤ 3 ™e r™þt™e òuðt {¤þu. yt{, fhu÷t VuhVth Highlight Útþu. Reject All Option …h Click fhðtÚte Document Normal òuðt {¤þu y™u Highlight Cancel ÚtE sþu.
Changes Ctrl + A
OpenOffice
Computer World Publication4
Find and ReplaceËti «Út{ ‘Edit Menu’ {tk ‘Find & Replace’ Command …h click fh‚tk yÚtðt Ctrl + F Shortcut Key
™tu W…Þtu„ fh‚tk Find & Replace ™wk Dialog box òuðt {¤þu.
ynª yt…u÷t Search for box {tk Current Document {tkÚte su Word þtuÄðtu ntuÞ ‚u Type fhðtu. Word
(þçŒ)™u Võ‚ þtuÄðtu s ntuÞ ‚tu Find button …h Âõ÷f fhðwk. su ‚u þçŒ þtuÄe™u ‚u™e søÞtyu ™ðtu þçŒ (yÚtðt Ë{t™tÚteo þçŒ) {qfðtu ntuÞ ‚tu Replace With ™t box {tk ‚u þçŒ xtE… fhe Replace ƒx™ …h Âõ÷f fhðwk.
Autotext ™t{ «{týu Text ™u Automatically Complete fhu Au. Autotext Command îtht Autotext
Create fhe þftÞ Au. (™ðe Text Autotext ‚hefu W{uhe þftÞ Au) Autotext {tk yt…u÷ Text ™u Edit fhe þftÞ Au. ‚u{s Autotext List {tkÚte Text Insert fhe þftÞ Au.
yt Autotext {tk Formatted Text, Text ËtÚtu Graphics, Table y™u Field ð„uhu Store fhe þftÞ Au.
Current Document {tk su Text Type fhe hÌtt ntuEyu y™u òu yu Text Autotext List {tk ntuÞ ‚tu ‚u™wk Short form (function key F3) yt…ðtÚte Text …qýo ÚtE sþu (…qhwk Type fhðt™e sYh …z‚e ™Úte).
Ëti «Út{ Edit Menu {tk Autotext Command …h Click fhðwk. suÚte Autotext Dialog Box Open Útþu Ctrl + F3 yt…ðtÚte …ý Autotext Dialog Box Open Útþu.
yt…u÷t Autotext Option ™u Set fhðt. yt…u÷e Text {tkÚte ftuE Word yÚtðt Text, Current Document
{tk Insert fhðe ntuÞ ‚tu Text Select fhe Insert Option …h Click fhðwk.
Autotext
Hyperlink ™tu W…Þtu„ yuf Document ™wk ƒeò Document fu file ËtÚtu™wk òuztý fhðt {txu ÚttÞ Au. Edit
Menu {tk Hyperlink Option …h click fh‚tk yt…u÷ Hyperlink ™t path {tk y™u Hyperlink {tk VuhVth fhe þftÞ Au.
Hyperlink
Document ViewsView menu ™e {ŒŒÚte Document ™u y÷„ y÷„ View {tk òuE þftÞ Au. yt W…htk‚ Toolbar ™u On/Off fhe þftÞ Au.
OpenOffice
Computer World Publication5
yt Insert menu ™t Manual Break command ™e {ŒŒÚte Current Document {tk Line Break, Column Break y™u Page Break fhe þftÞ Au.
Break
yt Command ™e {ŒŒÚte Document {tk Picture Insert fhe þftÞ Au. yt Picture, File {tkÚte yÚtðt Scan fhe™u Insert fhe þftÞ Au.
Picture
Default Font Formatting Set fhðt {txu yt Command ™tu W…Þtu„ ÚttÞ Au. Ëti «Út{ Current
Document {tk Character/Font ™e Type, Style, Color... etc suðe Format yt…ðe. íÞthƒtŒ Current Document {tk Text Type fhðe. nðu òu Default Setting ðt¤e Font Format ™e sYh ntuÞ ‚tu Format Menu {tk Default Formatting W…h Click fhðwk.
Default Fomatting
Character command ™e {ŒŒÚte Font Type, Colour, Style.... etc. Change ÚtE þfu Au. Font ™e Format ƒŒ÷e þftÞ Au, Font ™u Hyperlink yt…ðe, Font {tk Background yt…ðwk, Font ™u Different
Effect yt…ðe... ð„uhu suðt Option, Character Option {tk Set ÚtE þfu Au.
Character...
Object ™u Select fhe Alignment Set fhe þftÞ Au. Alignment Top, Center y™u Bottom yt…e þftÞ Au. su™t îtht Object Top yÚtðt Center yÚtðt Bottom Set ÚttÞ Au.
Alignment
Document {tk Object ™u Wrap Command ™e {ŒŒÚte Text ËtÚtu yt„¤, …tA¤, W…h, ðå[u Set fhe þftÞ Au.
Wrap
Table menu {tk Insert Command ™e {ŒŒÚte Table ™e Row/Column ™¬e fhe ™ðwk Table Insert fhe þftÞ Au.
Table
OpenOffice
Computer World Publication6
Tools {u™w™tk Spell Check Command ™e {ŒŒÚte Document {tk Spelling Check fhe ‚u™e søÞtyu ™ðtu Word Replace fhe þftÞ Au. Ëti «Út{ Cursor ™u Document ™e First Line ™t First Character yt„¤ Set fhðtu íÞthƒtŒ Tools Menu {tk Spell Check Command …h Click fhðwk yÚtðt F7 key Press fhðe. Document {tk Spelling Check þY Útþu íÞthu Spellcheck Dialog Box Open Útþu su{tk su Word Check
ÚtE hÌttu Au. (Cursor su Word …h nþu) ‚u Word ™t Similar Word Suggestion Box {tk òuðt {¤þu. su Word Replace ™ fhðtu ntuÞ ‚u “Ignore Once” …h Click fh‚tk Ignore Útþu y™u Cursor Document {tk ƒeò Word …h Jump fhþu. su Word Change fhðtu ntuÞ ‚u Word ™u y™wY… Ët[tu Word Suggestions
Box {tkÚte Select fhe Change …h Click fh‚tk Document ™e ƒÄe s Text ™t Words ™t Spelling
Check Útþu.
Spell Check
Selected Paragraph/Page yÚtðt Text {tk fux÷t Word Au Character fux÷t Au. suðe {trn‚e Word Count Option ™e {ŒŒÚte {¤e þfu Au.
Word Count
Mail Merge ‚u™t ™t{ «{týu s W…Þtu„e Au. Document File y™u Data File ™u ¼u„e fh‚e Facility yux÷u Mail Merge. ftuE yuf Letter yuf fh‚tk ðÄthu ÔÞÂõ‚™u {tuf÷ðtu ntuÞ ‚tu Letter ™e Format ðt¤wk yuf Document ƒ™tððt™wk hnuþu y™u ƒeswk Data {txu yuf Data File fu su{tk Tabular Form {tk su ÔÞÂõ‚ytu™u Letter {tuf÷ðtu Au ‚u ÔÞÂõ‚ytu™t Address y™u {trn‚e Store ntuÞ ‚u File ƒ™tððt™e hnuþu. yt yuf Letter y™u Data File su{tk Address Au ‚u ƒk™u™u Merge Facility ™e {ŒŒÚte Merge fhe þftÞ Au. yt{, yuf Letter ™e yuf fh‚tk ðÄw Copy y÷„ y÷„ Address ËtÚtu {¤þu, su™wk Printout ÷E þftÞ Au.
Letter ƒ™tðu÷ ntuÞ …hk‚w Open ™ ntuÞ ‚tu ‘Start from Existing Document’ Option Select fhðtu.
Template ™tu Document ‚hefu W…Þtu„ fhðt™tu ntuÞ ‚tu ‘Start from Template’ Option Select fhðtu.
y™u òu Letter ƒ™tÔÞtu ™ ntuÞ y™u ™ðwk Document ƒ™tðt™wk ntuÞ ‚tu ‘Create a New Document’ Option
…h Click fhðwk. Next Button …h Click fh‚tk Step 2 ™wk Dialog Box Open Útþu.
Mail Merge Wizard
ynek yt…u÷t …nu÷t Step y™wËth Document ™t Options {tkÚte su Option sYhe Au ‚u Select fhðkkw. Letter ƒ™tðe ÷eÄtu ntuÞ y™u Open ntuÞ ‚tu Current Document Option Select fhðwk. íÞthƒtŒ Next Button …h click fhðe.
1
OpenOffice
Computer World Publication7
nðu ƒeò step {tk Document Type Select fhtu. Letter yÚtðt E-mail Message. ynª, Letter Select fhu÷ Au. íÞthƒtŒ Next Button …h click fhðe.
2
Document {tk Data File ™t Field Insert fhðt {txu ‘Insert Address Block’ Step 3 ™tu W…Þtu„ fhðtu.
3
thyt…u÷t Dialog Box ™t 4 Step {tk Salutation Field Adjust fhe þftÞ Au. sYh «{týu Option Select fhe Next …h Click fhðe.
4
yt 5th Step {tk Adjust Page Layout (Preview) òuðt {¤þu. Address Block Position set fhe þftÞ Au. Next …h Click fhðe.
5
Document {tk VuhVth fhðt {txu Edit Document …h Click fhðwk. ynª Preview ËtÚtu s òuðt {¤þu.Next …h Click fhðe.
6
sux÷t Data, Database File {tk (Table) {tk Enter fÞto nþu ‚ux÷t No. of Record «{týu thDocument Data ËtÚtu Merge ÚtE sþu. nðu 7 Step {tk Œhuf Individual Document ™u
Edit fhðwk ntuÞ ‚tu Facility W…÷çÄ Au. yt {txu “Edit Individual Document” Button …h Click fhðwk.
7
Merged ÚtÞu÷t Document ™u Save fhe þftÞ Au.8
Merged ÚtÞu÷t Document ™e Print ÷E þftÞ Au.
Merged ÚtÞu÷t Document ™u as E-mail {tuf÷e þftÞ Au.
ftuE yuf Option Select fhe Finish Button …h Click fhðwk.
Save, Merged Document ™u Option Select fh‚tk “Save Document Button”
òuðt {¤þu ‚u™t …h Click fh‚tk File ™u Location yt…e Save fhe þftÞ Au.
yt{, Mail Merge ™e {ŒŒÚte Document y™u Data File ™wk Merging ÚttÞ Au y™u yuf ™ðwk Merged Document ‚iÞth ÚttÞ Au.
yt Command ™tu W…Þtu„ Repeat Út‚e (Text Picture, Object, Field... etc) Item ™tu Shortcut
ƒ™tððt {txu ÚttÞ Au. su™e {ŒŒÚte Time Save ÚttÞ Au. ‚u{s ðthkðth fhðwk …z‚wk yuf™wk yuf Work (Tedious
Job) ¾qƒ s Ëh¤‚tÚte Shortcut {tk …qhwk ÚtE òÞ Au.
Ëti «Út{ Tools Menu {tk “Macros” command ™t Submenu {tkÚte “Record Macro” Select fhðwk.
Macro
OpenOffice
Computer World Publication8
Recording On ÚtE s‚tk Document {tk su Process fhðt{tk ytðþu ‚u Step wise Record Útþu. íÞthƒtŒ “Stop Recording” Button …h Click fh‚tk Recording Stop ÚtE sþu.
Recording Stop Út‚tk s “Open Office .org Basic Macros” Dialog Box Open Útþu.
Macro Name ™t Text Box {tk Macro ™wk ™t{ Type fhtu. Create fhu÷ Macro Store fhðt {txu “Save Macro in” ™t List {tkÚte sYh «{týu Option Select fhtu. My Macro, Open Office .Org Macro, Untitled 1, {tkÚte ftuE yuf Option Select fhtu. (Œt.‚. Untitled 1 …h Click fh‚tk Standard Category òuðt {¤þu.)
Save Button …h Click fh‚tk Macro Save ÚtE sþu.
Run Macro
Tools Menu {tk Macros Option ™e {ŒŒÚte ƒ™tðu÷ Macro ™u Run fhðt {txu yt Option ™tu W…Þtu„ ÚttÞ Au.
Run Macro …h Click fh‚tk Macro Selector òuðt {¤þu. yt…u÷ List {tkÚte ƒ™tðu÷ Macro þtuÄe™u Select fh‚tk Run …h Click fh‚tk, Record Macro {tk su Process fhe n‚e ‚u Process Run ÚtE sþu.
OpenOffice.org SpreadsheetOpen office Spreadsheet yu Microsoft Excel ™e Ë{fût™wk y™u ðÄw rðþu»t‚t Ähtð‚wk powerful software Au. Spreadsheet {tk Tabular fromat òuðt {¤u Au. ‚u{tk Rows y™u Columns {tk sYrhÞt‚ {wsƒ data insert fhe formatting ™e {ŒŒÚte ytf»tof spreadsheet ƒ™tðe þftÞ Au.
Open Office Calc {tk hnu÷ Facilities
sYrhÞt‚ {wsƒ ™ðe spreadsheet ƒ™tðe þftÞ Au. y™u ‚u™tu Ëk„ún fhe þftÞ Au. Ëk„ún fhu÷ spreadsheet ™u ßÞthu sYh ntuÞ íÞthu VheÚte open fhe ‚u{tk Editing (VuhVth) fhe þftÞ Au.
ƒ™tðu÷ spreadsheet ™e print Ënu÷tEÚte ÷E þftÞ Au. Print ÷u‚tk …nu÷t spreadsheet ™e print(hard-copy) fuðe he‚u {¤þu ‚u print preview ™e {ŒŒÚte òuE þftÞ Au.
Function wizard {tk ¾qƒ Ënu÷tEÚte Œþtoðu÷ {t„oŒþo™™e {ŒŒÚte Calculation ÚtE þfu Au.
Function category {tk database, date & time, financial, mathematical, logical,
statistical suðt y÷„ y÷„ functions òuðt {¤þu.
Conditional formatting, goal seek, scenarios suðe rðrðÄ y™u W…Þtu„e facilities òuðt {¤u Au.
OpenOffice
Computer World Publication9
Data Tool {tk sorting, filtering suðe facilities òuðt {¤u Au.
System automatically user’s ™t data ™u y™w÷ûte™u graphic series define fhu Au. yt facility Ms-Excel {tk òuðt {¤‚e ™Úte.
Spreadsheet ™u directly PDF file ‚hefu store fhðt {txu …ý Ëût{Au.
Spreadsheet þY fhðt™e he‚Applications ® Office ® Open Office.Org. Spreadsheet
Spreadsheet Screen ™e Ë{sq‚e
Menu bar
StandardToolbar
Title bar
Status bar
Row heading
Cell
Horizontal ScrollbarSheet Status
Formula bar
Vertical Scrollbar
Column Heading
Formatting bar
Formatting toolbar ™e ™e[u Formulabar òuðt {¤u Au. su ºtý ¼t„{tk ðnU[tÞu÷tu Au. Formulabar ™tu left side ™tu ¼t„ Reference Area ‚hefu ytu¤¾tÞ Au, su ‘Active Cell’ {txu™wk Address Œþtoðu Au. ßÞthu Middle ¼t„ Function Wizard ™wk Button Au. Function Wizard
™t button …h Âõ÷f fh‚tk Function wizard open Útþu. Right side ™tu ¼t„ Active cell {tk hnu÷t data Œþtoðu Au.
Formulabar
OpenOffice
Computer World Publication10
Application ™tk ËtiÚte ™e[u™t ¼t„{tk statusbar òuðt {¤u Au. su{tk No. of Sheet ‚Útt ‚u{tk™e Active sheet, Mode Indication Message (Œt.‚. insert), View percentage «{týu (100%, 50%, ...), Keyboard status Indicator (Œt.‚ Caps, Nums) ð„uhu òuðt {¤u Au.
Statusbar ™t{ «{týu File {t™wk current status Œþtoðu Au.
Statusbar ™e W…h™t ¼t„{tk sheet status òuðt {¤u Au. File {tk current available sheets ‚u{s yu sheets {tk sðt {txu Prev, next, First, last {txu™t Buttons Œþtoðu÷ Au.
Sheet status …h mouse ðzu right click fh‚tk yt…u÷t option ™e {ŒŒÚte file {tk sheet ™u Select, Insert, Delete, Rename, Move/Copy fhe þftÞ Au.
Statusbar
Screen {tk formulabar ™e ™e[u Column Heading Œþtoðu÷ Au. Column Heading A, B, C ..... Z, AA, AB, ..... AZ, BA, BB, BC.... BZ..... AMJ ËwÄe Alphabatic Notation Úte Œþtoðu÷ Au.
Screen {tk ztƒe ƒtsw (left side) (Numeric) ™kƒh™e Q¼e ÷tE™ Row Heading Œþtoðu Au. 1, 2, 3, 4, 5, ........... 1048576 Row ËwÄe Œþtoðu÷ Au.
Sheet worksheet, spreadsheet suðt ™t{Úte …ý ytu¤¾tÞ Au.
yuf File {tk yuf fh‚tk ðÄthu worksheet òuðt {¤u Au. File {tk sYrhÞt‚ {wsƒ worksheet insert fhe þftÞ Au.
File ™u workbook ‚hefu …ý ytu¤¾ðt{tk ytðu Au.
Row/Column Heading
ynª yuf Book (workbook) {tk yuf fh‚tk ðÄthu sheet ntuÞ Au. By default 3 sheet open ntuÞ Au. ™ðe sheet sYrhÞt‚ {wsƒ insert fhe þftÞ Au. Row y™u Column ™t Intersection ™u Cell fnu Au. Default 3 sheet ™wk setting ƒŒ÷e sYh «{týu default sheet ht¾e þftÞ Au.
User
Worksheet rðþu Ë{sq‚e :
Column ™u alphabate Úte Œþtoððt{tk ytðu Au. arrow key) press fhðe. …nu÷e Column …h sðt {txu Ctrl + ¬ (Left arrow key) press fhðe.
AuÕ÷e Column …h sðt {txu ctrl + ® (Right
Column
Row ™u Number ðzu Œþtoððt{tk ytðu Au. AuÕ÷e Row …h sðt {txu ctrl + ¯ (down arrow key) press fhðe. …nu÷e Row …h sðt {txu Ctrl (up arrow key) press fhðe.
Row
OpenOffice
Computer World Publication11
Row y™u column ™t ËkÞtus™Úte ƒ™‚tk yuf{™u Cell fnu Au. Œhuf Cell ™wk yuf [tu¬Ë address ntuÞ Au. Address {txu …nu÷t column y™u …Ae row æÞt™{tk ÷uðtÞ Au. Œt.‚. A1 ynª A ftu÷{ Au y™u 1 htu Au. Current Cell Address, Formulabar yt„¤ ytðu÷t Name box {tk Indicate ÚttÞ Au. (Œþtoðu÷ ntuÞ Au).
Cell
Cell …h cursor ðzu Âõ÷f fh‚tk, cursor cell {tk ztƒe ƒtsw ™t™wk (square) òuðt {¤u Au. yt small square …h Âõ÷f fh‚tk + sign òuðt {¤þu. yt cell pointer ™u drag fhe ‚u™tu y÷„ y÷„ he‚u W…Þtu„ fhðt{tk ytðu Au.
Cell Pointer
xample :E
A1 cell {tk 1 type fhðwk. íÞthƒtŒ A2 cell {tk 2 type fhðwk. nðu Cursor A1 cell …h ÷tðe A1 y™u A2 cell select fhðt ƒu cell select fÞto ƒtŒ cursor ™u cell pointer …h ÷E sE Âõ÷f Press fhe ™e[u™e ‚hV drag fh‚tk number ™e series òuðt {¤þu. yt{ sYh «{týu series ÷E þftÞ Au.
Formulabar ™e yt„¤ ytðu÷ ™t™t box ™u Name box fnu Au. su current cell ™wk address Œþtoðu Au. ‚u{s yt Name box ™e {ŒŒÚte …nu÷tÚte Insert fhu÷t group of cell ™t Name ™u select fhe þftÞ Au.
Name Box
File menu ™t yt f{tLz™e {ŒŒÚte ™ðe spreadsheet create fhe þftÞ Au. su™wk default name untitled-1 òuðt {¤þu.
New
File menu ™t yt f{tLz™e {ŒŒÚte current workbook ™u save fhe þftÞ Au. Save fhu÷e Œhuf workbook ™u .ods (ODS spreadsheet) extension ÷t„u Au.
Save
yt option ™e {ŒŒÚte workbook ™u different name y™u format ËtÚtu ftuE ƒeò location …h save fhe þftÞ Au.
Export
OpenOffice
Computer World Publication12
File menu {tk Export... option …h Âõ÷f fh‚tk Export dialog box open Útþu. ynª Save in {tk su søÞtyu file store fhðe ntuÞ ‚u location ™¬e fhe file name ™t texbox {tk file ™wk ™t{ yt…ðwk.
Automatic file name extension .pdf nþu su change fhðwk ntuÞ ‚tu fhe þftÞ Au.
Page Previewyt f{tLz™e {ŒŒÚte spreadsheet ™tu page preview òuðt {¤u Au.
yt f{tLz™e {ŒŒÚte Active spreadsheet ™e paper W…h printout ÷E þftÞ Au. “File menu” {tk ‘print’ option select fhðtÚte yÚtðt ctrl + p f{tLz yt…ðtÚte ‘print’ dialog box òuðt {¤u Au. Copies
box {tk sux÷e copy print fhðe ntuÞ ‚u™e ËkÏÞt type fhðe. Properties. button …h click fh‚tk printing {txu Document properties set fhe þftÞ Au.
íÞthƒtŒ ‘print’ box {tk sYh «{týu sheets selection fhðwk.
‘Print range’ box {tk sYhe printing page ™wk selection fhe OK button …h click fhðwk.
yt{, print option select fhe OK button press fhðtÚte printer {tkÚte paper …h printout {¤e sþu su™u Hard copy …ý fne þftÞ.
OpenOffice
Computer World Publication13
Edit menu Cut fhu÷ ¼t„ Clipboard {tk Store ÚtE òÞ Au suÚte Document {tkÚte Cut fhu÷ ¼t„™u ƒesu MÚtt™u Paste fhe þftÞ Au.
™t yt Command ™e {ŒŒÚte Select fhu÷ Text fu Graphics ™u Cut fhe þftÞ Au. yt
Cut Ctrl + X
Edit menu ™t Copy fhe þftÞ Au.
yt Command ™e {ŒŒÚte Select fhu÷ ftuE [tu¬Ë Text ™u Window Clipboard {tk
Copy Ctrl + C
Edit menu ™t Document {tk Store fhe þftÞ Au.
yt Command ™e {ŒŒÚte y„tW Copy fu Cut Command Úte Select fhu÷ Text ™u
Paste Ctrl + V
Cut, Copy, Paste
ChangesEdit menu ™t yt option ™e {ŒŒÚte current sheet {tk fhu÷t VuhVth suðt fu insert, delete, copy, move, edit ð„uhu highlight ÚttÞ Au. su track îtht ŒþtoðtÞ Au.
NavigatorEdit menu ™t yt option ™e {ŒŒÚte Navigator Dockable window On/Off ÚttÞ Au. yt Navigator dockable window {tk current cell yÚtðt Navigator {tk yt…u÷ column y™u row ™t text box {tk yt…ðt{tk ytð‚e column, row ðt¤t cell ‚u{s dataRange ™t ytÄthu Link area, Graphics, OLE objects, Notes, Drawing object ð„uhu Navigator ÚtE þfu Au.
Toggle, Scenarios, Data Range suðt toolbutton yt…u÷t Au. su™e {ŒŒÚte sheet {tk option «{týu Navigate fhe þftÞ Au.
Header & FootersEdit menu ™t yt option ™e {ŒŒÚte sheet {tk insert fhu÷t Headers y™u footers {tk VuhVth fhe þftÞ Au. ‚u{s yt…u÷ Headers & footers ™e format …ý ƒŒ÷e þftÞ Au. y™u yu{tk VuhVth …ý fhe þftÞ Au. Edit Menu {tk Headers & Footers... option …h click fh‚tk header & footer dialog box open Útþu. Header & Footer tab …h click fh‚tk header {txu™wk setting ºtý ¼t„{tk ðnU[tÞu÷wk òuðt {¤þu.
OpenOffice
Computer World Publication14
Left area, Center area y™u Right Area. Date, time, page, pages, sheet name, title ð„uhu su Area {tk yt…ðwk ntuÞ ‚u Area {tk cursor set fhe yt…u÷t buttons ™e {ŒŒÚte header yt…ðwk. yt…u÷t Header ™t font fu format ƒŒ÷ðt {txu font button …h click fhðwk. Footers setting {txu footer tab …h click fhðwk. Footer setting Header setting ™e su{s fhe þftÞ Au. íÞthƒtŒ OK button …h click fhðwk.
Header & footer …nu÷eðth sheet {tk insert fhðt {txu file menu {tk page preview option …h click fhðwk. yu{tk yt…u÷t foarmat page option …h click fhðwk. yt…u÷t dialog box {tkÚte header yÚtðt footer select fhe sYh «{týu insert fhe þftÞ Au. Edit button …h click fh‚tk Header & Footer {txu dialog box open Útþu.
FillEdit menu ™t yt option ™e {ŒŒÚte cell {tk yt…u÷t data Fill Range ytÃÞt «{týu copy ÚttÞ Au. ‚u{s yt option ™e {ŒŒÚte series …ý fill fhe þftÞ Au. Ëti «Út{ su data copy fhðt Au ‚u cell {tk type fhe cell range yt…ðe (Area select fhðtu) su cell {tk data type fÞto Au íÞtkÚte mouse ðzu drag fhðwk. Drag-up, down, left yÚtðt right ftuE …ý side ßÞtk data copy fhðt ntuÞ íÞtk ËwÄe fhðwk.
Edit menu {tk fill option …h click fhðwk. yt…u÷ range «{týu Down, up, left, right option Activate òuðt {¤þu.
su Option select fhðt{tk ytðu ‚u range {tk data copy ÚtE sþu.
OpenOffice
Computer World Publication15
Edit menu ™t yt option ™e {ŒŒÚte cell {tk yt…u÷t data Fill Range ytÃÞt «{týu copy ÚttÞ Au. ‚u{s yt option ™e {ŒŒÚte series …ý fill fhe þftÞ Au. Ëti «Út{ su data copy fhðt Au ‚u cell {tk type fhe cell range yt…ðe (Area select fhðtu) su cell {tk data type fÞto Au íÞtkÚte mouse ðzu drag fhðwk. Drag-up, down, left yÚtðt right ftuE …ý side ßÞtk data copy fhðt ntuÞ íÞtk ËwÄe fhðwk.
Edit menu {tk fill option …h click fhðwk. yt…u÷ range «{týu Down, up, left, right option Activate òuðt {¤þu.
su Option select fhðt{tk ytðu ‚u range {tk data copy ÚtE sþu.
Fill option {tk yt…u÷ series option ™e {ŒŒÚte Numeric ‚u{s date ™e series fill fhe þftÞ Au.
Number yÚtðt Date ™e series fill fhðt {txu Ëti «Út{ cell {tk starting Number yÚtðt date type fhðt.
sux÷t Number ËwÄe yÚtðt date ËwÄe series yt…ðe Au ‚ux÷t cell select fhðt.
Edit menu {tk fill option …h click fhe series option …h click fhðwk. Fill series dialog box open Útþu.
Series
Direction, seriestype ð„uhu option select fhðt ˤk„ 1, 2, 3... suðt ™kƒh {txu Linear …ËkŒ fhðwk. Date {txu series type {tk date option select fhðtu.
Date option select fh‚tk s Time unit option Enable òuðt {¤þu.
Time unit option {tk Day option select fhðtu.
yt òu Number Fill fhðtu ntuÞ fu date fill fhðe ntuÞ yÚtðt Autofill fhðwk ntuÞ íÞthu startvalue, Endvalue option {tk þYyt‚ y™u yk‚™e value type fhðe
OpenOffice
Computer World Publication16
Increment option ™e {ŒŒÚte 1 yÚtðt 2 yÚtðt sYh {wsƒ™wk Increment yt…e OK button …h click fhðwk. yt{ OK button …h click fh‚tk s selection option {tk series fill ÚtÞu÷e òuðt {¤þu.
Delete Contentsyt option ™e {ŒŒÚte cell {tk þwk delete fhðwk Au ‚u™wk list òuðt {¤þu y™u selection ™t ytÄthu ‚u cell {tkÚte delete Útþu. Œt.‚. Text, formula, Number, Formats, Objects, date & time ð„uhu.
Ët{tLÞ he‚u open office {tk ftuE…ý cell ™e content Remove fhðt (delete fhðt) ‚u cell select fhe delete key press fh‚tk ‚whk‚ (By default) Delete contents dialog box open ÚtE sþu.
òu Delete Content dialog box open fÞto ð„h ËeÄe s {trn‚e Œqh fhðe ntuÞ ‚tu fe ƒtuzo ðzu Shift+Delete fe Press fhðe.
su cell ™t data delete fhðt ntuÞ ‚u cell select fhe Edit menu {tk delete contents option select fhðwk. (yÚtðt Delete key press fhðe)
Delete contents dialog box open Útþu. òu cell ™e ƒÄe s format ËtÚtu content delete fhðe ntuÞ ‚tu Delete all option select fhðtu.
Võ‚ Notes fu format yÚtðt formulas delete fhðe ntuÞ ‚u «{týu option select fhðt. yt{ fh‚tk cell {tk™e content delete ™Úte Út‚e …hk‚w ‚u™u yt…u÷e format yÚtðt notes ð„uhu delete ÚttÞ Au.
yuf fh‚tk ðÄthu option …ý select ÚtE þfu Au. íÞthƒtŒ OK button …h click fhðwk.
Delete Cell option ™e {ŒŒÚte yt¾e row ‚u{s yt¾e column delete fhe þftÞ Au.
OpenOffice
Computer World Publication17
Sheetyt option ™e {ŒŒÚte sheet move, copy, delete, select fhe þftÞ Au. Ëti «Út{ Edit menu {tk sheet option …h click fh‚tk Move, copy, delete suðt option òuðt {¤þu. su option select fhðtu ntuÞ ‚u select fh‚tk ‚u™u y™wËkÄt™{tk dialog box oepn Útþu. Move/Copy option select fh‚tk move/copy sheet dialog box òuðt {¤þu. Sheet ™u su sheet yt„¤ move fhðe ntuÞ ‚u sheet insert before box {tkÚte select fhðe. íÞthƒtŒ OK button …h click fhðwk. ynª sheet Võ‚ move Útþu. ßÞthu yt dialog box {tk copy option (checkbox) select fh‚tk sheet move & copy Útþu.
Sheet ™u ƒeò document {tk move fu copy fhðe nþu ‚tu To document option select fh‚tk ‚u ÚtE þfþu.
Edit menu {tk sheet option …h click fh‚tk select option òuðt {¤þu. ynª select option …h click
fh‚tk select dialog box open Útþu. su™e {ŒŒÚte sheet select fhe þftþu.
Sheet select fhðt {txu ™e[u yt…u÷t sheet list {tk su sheet select fhðe Au ‚u sheet …h mouse ðzu clickfh‚tk yt¾e sheet select ÚtE sþu.
Sheet {tk delete option …h click fh‚tk sheet delete ÚtE sþu.
Page Break PreviewView menu ™t yt f{tLz™e {ŒŒÚte Active worksheet {tk sux÷t data nþu Võ‚ ‚u™tu s view òuðt {¤u Au.
OpenOffice
Computer World Publication18
ZoomView menu ™t yt f{tLz™e {ŒŒÚte screen W…h òuðt {¤‚e spreadsheet size {tk ðÄthtu fu ½xtztu fhe þftÞ Au. ynª zoom minimum 20% y™u maximum 400% fhe þftÞ Au.
Manual BreakSpreadsheet {tk Column yÚtðt Row ™u Manual Break yt…e þftÞ Au. Spreadsheet {tk ßÞtk Row fu Column break fhðtu Au ‚u cell …h cursor ÷E sðwk. Insert menu {tk yt…u÷ menual Break option ™e {ŒŒÚte Row Break or (yÚtðt) Column Break select fhtu. Spread sheet {tk ßÞtk Break ytÃÞtu nþu íÞtk Blue line òuðt {¤þu. Edit menu {tk yt…u÷ Delete menual Break option set fhðtÚte yt…u÷ Row/Column break Œqh ÚtE sþu.
CellInsert menu ™t yt f{tLz™e {ŒŒÚte spreadsheet {tk Row, column cell insert fhe þftÞ Au. ƒ™tðu÷ Table {tk cell insert fhðt {txu yÚtðt Row, column insert fhðt {txu su søÞtyu Insert fhðwk ntuÞ ‚u cell …h cursor ÷tððwk. Insert menu {tk cell option …h click fh‚tk insert cells dialog box open Útþu.
Insert Cell option {tk selection box {tk su «{týu insert fhðwk ntuÞ ‚u option select fhðtu.
RowsInsert menu ™t yt f{tLz™e {ŒŒÚte Rows insert fhe þftÞ Au. su søÞtyu Row insert fhðe ntuÞ ‚u cell yÚtðt Row …h cursor ÷tðe Insert menu {tk Rows option …h click fh‚tk ‚u celll W…h yuf ™ðe Row insert ÚtE sþu.
OpenOffice
Computer World Publication19
ColumnInsert menu ™t yt f{tLz™e {ŒŒÚte columns insert fhe þftÞ Au. su MÚtt™ …h column insert fhðe ntuÞ ‚u cell yÚtðt column …h cursor ÷tðe Insert menu {tk columns option …h click fh‚tk column insert fhe þftÞ Au. Row column heading {tk ƒu column yÚtðt ƒu row ðå[u™e ÷tE™ …h click fh‚tk ‚u Row ™e height y™u column ™e with ðÄthe-½xtze þftÞ Au.
Sheet™ðe sheet insert fhðt {txu yt option ™tu W…Þtu„ ÚttÞ Au. Insert menu {tk sheet option …h click fh‚tk insert sheet dialog box open Útþu.
Insert sheet dialog box {tk position selection {tk before current sheet, After current sheet {tkÚte su option select fhðtu ntuÞ ‚u yuf option select fhðtu. No. of sheet box {tk sux÷e sheet insert fhðe ntuÞ yux÷t No. yt…ðt. OK button …h click fh‚tk sheet insert ÚtE sþu. “From file” option ™tu W…Þtu„ ƒeS file {tk™e sheet current file {tk insert fhðt {txu ÚttÞ Au.
Sheet From FileInsert menu ™t yt option ™e {ŒŒÚte current file {tk ƒeS file {tk™e sheet insert fhe þftÞ Au. Insert menu {tk yt option …h click fh‚tk insert dialog box open Útþu.
OpenOffice
Computer World Publication20
Insert dialog box ™e {ŒŒÚte su file {tk™e sheet insert fhðe ntuÞ ‚u file insert fhðe. ynª From file ™t box {tk ƒeS file ™e sheets ™wk list òuðt {¤þu. ƒeS file {tk™e su sheet Insert fhðe ntuÞ ‚u sheet select fhðe. íÞthƒtŒ Ok button …h click fhðwk. Spread sheet {tk ™e[u yt…u÷ sheet list …h mouse ™e right key press fh‚tk sheet ™wk shortcut menu open Útþu, su™e {ŒŒÚte sheet insert, delete, move, copy, rename y™u select fhe þftÞ Au.
FunctionsInsert menu ™t yt option ™e {ŒŒÚte function wizard open Útþu su{tk category ™u ÷„‚t function ™wk list òuðt {¤þu. yt yuf pre-define tool Au su™e {ŒŒÚte „trýr‚f ftÞo fhe þftÞ Au. su{ fu Sum, Average, Maximum, Minimum, Power, count ð„uhu.
Category list {tk database, Date & Time, Financial, Information, Logical, Mathimatical, Statisticaly, Text ð„uhu. Function category òuðt {¤þu. su category select fhðt{tk ytðþu ‚u category {tk function ™wk list òuðt {¤þu.
Mathematical category select fh‚tk mathemetical function ™wk list òuðt {¤þu. su™t W…Þtu„Úte Ënu÷tEÚte „trý‚ef ftÞo ÚtE þfþu.
nðu swŒt swŒt Function ™u rð„‚ðth Ë{sðt {txu WŒtnhý òuEþwk.
OpenOffice
Computer World Publication21
Fill option {tk yt…u÷ series option ™e {ŒŒÚte Numeric ‚u{s date ™e series fill fhe þftÞ Au.
SUM
yt…u÷t marksheet table {tk student ™t marks ™tu Ëhðt¤tu fhðt {txu Ëti «Út{ ßÞtk Ëhðt¤tu (total) sYhe Au ‚u cell …h mouse îtht click fh‚tk cell select Útþu.
Insert menu {tk F(x) (Function) option select fhðtu. Function wizard open Útþu. [Formula toolbar …h f(x) option òuðt {¤þu.
Open ÚtÞu÷ function wizard {tk mathematical category select fhe sum option function list {tkÚte select fhðwk.
Next button …h click fh‚tk argument number ™t list {tk su™wk total fhðwk Au ‚u number yuf …Ae yuf yt…ðt Formula ™t tex box {tk yt…u÷t number òuðt {¤þu. Result ™t Box {tk
OpenOffice
Computer World Publication22
Example :
= ABS (-56) return 56
= ABS (0) return 0
yt{ WŒtnhý «{týu function wizard {tk function select fhe Argument number yt…‚t su function selected nþu ‚u™u ÷„‚wk Output (Result) òuðt {¤þu.
result òuðt {¤þu. í[thƒtŒ OK button …h click fh‚tk selected cell {tk total (sum) {¤e sþu.
Argument Number ™t list {tk Number ™ yt…‚t Range …ý yt…e þftÞ Au.
yt Function ™e {ŒŒÚte select fhu÷ cell range {tk su value ntuÞ ‚u™e average þtuÄe þftÞ Au.
Average
Maximum
yt function cell ™e su range select fhe ntuÞ ‚u{tkÚte ËtiÚte {n¥t{ ®f{‚ þtuÄu Au.
yt function maximum function Úte rðhwØ™wk function Au. yt…u÷ range yÚtðt ™kƒh{tkÚte ™t™t{tk ™t™e value þtuÄu Au. Minimum value þtuÄðt {txu™e …Ør‚ Maximum suðe Au.
Minimum
yt function yt…u÷t number ™e Absolute value Œþtoðu Au. yux÷u fu Võ‚ positive value Œþtoðu Au.
Function wizard {tk mathematical category select fh‚tk ABS function òuðt {¤þu.
ABS function select fhe Next fh‚tk argument number box {tk Negative number type fh‚tk ‚u number absolute number yux÷u fu positive number {tk s òuðt {¤þu. Œt.‚. (-12) nþu ‚tu (12) òuðt {¤þu.
ABS
How to written Functionssu cell {tk function yt…ðwk ntuÞ ‚u select fhðtu. Function wizard ™t W…Þtu„ ð„h cell {tk function ÷¾ðt {txu Ëti «Út{= (sign) yt…ðe sYhe Au.
OpenOffice
Computer World Publication23
su function ytÃÞwk ntuÞ ‚u™t y™wËkÄt™{tk fucnction {tk range yÚtðt arguments number yt…ðt. Œt.‚. cell C10 {tk sum function yt…ðwk ntuÞ ‚tu cell C10 select fÞto ƒtŒ sum function {tk range yt…ðe. = Sum (C5:C9) yt{ C5 Úte C9 ËwÄe™t ™kƒh™tu Ëhðt¤tu {¤þu.
Function {tk™t argument (;) semicolon ðzu y÷„ …zu Au. (yuf argument …Ae ƒeS argument ðå[u ; y…tÞ Au.) y™u range :(colon) ðzu y…tÞ Au. ‚u{s value, reference, range, string ð„uhu () (Open-close rounde bracket){tk y…tÞ Au.
Forumlabar …h yt…u÷ S (Sigma) sign ™e {ŒŒÚte …ý sum (total) {u¤ðe þftÞ Au.
Discuss of some useful functionsu cell {tk function yt…ðwk ntuÞ ‚u select fhðtu. Function wizard ™t W…Þtu„ ð„h cell {tk function ÷¾ðt {txu Ëti «Út{= (sign) yt…ðe sYhe Au.
Countblank
yt function range {tk ¾t÷e (empty) cell ™e ËkÏÞt fux÷e Au Œþtoðþu.
xample :E
= countblank (A1:B2)
òu A1, A2, B1, B2 cell ¾t÷e (empty) nþu ‚tu Result 4 yt…þu.
DEGREES
yt Function radians ™u degrees {tk convert fhu Au.
Ëqºt
xample :E
= Degrees(PI())
RESULT
=DEG (Number)
180 degrees
RESULT
Trunc
yt function ™e {ŒŒÚte Number truncate Útþu y™u Decimal places remove Útþu. sYh «{týu number ™t decimal places ht¾e þftÞ Au.
OpenOffice
Computer World Publication24
Ëqºt
xample :E
= TRUNC (1.239; 2)
=TRUNC (number; count)
RESULT 1.23
ynª 9 number remove Útþu y™u 2 count ytÃÞt Au {txu ƒu decimal places hnuþu.
PI
„trý‚eÞ y[¤ PI (…tE)™e value 3.14159265358979 Œþtoðþu su™u 14 decimal places Au. PI ™e value 3.14 yÚtðt 22/7 ‚hefu …ý ŒþtoðtÞ Au.
Power
yt function ™e {ŒŒÚte yt…u÷ Number (base) ytÄth y™u yt…u÷ Power (½t‚) «{týu „ý‚he fhe Œþtoðþu.
Ëqºt
xample :E
= Power (4; 2)
RESULT
=Power (number; power)
16 (4 ™e 2 ½t‚ 4 * 4 = 16)
Product
Ëqºt =product (number1; number2; number3)
yt function ™e {ŒŒÚte yt…u÷ ™kƒh™tu „wýtfth (multiplication) {¤þu.
xample :E
= Product (2; 3; 6; 1; 2)
RESULT 72
ynª Range yÚtðt sux÷t number yt…ðt ntuÞ ‚ux÷t yt…e þftÞ Au.
OpenOffice
Computer World Publication25
MOD
Ëqºt
xample :E
= MOD (22; 3)
=MOD (divident; divisor)
yt Function ™e {ŒŒÚte ¼t„tfth{tk™e þu»t {¤u Au.
Quotient
Ëqºt
xample :E
=Quotient (11; 3)
RESULT
=Quotient (Numerator; Denominator)
3
yt function ™e {ŒŒÚte ¼t„V¤ {¤þu.
ynª ¼t„V¤ 3 {¤þu ßÞthu þu»t 2 ™tƒqŒ ÚtE sþu yux÷u fu Œþtoðþu ™nª.
SQRT
Ëqºt =SQRT (Number)
yt function ™e {ŒŒÚte yt…u÷ Number ™tu positive square root {¤þu.
RESULT 1
ynª 22 ™u 3 ðzu ¼t„‚tk þu»t 1 ðÄþu.
xample :E
=SQRT (16)
RESULT 4
OpenOffice
Computer World Publication26
DATE
yt function date Calculate fhu Au su year, month y™u day xtE… fh‚tk ™e format {tk display ÚttÞ Au.
MM:DD:YY
Ëqºt =DATE(year; month; day)
xample :E
=DATE (2000; 12; 31)
RESULT 12/31/2000
Isleapyear
yt function ™e {ŒŒÚte year leap year Au fu ™nª ‚u ™¬e ÚtE þfu Au. òu (sðtƒ) 1 ytðu ‚tu ‚u TRUE yux÷u fu leap year Au. ßÞthu value 0 ytðu ‚tu ‚u False yux÷u fu leap year ™Úte.
value
Ëqºt
xample :E
=ISLeapyear(“2/2/2002”)
RESULT
=ISLEAPYEAR (Date)
0 : ( leapyear ™Úte)
ARABIC
yt function ™e {ŒŒÚte Roman number ™e value Calculate fhe þftÞ Au value range 0 Úte 3999 ðå[u™e s ntuðe òuEyu.
Ëqºt =ARABIC (Text)
xample :E
=ARABIC (“MXIV”)
RESULT 1014
“MXIV” Text Roman number Œþtoðu Au.
Concatenate
yuf fh‚tk ðÄw string ™wk yuf string ‚hefu™wk òuztý yt function ™e {ŒŒÚte ÚttÞ Au.
OpenOffice
Computer World Publication27
Ëqºt
xample :E
=CONCATENATE (“Good”; “Morning”; “Mrs.”; “SHAH”)
RESULT
=CONCATENATE (Text1; text2; text3.....)
GoodMorningMrs.Shah
Concatenate string string string ™e ðå[u M…uþ ht¾ðe ntuÞ ‚tu yt {wsƒ Vkfþ™ ÷¾ðwk ...
Vkfþ™ yt…‚tk yufÚte ðÄw òuztE™u yuf ƒ™u Au. nðu, òu Œhuf TiP
=CONCATENATE ("Good";" ";"Morning";" ";"Mrs.";" ";"SHAH")
Exact
yt function ƒu text string ™e Ëh¾t{ýe {txu ð…htÞ Au, òu ƒu string yuf s suðe ntuÞ ‚tu sðtƒ True ytðu Au. ™nª‚h sðtƒ False ytðu Au.
Ëqºt
xample :E
=Exact (“Open Office”; Open Office”)
RESULT
=Exact (Text1; text2)
TRUE
yt function case sensitive Au.
otesN
òu ftuE…ý character ƒeS text {tk capital letter {tk nþu yÚtðt First text {tk capital letter nþu y™u ƒeS text {tk ™nª ntuÞ ‚tu Result False s Œþtoðþu.
LEN
Ëqºt
xample :E
=LEN (“GoodMorning”)
=LEN (TEXT)
yt function ™e {ŒŒÚte text ™e length {¤u Au.
OpenOffice
Computer World Publication28
RESULT 11 (11 character Au.)
òu Text {tk M…uË ntuÞ ‚tu yu …ý yuf character „ýtÞ Au.
otesN
LOWER
Ëqºt =Lower (text)
yt function yt…u÷ uppertext ™u lowertext {tk convert fhðt™wk ft{ fhu Au.
RESULT Sun
Upper
yt…u÷ function lower text ™u upper text {tk convert fhðt™wk ft{fhu Au. ‚u lower function ™e su{ s yt…e þftÞ Au.
Rept
Ëqºt
xample :E
=REPT (“Good Morning”; 2)
RESULT
=Rept (text; number)
“Good Morning Good Morning”
yt function yt…u÷ text ™u sux÷t ™kƒh ytÃÞt Au ‚ux÷eðth copy fhþu.
Result maximum 255 character ËwÄe {¤þu.
otesN
xample :E
=lower (“SUN”)
AND
yt function Logically value ™u check fhðt {txu W…Þtu„e ÚttÞ Au. yt…u÷t Arguments/conditions (ƒÄe s) òu True nþu ‚tu s Result True ytðþu. òu ftuE yuf …ý Argument yÚtðt condition False nþu ‚tu Answer (Result) False ytðþu.
Ëqºt =AND (Logical Value1; Logical Value2; Logical value3; .....)
OpenOffice
Computer World Publication29
xample :E
=AND (12<13; 14>12; 7<6)
RESULT False
OR
yt function {tk òu ftuE yuf …ý argument True nþu ‚tu ‚u Result True {tk ƒ‚tðþu òu ƒÄt s Arguments/conditions False nþu ‚tu s Answer False {tk Œþtoðþu.
xample :E
=OR (2<1; 6>5; 9<3)
RESULT TRUE
1 xample :E
=OR (12>11; 13>22; 45 = 45)
2
ƒk™u Example ™tu Answer True {¤þu.
IF
Ëqºt =If (Test; Then_value; otherwise_Value)
yt function ™tu W…Þtu„ logical test fhðt {txu ÚttÞ Au.
Test
Test yu ftuE…ý value yÚtðt conditional Expression yÚtðt expression nþu su True yÚtðt False ntuE þfu.
Then_Value
(Optional) Then_Value ‚hefu yt…u÷ value íÞthu s Œþtoðþu (Return Útþu) ßÞthu logical_test true nþu.
Otherwise_Vlaue
(Optional) Logical test False Útþu íÞthu s otherwise_value return Útþu. (Œþtoðþu).
÷¾ðt™e …Ør‚ =OR (logical value1; Logical Value2; Logical Value3; ......)
xample :E
= IF (A1 >5; 100; “Too Small”)
OpenOffice
Computer World Publication30
RESULT ynª yt…u÷ cell A1 {tk™e value òu 5 fh‚tk ðÄw nþu ‚tu logical test true Útþu y™u 100 (Then_value) display Útþu yux÷u fu Answer 100 Œþtoðþu …hk‚w A1 {tk™e value 5 fh‚tk ytuAe nþu ‚tu logical_test False Útþu y™u yt fthýu otherwise_value “Too small” display Útþu.
ßÞtk Logical condition ™wk Calculation fhðt™wk ntuÞ íÞtk yÚtðt Logical condition ™e {ŒŒÚte data yt…ðt™t ntuÞ íÞtk IF () ™tu W…Þtu„ ðÄw ÚttÞ Au. Œt.‚. student ™e marksheet {tk grade Œþtoððt, employee data {tk salary raise Œþtoððt, salary y™wËkÄt™{tk PF, DA, TA, HRA, Net salary ð„uhu count fhðt {txu yux÷u fu payslip ƒ™tððt {txu Nested IF ™tu W…Þtu„ …ý fhe þftÞ Au.
otesN
Lookup
Lookup Function ™e {ŒŒÚte yt…u÷ search value fu reference ™u ‚u one row yÚtðt one column range ™e {ŒŒÚte return fhþu. (Œþtoðþu).
Ëqºt =Lookup (search criterion; search vector; result vector)
Search criterion
Search criterion {tk yt…u÷ value direct yÚtðt reference îtht yt…u÷ Au su™t îtht table {tkÚte value þtuÄðt™e Au.
Search Vector
yt yuf single row yÚtðt single column area Au ßÞtkÚte value þtuÄðt™e Au.
Result_Vector
yt …ý yuf single row yÚtðt single column Au su™t îtht function ™wk result {¤u Au.
Lookup {txu yt…u÷ table sorted ntuðwk sYhe Au òu table sorted ™nª ntuÞ ‚tu search result ft{™wk ™ …ý ntuE þfu y™u òu lookup search criterion find ™ fhe þfu ‚tu yÚtðt ‚u table {tk value ™nª ntuÞ ‚tu ‚u yt…u÷ value ™e ™Sf™e largest value ËtÚtu match fhe result Œþtoðþu.
otesN
OpenOffice
Computer World Publication31
xample :E
= Lookup (A1; D5:D10; C5: C10)
RESULT ynª yt…u÷ example «{týu A1 cell {tk 68 value yt…u÷ Au. Search_Vector y™u Result Vector ™e range yt…e Au. yt…u÷ range ™u y™w÷ûte™u òuEyu ‚tu 68 yu D6 column {tk ytðu÷t Au. C5 Úte C10 ™e range {tk C6 cell {tk 58 value Au su yt lookup ™tu sðtƒ Au. (Result Au.)
Vlookup
yt function ™e {ŒŒÚte cell ™t reference Úte column search (vertical) fhðtÚte cell data òuðt {¤þu.
Ëqºt = VLookup (search criterion; array; index; sort order)
Function check fhþu fu yt…u÷ value First column Array {tk ytðu÷ Au ?
ynª sort order parameter omitted yÚtðt set to true nþu (Äthtu fu data [z‚t ¢{{tk „tuXðtÞu÷t Au) íÞthu exact value {¤‚e ™Úte.
ßÞthu sort order set to False yÚtðt zero nþu íÞthu exact match {¤e sþu.
Search Criterion
Search Criterion {tk yt…u÷ value «Út{ column of the array nþu ßÞtkÚte column count fhe ‚u™t y™wËkÄt™{tk Range «{týu result {¤þu.
Array
yt yuf reference Au su ƒu fu ‚uÚte ðÄw column ™tu array Ähtðu Au. xqfk{tk table ™e range su{tkÚte data find fhðt™t Au.
Index
Column number Œþtoðu Au su search criterion {tk yt…u÷ value su column {tk nþu íÞtkÚte column No. Count fhe Result Œþtoðþu.
Sort order
Optional parameter Au. su Œþtoðu Au fu «Út{ column {tk™t data ascending order ([z‚t ¢{) {tk Au fu ™nª.
OpenOffice
Computer World Publication32
xample :E
=Vlookup (78; C5:F10; 2)
RESULT yt…u÷ example {tk ŒþtoÔÞt «{týu search criterion {tk yt…u÷ value «Út{ column {tk Au. Array yu table selection range Œþtoðu Au. Index {tk yt…u÷ 2 value Œþtoðþu fu 78 value ™e Ët{u second(2) column {tk fE value Au ‚u Œþtoðþu (2 yu column No. Œþtoðu Au.)
Hlookup
Hlookup {tk vertical lookup «{týu column ™e søÞtyu ROW îtht search ÚttÞ Au. ynª Array {tk ƒu fu ‚uÚte ðÄw row selection yÚtðt table selection yt…e þftÞ Au. Index yu row ™kƒh Œþtoðu Au.
Ëqºt =Hlookup (search_criteria; array; Index; sorted)
xample :E
=Hlookup (78; C5 : F10; 2)
RESULT ynª Vlookup ™e søÞtyu Hlookup type fÞwO Au. Hlookup Row «{týu search fhe 78 Úte 2 row {tk su value nþu ‚u Œþtoðþu.
Hlookup y™u Vlookup {tk Row-Column counting search_criterion {tk yt…u÷ value yÚtðt reference su Row-column {tk ytðu÷t nþu íÞtkÚte 1 (first) count fhþu.
otesN
=Vlookup ( 78; C5:F10; 2)
Criteria; RangeColumn No.
=Hlookup ( 78; C5:F10; 2)
Criteria; RangeRow No.
NamesRange yÚtðt cell ™wk name (™t{) yt option ™e {ŒŒÚte yt…e þftÞ Au. Names option ™e {ŒŒÚte cell range ™u yt…u÷ name îtht insert fhe þftÞ Au. Name create fhe þftÞ Au. ‚u{s label …ý yt…e þftÞ Au.
OpenOffice
Computer World Publication33
Name ™t Option {tk Difine..., Insert..., Create..., Lables... suðt Sub Option òuðt {¤u Au.
Define
Insert menu {tk yt…u÷ names option …h fh‚tk Define option òuðt {¤þu. su™e {ŒŒÚte selected cell yÚtðt range ™u ™t{ yt…e þftÞ Au.
ynª cell yÚtðt range ™u ™t{ yt…ðtÚte spread sheet {tk ðthkðth ßÞthu y{wf data ™e sYh …z‚e ntuÞ íÞthu ðthkðth select fhðt™e sYh …z‚e ™Úte Võ‚ name yt…ðtÚte ‚u range {¤e òÞ Au.
yt f{tLz™e {ŒŒÚte su {trn‚e ™e sYh ðthkðth …z‚e ntuÞ y™u ‚u {trn‚e W…h Íz…Úte sðwk ntuÞ ‚tu name ™e {ŒŒÚte sE þftÞ Au.
Ëti «Út{ spreadsheet {tk ðthkðth sYh …z‚e {trn‚e™u select fhe Insert menu {tk Name option {tkÚte define option select fhðtÚte Define name ™wk dialog box òuðt {¤þu.
click
Ctrl + F3
Dialog box {tk Name ™t section {tk short name type fhðwk. Define Names ™t dialog box {tk assigned to {tk selected Area Œþtoðu÷ Au. Name type fÞto ƒtŒ Add button …h Âõ÷f fhtu. More option …h Âõ÷f fh‚tk Area type òuðt {¤þu. su sYh «{týu select fhe þftÞAu.
Ok button …h Âõ÷f fh‚tk Range {txu name define ÚtE sþu. yt…u÷ name, formulabar ™t name box {tk òuðt {¤þu. ßÞtkÚte Íz…Úte y™u Ëh¤‚tÚte define fhu÷t name ™tu W…Þtu„ fhe þftÞ Au.
OpenOffice
Computer World Publication34
ChartInsert Menu {tk™t chart option ™e {ŒŒÚte spread sheet {tk chart insert fhe þftÞ Au. Insert menu {tk chart option ™u select fh‚tk chart wizard dialog box open Útþu.
Choose a chart type ™t list box {tk chart types Œþtoðu÷ Au. Data ™u y™wËkÄt™ su chart type sYhe Au. ‚u select fhðe.
Selected chart type ™t view s{ýe ƒtsw™t box {tk òuðt {¤þu. 3D look {txu 3D look option ™u select fhðwk.
Column chart fu bar chart select fh‚t ‚u™t shape ™wk list …ý òuðt {¤þu.
Line chart select fh‚tk stack series, smoot lines properties ð„uhu options òuðt {¤þu. su sYh «{týu select fhðt.
Net chart {tk stack series option òuðt {¤þu.
Column and line chart type {tk no.of line option set fhe þftÞ Au.
Chart type select fÞto ƒtŒ next button …h fh‚tk data range ™wk step active Útþu.
OpenOffice
Computer World Publication35
Choose a data range option {tk Data range select fhe™u yt…ðe.
Data series in rows/ Data series in columns option {tkÚte su «{týu chart row fu column wise ÷uðtu ntuÞ ‚u «{týu option select fhðtu.
Next button …h click fh‚tk data series step select Útþu ßÞtk categories, Range for name, Data series, Data range ð„uhu add or remove fhe þftÞ Au. next button …h click fh‚tk chart elements step select Útþu.
Title, legend, grid setting ð„uhu yt…e þftÞ Au.
íÞthƒtŒ Finish button …h Âõ÷f fh‚tk yt…u÷ selection «{týu™tu chart spreadsheet {tk òuðt {¤þu.
Chart insert fÞto ƒtŒ ‚u{tk VuhVth fhðt {txu chart ™t su area …h Right click fhðt{tk ytðþu ‚u area ™wk Editing fhe þftÞ Au.
Default FormattingFormat menu ™t yt command ™e {ŒŒÚte spread sheet {tk fhu÷t VuhVth remove ÚtE òÞ Au y™u original format setting …tAwk {u¤ðe þftÞ Au.
CellFormat menu ™t yt command ™e {ŒŒÚte spread sheet {tk select fhu÷t cells ™wk Alignment, Number, Fonts, Font effects, Background, Borders, Cell protection ð„uhu ƒŒ÷e þftÞ Au.
OpenOffice
Computer World Publication36
Ëti «Út{ spread sheet {tk sYhe cell range select fhe “Format menu” {tk “Cells” command …h click fhðtÚte “Format cells” dialog box òuðt {¤þu.
Format cells ™t dialog box {tk ŒþtoÔÞt «{týu cells ™e range {tk category «{týu format ƒŒ÷ðe ntuÞ ‚tu Numbers {tk category select fhe yt…u÷ format select fhe sYh «{týu option set fhe OK button …h click fhðwk.
RowFormat menu ™t yt command ™e {ŒŒÚte row ™e height change fhe þftÞ Au ‚u{s row show/hide ÚtE þfu Au.
ColumnFormat menu ™t yt command ™e {ŒŒÚte column ™e width {tk VuhVth fhe þftÞ Au. ‚u{s column ™u Hide/show fhe þftÞ Au.
SheetFormat menu ™t yt command ™e {ŒŒÚte select fhu÷ sheet ™wk ™t{ change fhe þftÞ Au. Sheet ™u hide fhe þftÞ Au.
OpenOffice
Computer World Publication37
Merge CellsFormat menu ™t yt command ™e {ŒŒÚte selected cells ™u Merge (¼u„t) fhe þftÞ Au.
Merge ÚtÞu÷t cells ™u …tAt distribute fhðt ntuÞ ‚tu Merge cell ™u select fhe VheÚte yt option select fh‚tk Merge ÚtÞu÷t cells Aqxt ÚtE sþu.
PageFormat menu ™t yt command ™e {ŒŒÚte Page Style, Page Border, Background, Header, Footer set fhe þftÞ Au.
Print RangeFormat menu ™t yt command ™e {ŒŒÚte print fhðe ntuÞ ‚u Area ™e range define fhe þftÞ Au. Add …ý fhe þftÞ Au. ‚u{s ‚u™u Edit ‚u{s Remove …ý fhe þftÞ Au.
Conditional FormattingFormat menu ™t yt command ™e {ŒŒÚte current spreadsheet {tk condition «{týu selected data ™u yt…u÷ cell style ™e {ŒŒÚte Format yt…e þftÞ Au.
Ëti «Út{ su data ™u condition îtht format yt…ðt™e ntuÞ ‚u data select fhtu.
Format Menu {tk Conditional Formatting command ™u click fh‚tk Conditional Formatting dialog box open Útþu.
OpenOffice
Computer World Publication38
Condition 1 {tk Cell value is y™u Formula is ƒu option òuðt {¤þu cell value {txu cell value is option select fhe condition list {tkÚte condition select fhðe Cell style {tk™t list {tkÚte style select fhðe. ‚u{s yt…u÷ Range text box {tk value yt…ðe. OK button …h click fh‚tk selected data (Marks of all subject) {tk su cell {tk™t marks yt…u÷ value Úte ðÄw nþu íÞtk Result ™e format òuðt {¤þu.
Goal SeakTools menu ™t yt command ™e {ŒŒÚte ™¬e fhu÷ Target {u¤ððt {txu selected cell {tk VuhVth Útþu y™u Target «{týu™e value {u¤ðe þftþu.
“Tools menu” {tk goal seek command select fh‚tk Goal seek dialog box open Útþu.
“Set cell” ™t text box {tk su cell {tk VuhVth òuEyu Au ‚u cell select fhðtu yÚtðt text box {tk type fhðtu. “To value” text box {tk sYrhÞt‚ «{týu Target value type fhðe. “By changing cell” ™t text box {tk su cell {tk™e value ™t VuhVth™t fthýu target value {u¤ððt™e Au. ‚u cell select fhðtu yÚtðt text box {tk yt…ðtu.
xample :EStudent Marksheet ™t ftuE yuf student ™wk total 135 ntuÞ y™u 150 Target ntuÞ íÞthu Goal seek {tk To value {tk 150 type fhðwk ‚u{s Total 135 su cell {tk ntuÞ ‚u cell set cell {tk yt…ðtu, íÞthƒtŒ su cell ™e value (marks) {tk VuhVth îtht 150 {u¤ððt Au ‚u cell “Variable Cell” option {tk yt…ðtu. yt{ Goal Seek ™e {ŒŒÚte Target «{týu "Variable Cell" {tk value Automatic (yt…{u¤u) increase/Decrease (ðĽx) ÚtE Target value {u¤ðe yt…u Au.
ScenariosTools menu ™t yt command ™e {ŒŒÚte selected cell range ™u ™t{ yt…e scenarios ™¬e fhe þftÞ Au. Scenarios name Navigator {tk …ý òuðt {¤u Au. Table yÚtðt spreadsheet {tk yt…u÷t selected cell range {tk™tu scenario Border ™t fthýu y÷„ Œu¾tE ytðu Au. Border ™t title bar {tk last Scenarios ™t list òuðt {¤u Au.
yt…u÷ Scenarios Remove fhðt {txu Navigator Button …h click fhe Navigator ™t docking windows {tkÚte scenario option …h click fh‚tk scenario list òuðt {¤þu.
su scenario delete fhðtu ntuÞ ‚u scenario …h right click fh‚tk delete option òuðt {¤þu. Delete option …h click fh‚tk scenario delete ÚtE sþu.
OpenOffice
Computer World Publication39
Protect DocumentData menu ™t yt command ™e {ŒŒÚte sheet y™u document ™u password ™e {ŒŒÚte protect fhe þftÞ Au.
SortData menu ™t yt command ™e {ŒŒÚte spread sheet {tk ƒ™tðu÷ database yÚtðt table ™u W‚h‚t yÚtðt [z‚t ¢{{tk sYh «{týu „tuXðe þftÞ Au.
FilterData menu ™t yt command ™e {ŒŒÚte spreadsheet {tk hnu÷t data ™u ftuE [tu¬Ë condition ™e {ŒŒÚte òuE þftÞ Au. ‚u{s ‚u™u copy …ý fhe þftÞ Au. yt…u÷ marksheet ™u select fhðe. ftuE yuf subject {tk 60 Úte ðÄw marks {u¤ð™th student ™wk list òuðwk ntuÞ ‚tu sheet select fÞto ƒtŒ Data Menu {tk Filter command ™t Autofilter option …h click fhðwk. suÚte Œhuf Heading ™e s{ýe ƒtsw down arrow òuðt {¤þu. su subject {txu 60 Úte ðÄw marks ™e {trn‚e yufºt fhðe ntuÞ ‚u subject ™t heading ™t down arrow …h click fhðe.
Standard filter option …h click fh‚tk dialog box òuðt {¤þu. Field name ™e Ët{u condition >= (greater then equal to) sign select fhe value ™t box {tk 60 type fhe OK button …h click fhðwk. yt{ ‚u subject {tk 60 Úte ðÄw marks {u¤ð™th students ™wk list òuðt {¤þu. Table yÚtðt database ßÞtk filter option ™tu W…Þtu„ fhðtu ntuÞ íÞtk ‚u table ™t ftuE …ý cell …h cursor ÷tðe Data menu {tk sE Filter click fh‚tk Autofilter Add ÚtÞu÷wk òuðt {¤þu.
Standard Filter
yt option …h fh‚tk direct table {tk data filter {txu condition yt…ðt {txu standard filter dialog box òuðt {¤þu.
click
Advanced Filter
yt option ™e {ŒŒÚte table {tk filter ÚtÞu÷ data move yÚtðt copy fhe þftÞ Au. heading select fhtu, íÞthƒtŒ ‚u™e copy fhe table ™e ™e[u ºtý [th row (÷tE™) Atuze íÞtk paste fhe condition type fhtu. Advance Filter …h click fh‚tk Advance Filter dialog box open Útþu. ynª criteria range {tk cursor ht¾e condition ðt¤e ƒu ÷tE™ select fhe OK fhðwk. Filter fhu÷t Record òuðt {¤u Au.
Ëti «Út{
OpenOffice
Computer World Publication40
SubtotalData menu ™t yt command ™t W…Þtu„Úte spreadsheet {tk yt…u÷t common data ™wk sub total ‚u{s different data ËtÚtu™wk grand total ð„uhu òuðt {¤þu. ynª table sort ntuðwk sYhe Au. ‚u{s grouping ðt¤t data ntuðt sYhe Au.
xample :E
computer ™t parts Ähtð‚e company ™t salesman ™wk selling, parts «{týu fhðt ‚u{s Total y™u grand total òuðt {txu Ëti «Út{ yt…u÷ Table ™u sort by, then by, then by option ™tu W…Þtu„ fhe sort fhðwk.
íÞthƒtŒ Data menu ™t subtotal …h click fhðwk. ynª salesman «{týu table {tk™e content ™t ytÄthu group «{týu subtotal ð„uhu òuðt {¤þu.
Data PilotData menu ™t yt command ™e {ŒŒÚte table ™u group «{týu, Report manner {tk Arrange fhe þftÞ Au. Data menu {tk Data pilot command …h click fh‚tk start, Refresh, Delete option òuðt {¤þu. Start button …h click fh‚tk select source dialog box {tk current selection yt…e OK button …h click fh‚tk Data pilot ™wk layout {txu™wk dialog box open Útþu. yt…u÷ page field, column field, Row field, Data field ™t area {tk sYh «{týu right side Œþtoðu÷ Field list {tk™t field ™u select fhe drag & drop ™e {ŒŒÚte „tuXððt. OK button …h click fhðwk. yt{ pilot table view òuðt {¤þu.
Pilot table …h click fhe data menu {tk data pilot command {tk refresh …h click fh‚tk last modification «{týu table modified ÚtE þfu Au.
OpenOffice
Computer World Publication41
OpenOffice.org Presentation Open office Presentation yu Microsoft power point ™e Ë{fût™wk y™u ‚uÚte ðÄw rðþu»t‚t Ähtð‚wk, ¾qƒ s
Ënu÷tEÚte W…Þtu„{tk ÷E þftÞ ‚uðwk open office ™wk software Au.
Presentation {tk professional slide show create fhe þftÞ Au. Slide show ƒ™tððt {txu chart, drawing object, text, multimedia suðe ½ýe ƒÄe items ™tu W…Þtu„ fhe þftÞ Au.
Presentation {tk Microsoft powerpoint presentation ™u import y™u modify fhe þftÞ Au.
Presentation ™u ðÄw ytf»tof ƒ™tððt {txu slide shows {tk animation, slide transition y™u
multimedia suðe techniques W{uhe þftÞ Au.
Presentation ™e rðþu»t‚tytu y™u W…Þtu„tu :
Open office {tk yuðt ½ýtk Tools Au. su™e {ŒŒÚte vector graphics create fhe
þftÞ Au. Open office draw {tk vector graphics create fhe þftÞ Au. su Impress {tk …ý
available Au.
Open office Presentation {tk templates ytðu÷t Au su™e {ŒŒÚte professional looking ™e
slides create fhe þftÞ Au.
Open office Presentation y÷„ y÷„ view ‚u{s pages Œþtoðu Au. su™e {ŒŒÚte
presentation design fuðe ÷t„u Au ‚u{s modification yt…‚tk view fuðt ÷t„þu ‚u …ý
thumbnail form yÚtðt Handout page {tk òuðt {¤þu.
Rehearse timing ™e {ŒŒÚte presentation ™tu slide show òuðt {¤e þfu Au su offices, seminars, meetings, exhibitions ð„uhu{tk {tuxt «{tý{tk òuðt {¤u Au.
Presentations ™e slide ™u on-screen, as a handouts yÚtðt HTML document ‚hefu
publish fhe þftÞ Au.
Presentation Manually yÚtðt automatically yu{ ƒk™u he‚u Œþtoðe þftÞ Au.
Open office Presentation {tk data ™u graphically chart «{týu …ý Œþtoðe þftÞ Au. su™e
{ŒŒÚte data series ™e visual comparison òuðt {¤þu.
Presentation
Presentation þY fhðt™e he‚ (How to Start Impress) :
Application ® Programs ® OpenOffice.Org Presentation
OpenOffice
Computer World Publication42
yt…u÷ dialog box {tk presentation type, Empty presentation, From template, Open existing presentation Œþtoðu÷ Au.
«uÍLxuþ™™tk «fth (Presentation Type) :
Blank presentation su™tu W…Þtu„ ™ðt presentation ™u ƒ™tððt {txu ÚttÞ Au.
Empty Presentation :
From template select fh‚tk s presentations & presentation Background yu{ ƒu
selection list box {tk òuðt {¤þu. Presentation select fh‚tk Ready-made template list òuðt {¤þu, yu{tkÚte select fhe þftÞ Au. s{ýe ƒtsw preview òuðt {¤þu. Presentation background select fh‚tk readymade slides Background {¤þu. ynª …ý list yt…u÷ Au
su{tkÚte select fhðt™wk hnuþu.
From Template :
Open Existing Presentation :
…nu÷tÚte ƒ™tðu÷ presentation ™u open fhðt {txu open button Œþtoðþu ßÞtk fh‚tk path select fhe þftÞ Au ‚u{s presentation list òu default save nþu ‚tu list òuðt {¤þu. ‚u{tk
ÞtuøÞ Option select fÞto ƒtŒ next …h click fhðwk.
click
OpenOffice
Computer World Publication43
Blank presentation select fh‚tk yt second presentation Wizard open Útþu. Presentation Background select fhe þftÞ Au.
Create button …h click fh‚tk s Presentation screen window òuðt {¤þu.
M÷tEz rzÍtE™™e …ËkŒ„e (Select a Slide Design) :
Presentation Window rðþu Ë{sq‚e :Title bar
Menu bar
Standard bar Line & Filling Presentation
Taskpan
Vertical Scrollbar
Status barDrawing Toolbar
Horizontal Scrollbar
Menubar ™e ™e[u Line & Filling toolbar òuðt {¤þu. su{tk Line, Line style & Formatting, line width, line color, Area, Area style, filling shadow suðt tools ™tu Ë{tðuþ ÚttÞ Au.
Line & Filling :
yt Toolbar standard toolbar ™e ƒtsw{tk òuðt {¤þu. su{tk slide, slide design, sldie show suðt tools option òuðt {¤u Au.
Presentation :
OpenOffice
Computer World Publication44
Taskpane window {tk master pages, custom animation, slide transition, slides {txu™t layouts suðt option òuðt {¤u Au. yt Toolbar normal view {tk presentation screen {tk s{ýe ƒtsw (right side) òuðt {¤þu.
Taskpane :
Master pages {tk used in this presentation, recently used, available for use suðt option òuðt {¤u Au.
Layouts {tk y÷„ y÷„ «fth™e slides {txu™t layouts Œþtoðu÷ Au. su layouts select fhðt{tk ytðu ‚u layout «{ýu slides ƒ™þu. y÷„ y÷„ slides {txu y÷„ y÷„ layout select fhe þftÞ Au.
Slides ™t tools {tk Thumbnail sux÷tu current slides ™tu view òuðt {¤þu.
Impress ™t window {tk ™e[u ytðu÷ (Last toolbar Úte yuf yt„¤) toolbar drawing toolbar Au su{tk drawing {txu™t tool suðt line, lines End with Arrow (Arrow line), rectangle, ellipse, connector, Basic shape, callouts.... etc suðt ½ýtk ƒÄt tools òuðt {¤u Au.
Drawing Toolbar :
Slide ™t y÷„-y÷„ View (Slide View) :
Normal view {tk slide Ët{tLÞ he‚u 33% sux÷e òuðt {¤u Au. ËtÚtu Taskspane slides Thumbnail view òuðt {¤u Au.
Normal
Outline view {tk no. of slides listing «{týu ytðu Au. ËtÚtu slides {tk thumbnail view …ý
òuðt {¤þu. Outline view ™e {ŒŒÚte slides ™u Ënu÷tEÚte move fhe þftÞ Au.
Outline View :
Slides rðþu™e ™tUÄ ÷¾ðt {txu yt view {tk special notes (™tUÄ) ™tu rð¼t„ Œþtoðu÷ Au. ßÞtk
mouse ðzu click fh‚tk notes ÷¾e þftÞ Au.
Au. ƒtfe ƒÄt view {tk Taskpan enable òuðt {¤þu.
Võ‚ notes view {tk Taskpane disable òuðt {¤u
Notes :
yt view {tk header, footer, date/time, page no., Area ð„uhu òuðt {¤u Au. Handout {tk
slide ™wk outlook (Œu¾tð) òuðt {¤u Au.
Handout :
Slide sorter view ™t {ŒŒÚte slides {tk yt…u÷ animation, Rehears timing ð„uhu òuðt {¤u Au
y™u slide sorter view ™e {ŒŒÚte Ëh¤‚tÚte yt…e þftÞ Au.
Slide Sorter :
OpenOffice
Computer World Publication45
M÷tEz ƒ™tððt™e he‚ (How to Create Slide) :
1 Blank Presentation select fÞto ƒtŒ layouts {tk™tk option {tkÚte ftuE yuf layout ™u select fh‚tk slide layout change ÚtE sþu.
2 Slide ƒ™tð‚tk …nu÷tk fÞt «fth™e slide ƒ™tððe Au ‚u ™¬e fhe layout list {tkÚte ‚u «{týu slide layout select fhðwk. (Œt.‚. Blank, title only, Text & Title, Title & 2 Text, Title & Object layout …h mouse cursor ht¾‚tk ‚u layout ™e ™e[u ‚u layout rðþu tip òuðt {¤þu.)
3 Layout {tkÚte select fhu÷ slide {tk slide ™e instruction «{týu click fhe Title ð„uhu yt…ðwk.
(Œt.‚. Title, Clipart text ðt¤e slide layout …h click fh‚tk slide layout ‚u {wsƒ {¤þu.)
4 Click to add title W…h click fh‚tk slide ™u title yt…e þftÞ Au. (Œt.‚. Title …h Âõ÷f fhe
Type fhtu Computer World) yt…u÷ Title ™u formatting yt…e attractive ƒ™tðe þftÞ.
Font, Font size, color, shadow ð„uhu yt…e ytf»tof ƒ™tðe þftÞ.
5 Click to add outline W…h click fhe slide {tk su «{týu slide ƒ™tððe Au ‚u «{týu content yt…ðe. (Œt.‚. List of book íÞthƒtŒ Tab yt…e second outline {tk List type fhðwk.)
6 ynª, sYhe Object …h click fhe object select fhðwk. yt…u÷ Œhuf Text ‚u{s object ™e format ƒŒ÷e þftÞ Au. Slide background …ý change fhe þftÞ Au.ƒ™tðu÷ Slide …h Mouse ™e right click fh‚tk slide option òuðt {¤þu. su{tk Set Background Picture for slide option …h click fh‚tk picture list òuðt {¤þu. su{tkÚte ftuE yuf picture select fh‚tk ‚u current presentation ™e ‚{t{ side {txu background ƒ™e sþu.
OpenOffice
Computer World Publication46
NewFile menu ™t yt Command ™e {ŒŒÚte Presentation {tk ™ðwk Presentation ƒ™tðe þftÞ Au, ‚u{s Open Office.Org ™e ftuE…ý Application {tk ™ðe File Create fhe þftÞ Au.
OpenFile menu ™t yt command ™tu W…Þtu„ ƒ™tðu÷ presentation ™u open fhðt {txu ÚttÞ Au. ƒ™tðu÷t presentation {tk modification fhðt ntuÞ íÞthu open command ™e {ŒŒÚte ƒ™tðu÷ presentation open fhðwk.
WizardsFile menu ™t Wizard {tk yt…u÷ letter, fax, Agenda, Presentation, Web page, Document converter, Address data source... etc suðt option ™u select fh‚tk su ‚u selected option ™e Ready made format {¤u Au. Ready-made format ™t W…Þtu„Úte formatting {txu™tu Ë{Þ ƒ„z‚tu ™Úte y™u Íz…Úte ‚u{s Ënu÷tEÚte ftÞo ÚtE þfu Au.
CloseFile menu ™t yt command ™e {ŒŒÚte presentation close ÚttÞ Au. Presentation application close Út‚e ™Úte.
SaveFile menu ™t yt Command ™e {ŒŒÚte Current File ™u Save fhe þftÞ Au. ßÞthu File ™u «Út{ 𾂠Save fh‚t ntuEyu íÞthu File ™wk ™t{ yt…ðwk sYhe Au. Impress ™e Œhuf Presentation File ™u .ODP Extension ÷t„u Au.
Save All File menu ™t yt Command ™tu W…Þtu„ ƒu fu ‚uÚte ðÄw File {tk yuf ËtÚtu Work fÞwO ntuÞ y™u yt Modified fhu÷ Files ™u Save fhðe ntuÞ íÞthu ÚttÞ Au. yu rƒ÷fw÷ Save As suðwk s ftÞo fhu Au.
Save AsFile menu ™t yt Command ™e {ŒŒÚte Save fhu÷e File ™e Copy (Duplicate File) create fheþftÞ Au.
OpenOffice
Computer World Publication47
ReloadFile menu ™t yt command ™e {ŒŒÚte last save fhu÷ VtE÷ VheÚte load Útþu. Œt.‚. yuf presentation {tk Úttuzt ËwÄtht ðÄtht fhe ‚u™u save fhðt{tk ytðu Au. íÞthƒtŒ VheÚte Úttuzt changes fhðt{tk ytðu Au. …hk‚w yt changes y™wfq¤ ™Úte. ‚tu file Reload fh‚tk last save fhu÷ file VheÚte load Útþu.
ExportPresentation (Impress ™e File) ™u export fhðt {txu yt command ™tu W…Þtu„ ÚttÞ Au. su he‚u writer y™u calc {tk export option ™tu W…Þtu„ ÚttÞ Au. ‚u s he‚u Export option ™tu presentation {tk …ý W…Þtu„ fhe þftÞ Au.
Preview in BrowserPresentation ™e file ™u HTML format {tk Web browser {tk open fhðt {txu yt command ™tu W…Þtu„ ÚttÞ Au.
PrintFile menu ™t yt command ™e {ŒŒÚte slides ™wk printout {u¤ðe þftÞ Au. File Menu {tk Print Option Select fhðtÚte Print ™wk Dialog Box Open Útþu. Printer Name {tk Default Print (Install fhu÷t Printer™wk ™t{) òuðt {¤þu. ‚u™wk Location Type ƒÄw òuðt {¤þu. Print Range sYh «{týu Set fhðe. Print ™e fux÷e ftu…e (Copies) òuEyu Au ‚u ™¬e fhe Scrollbox {tk yt…ðe. Print dialog box {tk properties …h click fh‚tk page orientation ‚u{s page order set fhe þftÞ Au.
yt…u÷ print dialog box {tk option button …h click fh‚tk printer option select fhe þftÞ Au. Œt.‚. Contents, Quality, page option, Print ð„uhu. íÞthƒtŒ OK button …h click fhðwk.
ytðu÷ {wÏÞ dialog box {tk OK …h click fhðtÚte printout òuðt {¤þu.
OpenOffice
Computer World Publication48
UndoEdit menu ™t yt Command ™e {ŒŒÚte AuÕ÷u su ftÞo fÞwO ntuÞ ‚u ftÞo™e yËh Cancel fhe þftÞ Au.
RedoEdit menu ™t yt Command ™e {ŒŒÚte Undo ðzu su ftÞo fhu÷ ntuÞ ‚u™e yËh{tkÚte {wõ‚ ÚtðtÞ Au. yux÷u fu Redo Command yu Undo Command Úte rðÁØ ftÞo fhu Au.
Cut, Copy, Paste
Edit menu ™t Cut fhu÷ ¼t„ Clipboard {tk Store ÚtE òÞ Au suÚte Presentation {tkÚte Cut fhu÷ ¼t„™u ƒesu MÚtt™u Paste fhe þftÞ Au. Ët{tLÞ he‚u cut f{tLz™tu W…Þtu„ Text ™u ƒeS søÞtyu ÷E sðe ntuÞ yux÷u fu Move fhðe ntuÞ íÞthu fhðtu.
yt Command ™e {ŒŒÚte Select fhu÷ Text fu Graphics ™u Cut fhe þftÞ Au. yt
Cut Ctrl + X
Edit menu ™t Copy fhe þftÞ Au.
yt Command ™e {ŒŒÚte Select fhu÷ ftuE [tu¬Ë Text ™u Window Clipboard {tk
Copy Ctrl + C
Edit menu ™t Document {tk Store fhe þftÞ Au.
yt Command ™e {ŒŒÚte y„tW Copy fu Cut Command Úte Select fhu÷ Text ™u
Paste Ctrl + V
Select AllEdit menu {tk ™t select all command ™e {ŒŒÚte slide {tk™e Œhuf content (Whole slide) yuf ËtÚtu select fhe þftÞ Au.
DuplicateEdit menu ™t yt command ™e {ŒŒÚte selected item yÚtðt content ™e duplicate (no. of copies) sux÷e òuEyu ‚ux÷e placement, Enlargement, colors ËtÚtu {¤þu. su Xerox suðwk ft{ fhu Au. Ëti «Út{ su item or content ™e duplicate ƒ™tððe Au ‚u Item select fhtu.
OpenOffice
Computer World Publication49
Edit menu {tk duplicate command …h click fhtu. Duplicate dialog box open ÚtÞu÷ òuðt {¤þu.
Duplicate ™t dialog box {tk no.of copies, Placement, Enlargement, Colors ð„uhu setting fhe OK button …h click fhðwk. yt{ no. of copies {¤e sþu.
Delete slidePresentation {tk yuf fh‚tk ðÄw slides yt…u÷e ntuÞ y™u ftuE slide ™u delete fhðe Au ‚tu su slide ™u delete fhðe Au ‚u select fhe edit menu {tk delete slide option …h click fh‚tk ‚u delete ÚtE sþu. Slide ™u select fhe Delete key press fh‚tk …ý slide delete fhe þftÞ Au.
Slide ViewsSlide ™t y÷„ y÷„ views, view menu îtht òuE þftÞ Au. ‚u{s Task pane, slide pane, Statusbar, Toolbars, Ruler, Grid ð„uhu Activate-diactivate fhe þftÞ Au.
Header & FooterView menu ™t Slide tab page {tk Header ‚u{s Footer ™t area, slide no., Date & time ð„uhu setting òuðt {¤þu. yt…u÷ setting modify …ý fhe þftÞ Au.
OpenOffice
Computer World Publication50
Notes & Handouts tab page {tk header-footer area, date & time, page no. ð„uhu setting òuE þftÞ Au. ‚u{s ‚u{tk VuhVth …ý fhe þftÞ Au.
View menu {tk ytðu÷ Header-footer Ët{tLÞ he‚u header-footer (òuðt) view {txu W…Þtu„e Au. Insert menu {tk™t fields page number, Date & Time ð„uhu™u slides y™u note & handouts {tk Header-footer Area {tk insert fhe þftÞ Au. View menu {tk ytðu÷ Header-Footer Area {tk Editing …ý fhe þftÞ Au.
Insert SlideInsert menu ™t yt command ™e {ŒŒÚte presentation {tk file {tk ™ðe slide W{uhe þftÞ Au. Slide add fÞto ƒtŒ layout …ý change fhe þftÞ Au. By default last layout «{týu slide insert Útþu.
Duplicate SlideInsert menu ™t yt command ™e {ŒŒÚte file (presentation) {tk ƒ™tðu÷ slide ™e duplicate slide add (create) Útþu. ynª slide select fhe™u …ý duplicate command yt…e þftÞ. By default current slide ™e duplicate slide create ÚttÞ Au.
Expand SlideInsert menu ™t yt command ™e {ŒŒÚte main (First) slide (master slide) {tk™e content ™u ytÄthu slide expand Útþu. Œt.‚. Main Slide {tk 5 content (text) yt…u÷ Au. yt command …h click
OpenOffice
Computer World Publication51
fh‚tk Œhuf Content (text) ™e yuf slid e create Útþu. Ëti «Út{ …nu÷e slide (Master Slide) select fhðe. Selected Slide {tk list yt…u÷ nþu. ‚tu No. of list ™t ytÄthu slide Expand Útþu.
Œt.‚. «Út{ slide {tk list of book yt…u÷ Au. yt list {tk 5(Five) Book ™wk List Au ‚tu 5 Slide Create Útþu.
Insert Menu {tk Expand Slide …h click fh‚tk 5 Slide create Útþu. Cursor «Út{ Slide {tk ntuðwk sYhe Au. Current Slide «Út{ Slide ntuðe sYhe Au.
Summary SlideInsert menu ™t yt command ™e {ŒŒÚte no.of slides ™u æÞt™{tk ht¾e yuf summary slide create Útþu. ftuE…ý slides …h cursor selection ntuÞ y™u Insert menu {tk summary slide command …h Âõ÷f fh‚tk last {tk summary slide create ÚtE sþu. sux÷eðth summary slide …h Âõ÷f fhðt{tk ytðþu ‚ux÷eðth summary slide create Útþu {txu summary slide last {tk presentation ™e ƒÄe s slide create ÚtE „Þt ƒtŒ create fhðt{tk ytðu Au.
Page NumberInsert menu ™t Page number command …h click fh‚tk slide ™t Header & Footer {tk page no. insert fhe þftÞ Au. Ëti «Út{ Insert menu {tk page number command …h click fh‚tk Header and footer ™wk dialog box open Útþu. ynª, Slide y™u Notes and Handouts page tab òuðt {¤þu.
OpenOffice
Computer World Publication52
Notes and Handouts ™t page tab …h click fh‚tk last {tk page number ™wk check box òuðt {¤þu. Page number check box …h click fh‚tk page number area {tk page number yt…{u¤u insert Útþu. íÞthƒtŒ Apply to all …h click fh‚tk Œhuf slides {tk apply ÚtE sþu. Slides ™t Handouts view {tk òu‚tk slide ™e s{ýe ƒtsw ™e[u™t ¼t„{tk page number òuðt {¤þu.
Date & TimeInsert menu ™t yt command ™e {ŒŒÚte slide ™t Header & footer area {tk Date & Time insert fhe þftÞ Au. ‚u{s Edit fhe þftÞ Au.
Animated ImageInsert menu ™t yt command ™e {ŒŒÚte slide {tk Animated image Insert fhe þftÞ Au. Insert menu {tk Animated image command …h click fh‚tk Animation window (dialog box) open Útþu. Image option {tk Apply object …h click fh‚tk object ™tu view òuðt {¤þu. No. of object, Group object insert fhe Animation Image create fhe þftÞ Au.
PicturePicture Insert fhðt {txu Insert menu ™t Picture command ™tu W…Þtu„ ÚttÞ Au. Picture from file ‚u{s selected source {tkÚte insert fhe þftÞ Au.
Movie & SoundInsert menu ™t yt command …h click fh‚tk movie y™u sound slide {tk insert fhe þftÞ Au. (Movie y™u sound ™u slide {tk insert fhe Animation yt…e þftÞ Au.)
Spreadsheet Insert menu ™t yt command ™e {ŒŒÚte spread sheet ™e file ™u slide {tk insert fhe þftÞ Au.
ChartInsert menu ™t yt command ™e {ŒŒÚte chart ™u slide {tk insert fhe þftÞ Au.
CharacterFormat menu ™t yt command ™e {ŒŒÚte character ™e size Font style, Font effect, position ð„uhu change fhe þftÞ Au.
OpenOffice
Computer World Publication53
Bullets & Numbering Index ƒ™tððt{tk bullets and Numbering ™tu W…Þtu„ fhe þftÞ Au.
PageFormat menu ™t yt command ™e {ŒŒÚte page setup (Page format, width, Height, Orientation, Margin)fhe þftÞ Au.
Position & SizeFormat menu ™t yt command ™e {ŒŒÚte inserted graphics, object fu picture ™e position y™u size ™¬e fhe þftÞ Au.
LineFormat menu ™t yt command ™e {ŒŒÚte draw fhu÷ line ™e format change fhe þftÞ Au Object ™e line, table line Œhuf line ™u formatting yt…e þftÞ Au.
AreaFormat menu ™t yt command ™e {ŒŒÚte selected drawing area {tk color fill fhe þftÞ Au. Shadow, Transparency, gradients, hatching, Bitmaps ð„uhu set fhe Fill fhe þftÞ Au.
TextFormat menu ™t Text command ™e {ŒŒÚte yt…u÷ text ™e format text box ™u y™wËkÄt™{tk set fhe þftÞ Au. Œt.‚. Fit width to text, Fit height, Border ‚u{s left, right, top, bottom spacing set fhe þftÞ Au. Text Animation option {tk text effect Blink, scroll through, scroll back and Forth, scroll in ð„uhu set fhe þftÞ Au.
Slide DesignFormat menu ™t yt command …h click fh‚tk slide {txu design set fhe þftÞ Au. Background page exchange fhe þftÞ Au. Unused Background delete fhe þftÞ Au. yt…u÷ slide design list {tkÚte slide design select fhe þftÞ Au yÚtðt load option ™e {ŒŒÚte slide design select fhe yt…e þftÞ Au.
OpenOffice
Computer World Publication54
Ëti «Út{ format menu {tk slide design command …h click fhtu. Load Button …h click fh‚tk load slide design dialog box open Útþu.
Category select fh‚tk ‚u category ™t templates ™wk list Template list box {tk òuðt {¤þu. ‚u{tkÚte ftuE yuf Templates select fhe OK button …h click fhðwk. Selected Template «{týu slide design load Útþu. OK button …h click fh‚tk slide ™e design selected template «{týu òuðt {¤þu.
Slide LayoutFormat menu ™t Slide layout command slides ™t layout change fhðt {txu W…Þtu„e ÚttÞ Au.
GalleryTools menu ™t yt command …h click fh‚tk presentation {tk ™ðtu gallery window open Útþu. yt option îtht presentation {tk theme, Backgrounds, Bullets, Homepage, My theme, Ruler, sounds ð„uhu insert fhe þftÞ Au.
Backgrounds click Gallery Window Background View selected background ™wk ™t{ Title {tk òuðt {¤þu.
Bullets …h click fh‚tk s{ýeƒtsw bullet list òuðt {¤þu.
…h fh‚tk s{ýeƒtsw {tk ™tk y™u
OpenOffice
Computer World Publication55
Homepage click Buttons list
Ruler …h click fh‚tk rulers ™wk List òuðt {¤þu.
Sound …h click fh‚tk sound ™e design ™wk list òuðt {¤þu.
…h fh‚tk ™wk òuðt {¤þu.
Slide ShowPresentation ™e File {tk ƒ™tðu÷ yufÚte ðÄw slide ™u Arrange fhe timing yt…e slide show ™t command …h click fh‚tk yt¾e screen …h slide ™tu view òuðt {¤þu. No. of Slides Create fÞto ƒtŒ F5 yÚtðt Slide Show command …h Click fhðwk. Full Screen {tk Slide ™tu view òuðt {¤þu. Mouse ™e {ŒŒÚte Slide …h click fh‚tk next slide òuðt {¤þu. yÚtðt keyboard {tk Enter key press fh‚tk Next Slide òuðt {¤þu.
Slide Show SettingSlide Show menu ™t yt command ™e {ŒŒÚte no.of slide ™tu show fE slide Úte þY fhðtu Au, fux÷e slide presentation {tk Œþtoððt™e ‚u{s slide show type (Œt.‚. window, default su yt¾e screen {tk Œu¾tÞ Au ‚u{s Auto setting) ð„uhu setting {txu ÚttÞ Au.
Options - change Slides manually, mouse pointer visible, presentation always on top etc.. suðt setting îtht slide show presentable ƒ™tðe þftÞ Au.
Options {tk yt…u÷ checkbox {tk Âõ÷f fhðtÚte option select ÚttÞ Au y™u option apply ÚttÞ Au. VheÚte select fh‚tk ‚u disable ÚttÞ Au.
Rehearse Timingsyt command ™e {ŒŒÚte ƒ™tðu÷ Œhuf slide ™tu time show {txu set fhe þftÞ Au. Ëti «Út{ slide ƒ™tððt™e Au ‚u ƒ™tðe Œhuf{tk formatting, object, graphics sYrhÞt‚ {wsƒ insert fhe last demo …nu÷tk Rehearse time yt…ðt™tu hnuþu. …nu÷e slide select fhe ‚u{tk yt…u÷ Animation ™u ytÄthu fux÷e second slide ™u presentation {tk show fhðe Au ‚u ™¬e fhtu. Slide show menu {tk Rehearse time option …h click fhtu. yt¾e screen {tk slide òuðt {¤þu y™u ztƒe ƒtsw ™e[u ‚hV second ™wk counting [t÷w Útþu.
ynª, sYh «{týu Second ht¾e mouse Úte click fhðwk. yÚtðt Enter key press fhðe. Next slide {txu …ý yt s he‚u second set fhðe. yt{, Œhuf slide {tk Time set fhe þftÞ Au. Time set fÞto ƒtŒ slide show òu‚tk manually, mouse Úte fu keyboard Úte key press fhe™u next slide …h sðt™e sYh hnu‚e ™Úte. Rehearse time setting «{týu yt…u÷ second «{týu Automatic next slide òuðt {¤þu.
OpenOffice
Computer World Publication56
InteractionftuE…ý text, object, picture ™u select fh‚tk yt command Active Útþu. Selected item ™u mouse click îtht yt…u÷ Action list {tkÚte Action select fhe slide show ytf»tof ƒ™tðe þftÞ Au.
Custom AnimationSlide Show menu ™t yt command ™e {ŒŒÚte slide {tk™t Œhuf object, picture, graph, text ™u Animation yt…e þftÞ Au. Custom Animation yt…ðt {txu item select fhe slide show
menu ™t custom animation …h click fh‚tk s{ýe ƒtsw ytðu÷ taskpan {tk custom animation Active sýtþu. Custom
animation {tk modify effect option {tk Add button …h click
fhðwk.
Add button …h click fh‚tk custom animation dialog box open
Útþu. ynª custom animation dialog box {tk Entrance,
Emphasis, Exit, Motion path option òuðt {¤þu. Entrance {tk yt…u÷ BASIC {tkÚte option select fhe speed select fhðe (Fast,
Slow) Emphasis {tk BASIC option {tk choice «{týu selection
yt…ðwk. (Œt.‚. spin) ‚tu yt…u÷ Animation ƒtŒ object spin Út‚wk òuðt {¤þu. Exit - option {tk object Animation ™t exit {tk fE effect yt…ðe Au ‚u™wk list òuðt {¤þu.
Motion Path : Motion Path {tk object fuðt motion ËtÚtu move ÚttÞ ‚u option Œþtoðu÷ Au. Œhuf option …h click fh‚tk ‚u™tu preview slide {tk òuðt {¤þu. íÞthƒtŒ OK button …h click fhðwk yt…u÷ Animation {tk VuhVth fhðt {txu change button …h click fhðwk. Change Button …h click fh‚tk VheÚte Custom Animation dialog box open Útþu. Remove option …h click fh‚tk object ™u yt…u÷ Animation Œqh ÚtE sþu.
Start option {tk By default on click òuðt {¤þu yux÷u fu slide show Œhr{Þt™ mouse click yÚtðt Enter fh‚tk Animation apply ÚttÞ. ƒeò with previous, After previous option yt„¤™t Animation ËtÚtu yÚtðt yt„¤™t Animation ƒtŒ opton òuðt {¤þu. Speed : Animation speed fux÷e ht¾ðe Au slow, medium, fast, very fast option yt…u÷ Au ‚u {wsƒ speed set ÚtE þfþu.
OpenOffice
Computer World Publication57
Change order : Slide {tk yuf fh‚tk ðÄthu Animation ytÃÞtk ƒtŒ ‚u™t order change fhðt {txu yt option ™tu W…Þtu„ ÚttÞ Au. Play & Slide show : Play y™u Slide Show yu{ ƒu button òuðt {¤þu. Play …h click fh‚tk Slide {tk s Animation òuðt {¤þu. Slide show yt…‚tk Ë{„ú Screen …h Slide show òuðt {¤þu. Automatic Preview : yt option default active òuðt {¤þu. su™t fthýu Animation add Œhr{Þt™ s preview òuðt {¤u Au. yt{ Custom Animation ™e {ŒŒÚte presentation Attractive ƒ™e sþu.
Slide Transitionyt command ™e {ŒŒÚte presentation {tk ƒ™tðu÷ yuf fh‚tk ðÄw slide ™tu profession presentation ‚hefu, projector ™e {ŒŒÚte Meeting {tk presentation ‚hefu ßÞthu slide show fhðt{tk ytðu Au íÞthu yuf slide …Ae ƒeS slide fuðe he‚u show Útðe òuEyu ‚u™e speed ‚u{tk sound setting ð„uhu slide transition ™e {ŒŒÚte yt…e þftÞ Au. Slide show menu {tk slide transition command …h click fhðwk. yÚtðt Taskpane docking window {tk slide transition …h click fhðwk. Apply to selected slides {tk list Œþtoðu Au. su select fh‚tk selected slide ™tu view òuðt {¤þu. (Œt.‚. Wipe left yux÷u slide ßÞthu show Útþu íÞthu Right to left wipe òuðt {¤þu.)
Modify Transition {tk speed ‚u{s sound yt…u÷t Au su choice «{týu modify fhe þftÞ Au yÚtðt select fhe þftÞ Au.
Modify Transition
yt option {tk on mouse click slide transition yÚtðt Automatic after selected second choice fhe slide show set fhe þftÞ Au.
Advance Slide
yt Option …h click fh‚tk yt…u÷ slide transition settingŒhuf slide {tk Apply ÚtE sþu.
Apply to all slides
Hide Slideyt option ™e {ŒŒÚte presentation {tk ƒ™tðu÷ slides {tkÚte ftuE slide ™u slide show Œhr{Þt™ òuðe ™ ntuÞ ‚tu hide fhe þftÞ Au. su Slide ™u Hide fhðe Au ‚u select fhtu. íÞthƒtŒ slide show menu ™t Hide Slide Command …h click fhðwk. yt{, Slide Show Œhr{Þt™ ‚u Slide òuðt {¤þu ™®n.
OpenOffice
Computer World Publication58
ynª, New Button …h click fh‚tk slide show ™wk user …tu‚t™e he‚u ™t{ yt…e þfu Au. Existing slides ™t list {tkÚte slide ™u select fh‚tk >> (add to selected slide) button active Útþu su™e …h click fh‚tk selected slides ™t list {tk slide add ÚtE sþu. yt{ user …tu‚t™e he‚u slides ™u ÷E™u order «{týu Arrange fhe OK button …h click fh‚tk custom slide show ™t dialog box {tk return Útþu.
Custom slide show {txu slides ™u select fh‚tk Edit, Delete, Copy, Start suðt option active ÚtE sþu su™tu W…Þtu„ create fhu÷t list {tk modification y™u delete fhðt {txu ÚttÞ Au. Custom slide show ™tu W…Þtu„ fhðt {txu yt…u÷ use custom slide show check box ™u select fhðwk. íÞthƒtŒ close button …h click fhðwk yt{, custom slide show create fhe þftÞ Au.
Custom Slide Showyt command ™e {ŒŒÚte user …tu‚t™e he‚u su su slide ™u su order {tk show fhtððt {tk„‚t ntuÞ ‚u «{týu set fhe þftÞ Au. Slide show menu {tk custom slide show command …h click fh‚tk custom slide show dialog box òuðt {¤þu.
OpenOffice
Computer World Publication59