new microsoft office .document.doc
Post on 02-Jun-2018
224 Views
Preview:
TRANSCRIPT
-
8/11/2019 New Microsoft Office .Document.doc
1/105
SR. No Particular
Qty Rate Amount
1 N72 2 12000 24000
2 N90 2 45000 900003 Nokia 6233 3 7000 210004 N92 4 120000 480000
1km =1.6miles
SR. No City Miles km1 Lucko! 60 962 "el#i 122 195.2
3 $%&a 100 1604 $lla#a'a( 102 163.25 Rac#i 745 1192
SR. No City Miles )m1 Lucko! 60 962 "el#i 1223 $%&a 1004 $lla#a'a( 1025 Rac#i 745
SR. No Particular
Qty Rate Amount
1 N72 2 12000 240002 N90 2 45000 900003 Nokia 6233 3 7000 210004 N92 4 120000 480000
Computers
Today, did you stop for a red signal
or bought something at a store? Did
-
8/11/2019 New Microsoft Office .Document.doc
2/105
you watch a movie or a television
program?
Did you drive a car or ride a bus? All
these activities and thousands more,
involve computers in some way.
Computers of every size affect our
life. Super computers forecast weather
and launch satellite. mbedded
computer
!rocessor chips ma"e smart device suchas a car that warns you of problem or
a microwave oven that warms your
#rea"fast.
Computer put ban"ing at your fingertip
any time and any ware. $ould you
choose a ban" that didn%t haveautomated?
Teller machine &atm'? (n addition, you
longer need to carry cash or che)ues
all the time* you can buy many things
from groceries to gasoline to
hamburgers+
#y using a debit card.
(nformation from all over the word is
available to anyone with a computer, a
modern, a telephone line, and an
internet account student from
To graduate college are
-
8/11/2019 New Microsoft Office .Document.doc
3/105
sing computer to gather data. -etwor"
and telecommunications give loo"ing
up a new meaning.
Computers
Today, did you stop for a red signal
or bought something at a store? Did
you watch a movie or a television
program?
Did you drive a car or ride a bus? all
these activities and thousands more,
involve computers in some way .
computers of every size affect our
life . super computers forecast
weather and launch satellite. embeddedcomputer
processor chips ma"e smart device such
as a car that warns you of problem
or a microwave oven that warms your
brea"fast.
computer put ban"ing at your fingertip
any time and any ware. would you
choose a ban" that didn/t have
automatted
teller machine &atm'? (n addition ,
you longer need to carry cash or
che)ues all the time, you can buy many
-
8/11/2019 New Microsoft Office .Document.doc
4/105
things from groceries to gasoline to
hamburgers+
by using a debit card.
information from all over the word is
available to any one with a computer,
a modern, a telephone line, and an
internet account student from
to graduate college are
using computer to gather data. networ"and telecommunications give loo"ing
up a new meaning.
SR. No City Miles Km1 Lucknow 60 962 Delhi 122 195.23 Agra 100 1604 Allahabad 102 163.25 Rachi 745 1192
-
8/11/2019 New Microsoft Office .Document.doc
5/105
PR!"#$
INFORMATION TECHNOLOGYTRAINING
MADE BY VIVEK SINGH
REG NO CRO0!"#00
BATCH NO.$ %t&'System 0(
INDE)
-
8/11/2019 New Microsoft Office .Document.doc
6/105
1- MS-WORD
a. Macro
b. Mail merge
2- MS-EXE!
a. ell Re"erencing
b. #unction$ %$age$
&- 'A!!(
a. )ntro*uction
b. #eature$c. #unction$
+- )N'ERNE'
a. )ntro*uction
b. #unction$
PRE#AE
Com*+te,s -,e t&e im*o,t-t *-,t o/ t&e li/e
to-y. Vi,t+-lly i e1e,y 2-l3 o/ li/e -
-
8/11/2019 New Microsoft Office .Document.doc
7/105
-
8/11/2019 New Microsoft Office .Document.doc
8/105
MS- WORD
)MPOR'AN' #EA'%RES O# MS-WORD
%&'(ord no) onl* &u++or)& word +roce&&ing ,ea)ure& bu) al&o D$P ,ea)ure&.-oe o, )he i+or)an) ,ea)ure& o, %&'(ord are li&)ed below/
i. &ing word *ou can crea)e )he docuen) and edi) )he la)er a& and whenreuired b* adding ore )e) odi,*ing )he ei&)ing )e)dele)ingoing &oe +ar) o, i).
ii. #hanging )he &ie o, )he argin& can re,ora) co+le)e docuen) or +ar)o, )e).
iii. on) &ie and )*+e o, ,on)& can al&o be changed. Page nuber& and8eader and oo)er can be included.
i. -+elling can be checked and correc)ion can be ade au)oa)icall* in )heen)ire docuen). (ord coun) and o)her &)a)i&)ic& can be genera)ed.
. $e) can be ,ora))ed in colunar &)*le a& we &ee in )he new&+a+er. $e)boe& can be ade.
i. $able& can be ade and included in )he )e).
ii. (ord al&o allow& )he u&er )o i )he gra+hical +ic)ure& wi)h )he )e).ra+hical +ic)ure& can ei)her be crea)ed in word i)&el, or can be i+or)ed,ro ou)&ide like ,ro #li+ Ar) aller*.
iii. (ord al&o +roide& )he ail'erge ,acili)*.
i. (ord al&o ha& )he ,acili)* o, acro&. %acro& can be ei)her a))ached )o
&oe ,unc)ion&+ecial ke*& or )o a )ool bar or )o a enu.
. :) al&o +roide& online hel+ o, an* o+)ion.
a. MARO
A macro is a shortcut to a task you do repeatedly. Think about the Centre align operation.
You first highlight the word you want centred, then click the centre icon in the toolbar. This is
a macro. It's the short way of performing the centre task.
-
8/11/2019 New Microsoft Office .Document.doc
9/105
But you don't hae to do it that way. There is a longer way. You can centre your te!t by
clicking on Formatfrom the menu bar. "hen the menu drops down, click Paragraph. You'll
get a dialogue bo! popping up. Click the down arrow in theAlignmentbo!, and then click
on centre. Click OKon the dialogue bo! and your te!t is centred. That's the long way round.
Clicking the centre icon on the toolbar is much easier # it's a ery useful $acro built in to$icrosoft "ord.
A Macro i$ a ,ay to create a $ortcut "or a ta$ tat you *o a lot.
REORD A MARO
%pen $icrosoft "ord by double#clicking your program icon or click &tart,& then &All
(rograms& and click &$icrosoft "ord& on the menu.
%pen a blank page by clicking the &Blank (age& icon on the &tandard Toolbar& at
the top of the page.
Click &Tools& on the $enu bar. Choose &$acro& and then &)ecord *ew $acro.& The
&)ecord $acro& bo! opens
Type a name into the &*ame& bo!. Call it something you will remember later
Choose &Toolbars& or &+eyboard& to hae the macro assigned to a toolbar or to the
keyboard as a shortcut
(ick the location where you want to use the macro. You can use &All ocuments& or
your current document only.
Click &%+.& The &$acro& icon appears at the top of the page
Type your information into the macro page. You can choose fonts, set up tables or
anything you like. "rite eerything you need to complete the document.
Click &Tools& on the menu bar. Choose &$acro& and then &top )ecording.& The
macro stops. %r you can click the &top )ecording& button on the &$acro& icon. It
looks like a small s-uare
-
8/11/2019 New Microsoft Office .Document.doc
10/105
b.MA)! MER/E
1* +,e a 'lak e! (ocumet
2* Click tool meu
3* Select lette& a( maili% me&%e
4* Select mail me&%e !i-a&(
5* Click o Sta&ti% (ocumet o 'ottom &i%#t si(e o/ t#e sc&ee
6* Click o Select &eci,iet o,tio o t#e 'ottom si(e o/ t#e sc&ee
7* Select c&eate o,tio
8* Select customi-e o,tio
9* Remoe all t#ose el( !#ic# a&e ot &eui&e(
10*ie t#e &eleat i/o&matio i t#e a,,&o,&iate 'oes /o& all t#e ,e&so'y clicki% o t#e Ne! et&y 'utto &es,ectiely a( ally ,&ess close
'utto
-
8/11/2019 New Microsoft Office .Document.doc
11/105
11*Sae t#e a'oe %ie (ata 'y ay ame a( ,&ess ok 'utto
12*y,e t#e matte& t#at you !at to se( to all t#e ,e&so
13*lace t#e ise&tio ,oit at t#e ,ositio !#e&e you !at e&y &st el(
14*Click o ise&t me&%e tool Sit# o,tio /&om t#e le/t si(e o mail me&%e
tool 'a&
a:*Select t#e a,,&o,&iate el( /&om t#e aaila'le list
';*&ess t#e ise&t 'utto click close 'utto
c:*C#a%e t#e ,ositio a( &e,eat last t#&ee ste,s
15*Select !&ite you& lette& o,tio
16*Select ,&eie! i/ you& lette&
17*Select com,lete t#e me&%e
18*Select e(it i(ii(ual lette&
19*Select ok 'utto
20*$s a &esult t#e matte& !ill 'e aaila'le /o& all t#e &eco&( o se,a&ate ,a%es
SE%R)'( #EA'%RE )N MS0WORD
-
8/11/2019 New Microsoft Office .Document.doc
12/105
-ecuri)* ,ea)ure aailable in %-;(RD allow )o u&e a +a&&word )o o+en or
odi,* a
-
8/11/2019 New Microsoft Office .Document.doc
13/105
4-olumn$6 'e$e are 8ertical collection o" cell$.
5-ell6 )t i$ inter$ection o" ro,$ an* column$.
6-#ormula 9ar6 )t i$ a bar tat *i$lay$ an* e*it$ te
content$ o" te cell.
7-Name 9o46 )t *i$lay$ te a**re$$ o" eac cell.
8-Seet 'ab$6 'e$e are u$e* to i*enti"y *i:erent $eet$.
9-Acti8ity cell6 )t i$ a cell in ,ic ,e ,or.
a. ell Re"erencing6
Relati8e cell re"erencing6
:n )hi& e)hod cell addre&& au)oa)icall* change& when a ,orula i& dragged
and a++lied )o ano)her cell.
Ab$olute cell re"erencing6
:n )hi& e)hod cell addre&& reain& con&)an) and doe& no) change when a
,orula i& dragged and )o a++lied )o ano)her cell.
-
8/11/2019 New Microsoft Office .Document.doc
14/105
Mi4e* cell re"erencing6
:n )hi& e)hod we can
-
8/11/2019 New Microsoft Office .Document.doc
15/105
)N' >Number?6 :) round& )he nuber down )o )he neare&) in)eger.
E4amle6 @)N' >.B?
)t return$
MOD >number3 *i8i$or?6 :) re)urn& )he reainder a,)er )he nuber
)he nuber i& diided b* dii&or.
E4amle6 @MOD >&3 2?
)' return$ 1 becau$e remain*er i$ 1
POWER >Number3 Po,er?6 :) re)urn& )he re&ul) o, a nuber rai&ed )o
+ower.
E4amle6 @POWER >&3 2?
)t ,ill$ return$ B.
RO%ND >Number3 num Digit$? / :$ round& )he nuber )o a &+eci&.13 1?
)t ,ill$ return$ &.2
SQR' >Number?6 :) re)urn& )he +o&i)ie &uare roo).
E4amle6 @SQR' >1++?
)t ,ill return 12.
S%M >Number13 Number2?6 :) add& all )he nuber in arrange o, cell.
E4amle6 @S%M >&3 2?
)' return$ becau$e it a**$ & an* 2.
-
8/11/2019 New Microsoft Office .Document.doc
16/105
A=ERA/E >Number3 Number2C.?6 :) re)urn& )he aerage o, )he
gien arguen).
E4amle6@A=ERA/E >333?
)t ,ill$ return$ .
TEX T FUN CT ION 6
!EN >'e4t?6:$ re)urn& )he nuber o, charac)er in a )e) &)ring.
E4amle6 @!EN >FMS EXE!G?
)t ,ill$ return$ .
ONA'ENA'E >'e4t13 'e4t2C?6 :) @oin &eeral )e) &)ring& in )o one
)e) &)ring.
E4amle6 @ONA'ENA'E >F=)=E5G3GS)N/H?
)t ,ill return =)=E5S)N/H
!E#' >'e4t3Num-ar$?6:) re)urn& )he FM)NA5SH)G?
)t ,ill return mina$i.
%PPER >F'e4tG?6 )t con8ert$ te4t to uerca$e.
E4amle6 @%PPER >FroitG?
-
8/11/2019 New Microsoft Office .Document.doc
17/105
)t ,ill return ROH)'.
Date and Time Function
DA'E >(ear3 Mont3 Day?6:) re)urn& )he &euen)ial &erial nuber
)ha) re+re&en) a +ar)icular da)e. :, )he cell ,ora) wa& eneral be,ore)he ,unc)ion wa& en)ered )he re&ul) i& ,ora))ed a& a da)e. "celin)er+re)& )he *ear arguen) according )o )he da)e &*&)e *ou areu&ing. * de,aul) "cel u&e& )he 1900 &*&)e.
E4amle6 @DA'E >2II3 113 ?
)t ,ill return &2.
DA( >FSerial Number or DateG?6 :) re)urn& )he da* o, a da)e. $he
da* i& gien a& in)eger ranging ,ro 1)o31
E4amle6 @DA( >&2?
)t ,ill return
MON'H >Serial Number or FDateG?6:) re)urn& )he on)h o, a da)e
re+re&en)ed b* a &erial nuber. $he on)h i& gien a& an in)egerranging ,ro 1=!anuar*? )o12 =Deceber?.
E4amle6 @MON'H >&2?
)t ,ill return 11.
(EAR >Serial Number or FDateG?6:) re)urn& )he *ear corre&+onding
)o a da)e. $he *ear i& re)urned a& an in)eger in )he range 1900'9999.
E4amle6 @(EAR >&2?
)t ,ill return 2II.
NOW>?6:) re)urn )he curren) da)e and )ie &e) on )he co+u)er
HO%R >$erial number or 'ime?6:) re)urn& )he hour o, a )ie alue.
-
8/11/2019 New Microsoft Office .Document.doc
18/105
E4amle6 @HO%R >F16&IG?
)t ,ill return 1.
FINANCIAL FUNCT ION
#uture 8alue6 Re)urn& )he ,u)ure alue o, an ine&)en) ba&ed on+eriodic con&)an) +a*en)& and a con&)an) in)ere&) ra)e.
Syt-4
FV *mt> ;V> ty*e>
Ner6Re)urn& )he nuber o, +eriod& ,or an ine&)en) ba&ed on+eriodic con&)an) +a*en)& and a con&)an) in)ere&) ra)e.
Syt-4
N;ER
Pmt6#alcula)e& )he +a*en) ,or a loan ba&ed on con&)an) +a*en)&and a con&)an) in)ere&) ra)e.
Syt-4
;MT *1> /1> ty*e>
P86Re)urn& )he +re&en) alue o, an ine&)en). $he +re&en) alue i& )he)o)al aoun) )ha) a &erie& o, ,u)ure +a*en)& i& wor)h now. or ea+lewhen *ou borrow one* )he loan aoun) i& )he +re&en) alue )o )helender.
Syt-4
;V
-
8/11/2019 New Microsoft Office .Document.doc
19/105
Rate6Re)urn& )he in)ere&) ra)e +er +eriod o, an annui)*. RA$" i&calcula)ed b* i)era)ion and can hae ero or ore &olu)ion&. :, )he&ucce&&ie re&ul)& o, RA$" do no) conerge )o wi)hin 0.0000001 a,)er 20i)era)ion& RA$" re)urn& )he BC% error alue.
Syt-4
RATE
'allyINTROD?CTION
$he )o+ic i& in)er+re)ed a& ei)her an accoun)ing +ackage
acce&&ible )hrough a windowing in)er,ace or one )ha) run& on %icro&o,) window&o+era)ing &*&)e. "i)her wa* $all*
-
8/11/2019 New Microsoft Office .Document.doc
20/105
HAR'S O# AO%N'S$
Personal accounts Real accounts Nominal accounts
Debit
The receiver What comes in
Expenses and
losses
Credit The giver What goes out Incomes and gains
TALLY START ?;$
*Click o Sta&t?&o%&ams?ally ies7.2?ally7.2 ico.
*"ou'le click o t#e ally7.2 @co o t#e (eskto,.
$he (elcoe &creenJ 'ally-Po,er o" $imlicityJ a++ear&
while )he &o,)ware load&. (hen )he $all* &)ar) u+ &creen
a++ear& *ou are read* )o e+lore $all*.
SE'')N/ %P A NEW OMPAN($
Com*-y A comany i$ ba$ically a le ,ere
tran$action relating to a articular comany are
entere*.
C&eati% a com,ay
-
8/11/2019 New Microsoft Office .Document.doc
21/105
T&e 5om*-y I/o s5,ee &-s @1e o*tios%n*er#i4e* A$$e$t?
/o to /ate,ay o" 'ally L Account$ )n"o L !e*ger$
L reate to bring u te Muti !e*ger reationScreen.
Select #i4e* A$$et$ in te el*.
-
8/11/2019 New Microsoft Office .Document.doc
37/105
9- Mae an entry o" te tran$action in a ayment=oucer.
THE INTERNET
:n )he 1970& co+u)er engineer& a) re&earch in&)i)u)ion& )hroughou) )he -
began )o link )heir co+u)er& )oge)her u&ing )elecounica)ion& )echnolog*.
$hi& eGor) wa& ,unded b*ARPA and )he co+u)er ne)work)ha) i) +roduced wa&
called )he ARPAC"$. $he )echnologie& )ha) ade )he Ar+ane) +o&&ible &+read
and eoled. :n )ie )he ne)work &+read be*ond acadeic in&)i)u)ion& and
becae known a& )he :n)erne). :n )he 1990& )he deelo+en) o, (orld (ide
(eb)echnologie& enabled non')echnical +eo+le )o u&e )he in)erne) and i) grew
ra+idl* )o becoe a global counica)ion& ediu)nternet 6
:) can be de
-
8/11/2019 New Microsoft Office .Document.doc
38/105
a& a ne)work o, ne)work& +roiding in,ora)ion on an* iaginable )o+ic )o
eer*one on ear)h. :) i& con)inuou&l* growing global area ne)work which i&
u+da)ed wi)h load& o, in,ora)ion eer* &econd.
Web age 6
:n,ora)ion on )he in)erne) i& di&+la*ed in )he ,or o, da)a on one ,ull &creen a)
a )ie. $hi& ,ull &creen di&+la* o, in,ora)ion i& called a& a ,eb age.
:n,ora)ion regarding an* one )o+ic can no) be accooda)ed on ,ull &creen.
$here,ore )he* are diided in)o ul)i+le web +age& which are in)erconnec)ed
wi)h each o)her. $he
-
8/11/2019 New Microsoft Office .Document.doc
39/105
:) i& a &*&)e which &u++or)& and anage& )he linking o, in)er'rela)ed
-
8/11/2019 New Microsoft Office .Document.doc
40/105
or h)lM. $he&e docuen)& when di&+la*ed in an* web brow&er lookeac)l* like aweb +age or in ano)her word& we can &a* )ha) )he* go)coner)ed in)o web +age&.
2. $ag& o, 8$%L docuen)& de
-
8/11/2019 New Microsoft Office .Document.doc
41/105
D)/)'A! AND ANA!O/ 'RANSM)SS)ONto be u$e* by te A*mini$trator?
Double Clic1 on the shortcut 2double clic1 on the application
/N!_On"ineTest_100Hrs#e$e& to run the application(
-
8/11/2019 New Microsoft Office .Document.doc
46/105
Enter Pass-ord /keep it secret, otherwise security will be failed0(
Then Clic1 on Start Pro3ect! to start the examination on selected
sub3ect(
S'EPS >to be "ollo,e* by te Stu*ent$?
.illed up necessary in+ormation and clic1 on Start(
No- examination -ill be started
4uestion and "ns-ers /5 or less0 -ill be displayed(
Chose the correct ans-er /only one0 +rom the "ns-er 'ox at the
Right*6and*Side and clic1 on Clic1 +or Next 4uestion!(
"utomatically the previous "ns-er -ill be saved and any time you
can be bac1 to the previous 7uestion by clic1ing on Clic1 +or
Previous 4uestion! and you can also change the ans-er(
Student can also s1ip to next 7uestion -ithout giving any ans-er and
try those at last(
Do not click on the !"#mit$ #"tton that %ill terminate the
e&amination an' comp"te the re("lt)
"t right*hand*side the starting time and total time remaining -ill be
displayed(
When the time remaining attains $$8$$ value, all controls on the
screen -ill be loc1ed except Submit! button(
Student can chec1 the ans-ers i+ time permits(
"+ter giving all ans-ers -ithin the time, clic1 on Submit! button(
Result -ill be computed immediately and displays on the screen(
-
8/11/2019 New Microsoft Office .Document.doc
47/105
!*+P! , !(tem .nitiali/ation
A0ter completion o0 each online te(t on a partic"lar machine the
0ollo%ing (tep( to #e e&ec"te' # the A'mini(trator 0or
initiali/ation)
Then Initiali9e +rom "dministrator*Session Initiali9ation!( :se the
same pass-ord /as supplied +or "dministrator0
The so+t-are is no- ready +or another online examination(
O*+!
"ny time the total duration can be changed +rom "dministrator*Time
Settings /i+ re7uired0( :se the same pass-ord /as supplied +or
"dministrator0
Trou'le S(ootin)
"+ter starting examination i+ someone +ails to +ill up the in+ormation(
Initiali9e again +rom "dministrator*Initiali9ation( .or any abnormal termination li1e Po-er Cut, Run Time Error,
accidentally closure o+ the "pplication by the Students and +or any
other reason( Start the application again and select Start Pro3ect ;
REPE"T!, +ill the in+ormation again and clic1 on start to resume the
examination /ca"tion 'ont initiali/e the (e((ion i0 it happen(0
-
8/11/2019 New Microsoft Office .Document.doc
48/105
*ATCH NO+ , 1- S%*.ITT/ *+ ,
SA%RA*H ATIAR
R%N *+, RG# NO+ , CRO,0123302
.R# SHASHAN SA4SNA .#C#A
5
.RS# R%CHI A!ASTHI C#A
-
8/11/2019 New Microsoft Office .Document.doc
49/105
IN/4
6, .S,!OR/ 7a)e# No#
a( )acro 8#
b( )ail merge 9#
:, .S,4C"
a# Cell Re+erencing 1:#
'# .unctions :sages 18#
;, TA""
a( Introduction :1#
b( .eatures :-#
c( .unctions ;0#
8, INTRNT
a( Introduction 8;#
b( .unctions 88#
6, 7O!R7OINT 6:#
-
8/11/2019 New Microsoft Office .Document.doc
50/105
7Rirtually in e?ery wal@ o= li=e a person is e$pected to'e a'le to use o= computer# An Accountant w(o
does not understand computer 'ased Accountin)
system is li@ely to 'e "e=t (i)( 5 dry in t(e
pro=ession# A wor@in) @nowled)e o= in=ormation
tec(nolo)y is a 'asic 'read 5 'utter requirement o=
C(artered Accountant today# In t(e 100 (our
In=ormation Tec(nolo)y trainin) pro)ram we all are
'ein) tau)(t a'out t(e rapidly c(an)in) su'ect i#e#
Computer to de?elop t(e practical implication o=
in=ormation tec(nolo)y I ?arious areas o=
pro=essional practice#
Our earnest (ope is t(at you will li@eour (onest (ard wor@ in ma@in) ITT 7roect on
In=ormation Tec(nolo)y#
-
8/11/2019 New Microsoft Office .Document.doc
51/105
ACNO!"/G.NT
/e?elopin) a proect was not an easy tas@
and would not (a?e 'een possi'le wit(out t(e (elp
o= and support o= my teac(ers#
-
8/11/2019 New Microsoft Office .Document.doc
52/105
.S !OR/
.icroso=t !ord )i?es us many power=ul tools =or creatin)and de?elopin) word documents# !ord is also a ?eryuse=ul TOO" =or manipulatin) te$t and TO 7RO/%Cdocuments suc( as memosB class notesB lettersB termpaperB and ot(er written te$t#
I.7ORTANT
-
8/11/2019 New Microsoft Office .Document.doc
53/105
" macro is a single instrument that per+orms several di++erent commands
in a se7uence determined by the user, and triggered -hen you run it(
Typical uses +or macros are8
To speed up routine editin)and =ormattin)
To combine multiple commands > +or example, to insert a ta'le
wit( a speci=ic sie and 'orders, and -ith a speci+ic number o+ro-s and columns
To ma1e an option in a dialog box more accessible
To automate a comple$ series o= tas@s
We can use the macro recorder to record a se7uence o+ actions, or you
can create a macro +rom scratch by entering &isual 'asic +or
"pplications /&isual 'asic +or "pplications /&'"08 " macro*language
version o+ )icroso+t &isual 'asic that is used to program )icroso+t
Windo-s*based applications and is included -ith several )icroso+t
programs(0 code in the &isual 'asic Editor /&isual 'asic Editor8 "n
environment in -hich you -rite ne- and edit existing &isual 'asic +or
"pplications code and procedures( The &isual 'asic Editor contains a
complete debugging toolset +or +inding syntax, run*time, and logic
problems in your code(0(
RCOR/ A .ACRO
-
8/11/2019 New Microsoft Office .Document.doc
54/105
Type a name into the ?Name? box( Call it something you -ill
remember later
Choose ?Toolbars? or ?@eyboard? to have the macro assigned to a
toolbar or to the 1eyboard as a shortcut
Pic1 the location -here you -ant to use the macro( Aou can use
?"ll Documents? or your current document only(
Clic1 ?
-
8/11/2019 New Microsoft Office .Document.doc
55/105
*# .AI" .RGR
-
8/11/2019 New Microsoft Office .Document.doc
56/105
.ail mer)eis a so+t-are +unction describing the production o+ multiple/and potentially large numbers o+0 documents +rom a single template+orm and a structured data source( This techni7ue is typically used tocreate personali9ed letters and pre*addressed envelopes or mailing
labels +or mass mailings +rom a database mailing list o+ names andaddresses(
.ollo-ing are the steps -hich are to be +ollo- -hile create mail merge8*
B*
-
8/11/2019 New Microsoft Office .Document.doc
57/105
* Save the above given data by any name and press o1 button
B* Type the matter that you -ant to send to all the person
* Place the insertion point at the position -here you -ant very +irst+ield
5* Clic1 on insert merge tool Sixth option +rom the le+t side on mail
merge tool barJ
aK*Select the appropriate +ield +rom the available list
bL*Press the insert button clic1 close button
cK*Change the position and repeat last three steps
* Select -rite your letter option
%* Select previe- i+ your letterF* Select complete the merge
#* Select edit individual letter
G* Select o1 button
5$* "s a result the matter -ill be available +or all the record onseparate pages
-
8/11/2019 New Microsoft Office .Document.doc
58/105
SC%RIT
-
8/11/2019 New Microsoft Office .Document.doc
59/105
.S 4C"Excel is -hat is 1no-n as a spreadsheet application( In the days be+orespreadsheets, columns o+ numbers -ere calculated on sheets o+ papersall addition, subtraction etc( -here done manually by the user( " spreadsheet still uses the idea o+ a large sheet o+ paper into-hich numbers are entered( " spreadsheet is a highly interactivecomputer program that consists o+ a collection o+ ro-s and columns thatare displayed on screen in a scrollable -indo-( The intersection o+ eachro- and column is called a cell(
CO.7ONNT O< .S_4C"+
$* !or@'oo@8 It is a +ile in )SMECEO(
* !or@s(eet8 Wor1boo1 consists o+ -or1sheet(
B* Rows+These are hori9ontal collection o+ cells(
* Columns8 These are vertical collection o+ cells(
5* Cell8 It is intersection o+ ro-s and columns(
*
-
8/11/2019 New Microsoft Office .Document.doc
60/105
A# C"" R
-
8/11/2019 New Microsoft Office .Document.doc
61/105
In this method cell address automatically changes -hen a +ormula is
dragged and applied to another cell(
A'solute cell re=erencin)+
In this method cell address remains constant and does not change-hen a +ormula is dragged and to applied to another cell(
.i$ed cell re=erencin)+
In this method, -e can +ix either the ro- or column number and
changes automatically -hen a +ormula is dragged and applied to
another cell( To +ix ro- or column -e used the dollar sign /0 be+ore
the ro- or column value(
-
8/11/2019 New Microsoft Office .Document.doc
62/105
Common error in =ormula+
When -e enter +ormula, sometimes you get some message( These
messages indicate that some error has occurred( These are some o+
the error messages(
DDDD+It indicate that cell in too small to display the result(
DNA.E+It indicate that the +unction contains a name that
Excel does not recogni9e(
DR
-
8/11/2019 New Microsoft Office .Document.doc
63/105
*#
-
8/11/2019 New Microsoft Office .Document.doc
64/105
INT FNum'er&+ It rounds the number do-n to the nearest
integer(
$ample+ INT F2#3&
It returns 2
.O/ Fnum'erB di?isor&+ It returns the remainder a+ter the
number the number is divided by divisor(
$ample+ .O/ F;B :&
IT returns 1 'ecause remainder is 1
7O!R FNum'erB 7ower&+ It returns the result o+ a number
raised to po-er(
$ample+ 7O!R F6B :&
It wills returns :6#
RO%N/ FNum'erB num /i)its& 8 IT rounds the number to a
speci+ied number o+ digits(
$ample+ RO%N/ F:#16B 1&
It wills returns :#:
SRT FNum'er&+ It returns the positive s7uare root(
$ample+ SRT F1-&
It will return 8#
-
8/11/2019 New Microsoft Office .Document.doc
65/105
S%. FNum'er1B Num'er:&+ It adds all the number in arrange
o+ cell(
$ample+ S%. F;B :&
IT returns 6 'ecause it adds ; and :#
A>RAG FNum'erB Num'er:#&+ It returns the average o+
the given argument(
$ample+ A>RAG F:B 8B 6B 3#&
It wills returns 6#
T4T
-
8/11/2019 New Microsoft Office .Document.doc
66/105
"O!R FJTe$tK&+It converts the uppercase letter in a text
string to lo-er case(
$ample+ "O!R FJ.INASHIK&
It will return mina@s(i#
%77R FJTe$tK&+ It con?erts te$t to uppercase#
$ample+ %77R FJro(itK&
It will return ROHIT#
/ate and Time
-
8/11/2019 New Microsoft Office .Document.doc
67/105
$ample+ .ONTH F;2--:&
It will return 11#
AR FSerial Num'er or J/ateK&+It returns the year
corresponding to a date( The year is returned as an integer inthe range G$$*GGGG(
$ample+ AR F;2--:&
It will return :006#
NO!F&+It return the current date and time set on the computer
HO%R Fserial num'er or Time&+It returns the hour o+ a time
value(
$ample+ HO%R FJ16+;0K&
It will return 16#
-
8/11/2019 New Microsoft Office .Document.doc
68/105
7mt+Calculates the payment +or a loan based on constant
payments and a constant interest rate(
Synta$
7.T/rate,nperB p?B =?B type0
7?+Returns the present value o+ an investment( The present value
is the total amount that a series o+ +uture payments is -orth no-(.or example, -hen you borro- money, the loan amount is thepresent value to the lender(
Synta$
7>/rate,nper,pmt,+v,type0
Rate+Returns the interest rate per period o+ an annuity( R"TE is
calculated by iteration and can have 9ero or more solutions( I+ thesuccessive results o+ R"TE do not converge to -ithin $($$$$$$a+ter B$ iterations, R"TE returns the QN:) error value(
Synta$
RAT/nper,pmt,p?,+v,type,guess0
TA""
INTRO/%CTION
-
8/11/2019 New Microsoft Office .Document.doc
69/105
The topic is interpreted as either an accounting pac1age
accessible through a -indo-ing inter+ace or one that runs on )icroso+t
-indo-s operating system( Either -ay, Tally +its the description(
"ll screen in tally are vie-ed as -indo-s processing the+ollo-ing*
*" title bar that displays the name o+ the application
*" tally icon to the le+t that pulls do-n the menu comprising restore,
move, si9e, minimum and maximum menu item(
The visible advantage o+ the accounting pac1age is
simplicity, +lexibility, speed, scalability, and real time access to data
across location and even -ith other applications(
CHARTS O< ACCO%NTS
Personal accounts Real accounts Nominal accounts
Debit
The receiver What comes in Expenses and losses
Credit The giver What goes out Incomes and gains
TA"" START %7
*Clic1 on StartProgramsTally iesF(BTallyF(B icon(
*Double clic1 on the TallyF(B Icon on the des1top(
The Welcome screen,L Tally,7ower o= simplicityL appears -hile the
so+t-are loads( When the Tally start up screen appears, you are ready to
explore Tally(
STTING %7 A N! CO7.AN
-
8/11/2019 New Microsoft Office .Document.doc
70/105
Company A company is 'asically a =ile w(ere transaction
relatin) to a particular company are entered#
Creating a company
T(e company In=o screen (as =i?e options+
%* Select Company ,to select an existing company +rom the list o+company already created
F* Create Company is to create ne- one(
#* 'ac1up is to ta1e a bac1up o+ stored data(
G* The option Restore is to extract in+ormation +rom the bac1updevice(
$* The last option 7uit is to exit +rom Tally(
Selecting Create Company option brings us to the screen given
belo-8
-
8/11/2019 New Microsoft Office .Document.doc
71/105
ac( o= t(e =ield in t(e Company Creation screen is
e$plained 'elow#
Name+ It is mandatory to enter the name i+ the company#
.ailin) Address+ .ill in the Company address details( It is
-
8/11/2019 New Microsoft Office .Document.doc
72/105
,mail Address+ E*mail address -ill be used to e*mail document,reports and data +rom Tally( This +ield is optional(
Currency Sym'ol+ Tally displays Rs(by de+ault( This cannot bemodi+ied at the time o+ the creation o+ the Company(
.aintain+ The +ield is used to speci+y -hich section o+ Tally yourcompany -ould li1e to use( Tally displays t-o options ;"ccount only and
"ccounts -ith Inventory(
ault 7assword Fi= any&+Tally vault is a +acility to 1eepthe protected using a pass-ord(
-
8/11/2019 New Microsoft Office .Document.doc
73/105
T(e completed Company Creation screen appears s(own#
Tally will ta@e you to t(e JGateway o= TallyK screen t(at
appears as s(own#
-
8/11/2019 New Microsoft Office .Document.doc
74/105
-
8/11/2019 New Microsoft Office .Document.doc
75/105
-
8/11/2019 New Microsoft Office .Document.doc
76/105
>ouc(er Con=i)uration
Go to Gateway o= TallyM=1:+ con=i)ureM ?ouc(er entry#
"ed)ers+ Tally provides a set o+ B# pre*de+ined groups under -hich the
ledger can be classi+ied
*Primary groups ;
*Sub groups ;
-
8/11/2019 New Microsoft Office .Document.doc
77/105
Tally has pre*de+ined ledgers +or Cash /under cash ;in ;hand group0 and
+or the Pro+it and Ooss account /under primary group0(
Create sin)le led)er+
GO to )ateway o= Tally MAccountin) In=o M"ed)er MSin)le
"ed)erMCreate to bring up the Oedger creation screen(
Oedger "2c can also be created +rom the &oucher screen by using the
shortcut 1ey Alt C
Alter "ed)er+Aou can alter ledger details using either single or
multiple modes( Aou are not allo-ed to delete a ledger +rom multiple
modes( Press 1ey "lt D to delete ledger under single alteration modes(
-
8/11/2019 New Microsoft Office .Document.doc
78/105
/isplay led)er+ Aou can display ledger in either single or multiple
modes( :nder multiple modes you can display all ledgers by choosing
"ll items! in :nder groups! option( Aou can also speci+y the particular
group o+ the ledger you -ant to display(
ouc(ers+
Tally is pre*programmed -ith a variety o+ accounting vouchers, each
designed to per+orm a speci+ic 3ob( The standard vouchers are
Contra >ouc(er
7ayment >ouc(er
Receipt >ouc(er
Pournal >ouc(er
Sales >ouc(er
Contra >ouc(er+
Go to Gateway o= TallyMAccountin) >ouc(erMouc(er#
-
8/11/2019 New Microsoft Office .Document.doc
79/105
7ayment ?ouc(er+
Gateway o= Tally M Accountin) >ouc(er Mouc(er#
Receipt >ouc(er+
Gateway o= Tally M Accountin) >ouc(er M ouc(er#
Sales In?oice+
Go to Gateway o= Tally M Accountin) >ouc(er M
-
8/11/2019 New Microsoft Office .Document.doc
80/105
*alance s(eet+ The balance sheet is a +inancial statement that
indicates the +inancial strength o+ the company at any given point( It list
the assets and liabilities o+ a company(
Go to )ateway o= Tally M *alance s(eet#
7ro=it and loss Account+ The Pro+it and loss "2c is a +inancial
Statement that describes the operational results o+ the company or its
earning capacity +or a given period( It lists the company incomes andexpenditure( No special processing is re7uired to produce a pro+it and
loss "2c in Tally(
Go to Gateway o= Tally M 7ro=it and "oss Ac#
Clic@ on
-
8/11/2019 New Microsoft Office .Document.doc
81/105
Go to Gateway o= Tally M /isplayMAccounts *oo@s MCas(*an@
*oo@s#
"ed)er+ To vie- the Oedger summary
Go to Gateway o= Tally M /isplay M Accounts *oo@s M led)er
MSelect led)er Ac
Group summary+ The group summary statement sho-s the closingbalances o+ the accounts o+ a selected group +or a speci+ied period up to
the current date(
Go to Gateway o= Tally M /isplay M Accounts 'oo@s M Group
summary#
Group ?ouc(er+ The group &oucher +eature lists all vouchersentered in any ledger o+ the selected group(
To vie- group voucher(
Go to Gateway o= Tally M /isplay M Group ?ouc(er M Select )roup#
Pournal re)isters + =ournal registers report display all the 3ournal
vouchers that have been passed (
To vie- 3ournal register details
Go to Gateway o= Tally M /isplay M Accounts 'oo@s M ournal
re)ister#
/ay 'oo@+ The day boo1 s a list o+ all transaction +or a particular day(
Day boo1, by de+ault, uses the current data(
-
8/11/2019 New Microsoft Office .Document.doc
82/105
To vie- Day boo1
Go to Gateway o= Tally M /isplay M /ay 'oo@#
"ist o= Accounts + Oist o+ accounts display the existing chart o+
accounts , listed as group , in alphabetical order (
To vie- list o+ accounts
Go to Gateway o= Tally M display M "ist o= Accounts#
-
8/11/2019 New Microsoft Office .Document.doc
83/105
We can analy9e the accounts o+ our company using ratio analysis( Ratio
analysis is use+ul +or management in the decision*ma1ing process( We can
even analy9e di++erent outstanding o+ parties using Receivables turnover ratio
etc( We can display the age*-ise statement in Tally based on the receivables
or payables( The age -ise analysis can be done either on bill date or due
date( 7ress
-
8/11/2019 New Microsoft Office .Document.doc
84/105
@EA
-
8/11/2019 New Microsoft Office .Document.doc
85/105
"OT. To close a company( "t all menu screens(
To vie- a detail report( "t almost all report screens
To explore a line into its
details(
"t almost all screens(
"OT.B To change a period( "t almost all screens(
"OT. To select the company in+o
menu(
"t gate-ay o+ tally screens(
"OTC To create a ledger at a
voucher screen(
"t accounting voucher and alteration
screen(
"OTN To add multiple column to areports
"t all report, trial balance, cash ban1boo1 and =ournal register screen(
"OTP To print report( "t all report screen(
CTRO4 To 7uite a screen( "t almost all screen(
4A.7"
Transaction =or April :002
%* Nandini @apur Started :niversal 'usiness Solution 'y bringing InCash o+ Rs($$$$$(
"s per Tally Conventions
C* Create Oedger8 Nandini @apur Capital "2c /:nder Capital"ccount0
Ho to Hate-ay o+ Tally "ccounts In+o Oedger Simple
Oedger Create to bring up the Oedger creation Screen(
Name8 Nandini @apur Capital "2c(
/allias08 Oeave the +ield blan1(
:nder Hroup8 Select Capital "2c(
-
8/11/2019 New Microsoft Office .Document.doc
86/105
-
8/11/2019 New Microsoft Office .Document.doc
87/105
F* )s( @apur opened a ban1 account -ith 6D.C 'an1, 'angalore+or the +irm by depositing cash o+ Rs($$$$$(
"s per Tally Convention8
"* Create ledger +or 6D.C 'an1 /:nder 'an1 "ccounts0(
)a1e an entry o+ the transaction in the Contra
&oucher(
Ho to Hate-ay o+ Tally "ccounting &ouchers
.58 Contra(
Credit purchases8 cash* $$$$$(
Debit particulars8 6D.C 'an1 ;amount o+ Rs(
$$$$$ is automatically displayed(
Narration8 S1ip(
*)s( @apur rented an o++ice space +or Rs(B$$ per month on "pril
$, B$$#( She paid security deposit o+ Rs(B$$$ by Che7ue(
"s per Tally convention8
-
8/11/2019 New Microsoft Office .Document.doc
88/105
'* Create ledger ;Security deposit ;
-
8/11/2019 New Microsoft Office .Document.doc
89/105
*, )a1e an entry o+ the transaction in a payment &oucher(
-
8/11/2019 New Microsoft Office .Document.doc
90/105
TH INTRNT
INTRO/%CTION
-
8/11/2019 New Microsoft Office .Document.doc
91/105
In the GF$s, computer engineers at research institutions throughout the
:S began to lin1 their computers together using telecommunications
technology( This e++ort -as +unded by "RP", and the computer net-or1,-hich it produced, -as called the "RP"NET( The technologies that
made the "rpanet possible spread and evolved( In time, the net-or1
spread beyond academic institutions and became 1no-n as the
INTERNET( In theGG$s , the development o+ W
-
8/11/2019 New Microsoft Office .Document.doc
92/105
accommodated on +ull screen( There+ore they are divided into multiple
-eb pages -hich are interconnected -ith each other( The +irst page
displayed immediately on re7uesting any particular in+ormation on net is
1no-n as (ome pa)e(
Site+
In+ormation on internet is provided using some location2address or point
o+ access -hich is 1no-n as site( Every site has its o-n uni7ue address
through -hich data available on it can be accessed(
!e' Ser?er+
Servers are special category o+ po-er+ul computers that can provide
services to other connected computers( Computers that are providing
services to other computers on internet are 1no-n as -eb servers( They
are also called as host systems or host computers( These servers store
-eb pages and trans+er them to the re7uesting computers on the
internet( 'esides -eb servers +ollo-ing types o+ servers are also
available on internet8
Hyper Te$t+
" hyper text is special 1ind o+ text on a -eb page that leads to some
other text on clic1ing it( Cursor changes its shape as it is placed on any
hyper text and generally gets converted into a hand -ith pointing +inger(
Clic1ing on any hypertext opens and ta1es another page
us to another location( 6yper text in any document or a -eb page is
displaced in di++erent color other than the normal text color and mostly
underline(
-
8/11/2019 New Microsoft Office .Document.doc
93/105
!orld !ide !e'+
It is a system -hich supports and manages the lin1ing o+ inter*related
+iles( It is also called as W( It -as originally designed by a physicist
named Tim *erners in Particles Physics Centre in Heneva( It can beseen -ith almost every site address and they are searched using World
Wide Web(
Internet Ser?ices 7ro?ider+
This is a body or an organi9ation through -hich a user is able to access
internet( "n ISP provides internet services to its subscribers( It is the
responsibility o+ an ISP to provide internet services to the user and
handle all its connection procedures( "n internet service provider bridgethe gap bet-een the user and internet Every nation and country has
various ISPs -ho o++er internet services to their citi9ens( In India
+ollo-ing ISPs are o++ering Internet Connection8
%0 'SNO /'harat Sanchar Nigam Oimited0
F0 Satyam
-
8/11/2019 New Microsoft Office .Document.doc
94/105
4. Creation o+ -eb pages is actually a creation o+ 6T)O document(This 6T)O document -hen seen in bro-ser is converted into a-eb page(
5. 6T)O document is a collection o+ various Vtags and theirproperties 1no-n as Vattributes( .or every single tas1 there areprede+ined tags and their attributes( There are prede+ined tagsand their attributes( There is a prede+ined syntax o+ -ritingthese tags and at proper places in 6T)O documents(
6. 6T)O document can be created in any text editor and they loo1li1e plain text +iles( 6T)O documents must be saved -ithextension htm! or html!( These documents -hen displayed inany -eb bro-ser loo1 exactly li1e a -eb page or in another-ords -e can say that they got converted into -eb pages(
7. Tags o+ 6T)O documents de+ine the contents and loo1 o+ thedocument( "lmost every tag has a beginning point and atermination point and are enclosed -ithin angle brac1etsX (Each tag has di++erent role to play and it is identi+ied by its namei(e( its element( "lso there are some tags that do not haveending tags( They are used singly and are also called assingleton tags(
/ATA TRANS.ISSION S7/+
" term used to describe the data*handling capacity o+ acommunication system is band-idth( 'and-idth is the range o++re7uencies that is available +or the transmission o+ the data( " narro-
range o+ +re7uencies in a communication system analogous to a narro-road i(e(, its data trans+er rate is limited, 3ust li1e as the +lo- o+ tra++ic inthe narro- road( Wider band-idths permit more data trans+er throughthe communication channel at the same time(
NARRO!*AN/8
-
8/11/2019 New Microsoft Office .Document.doc
95/105
When data trans+er rate is bet-een 5 to $$ bps then this is called
narro- band and transmission( They are mainly +or telegraph line and
lo- speed terminals(
>OIC*AN/
&oice band channels handle moderate data volumes and can transmit
data at speed up to G%$$bps(They are so called because their
ma3or applications is +or ordinary telephone voice communication( )ost
remote terminals are connected to computers through voice band
channel(
*ROA/*AN/+
'road band or -ide band channels are used -hen large volume o+
data is to be transmitted at high speed( These systems provide data
transmission rates o+ million /$$$$$$0 bps or more (No- a days broad
band communication is gaining clarity( This is basically used in mobile
devices such as cellular phone, laptop, noteboo1 etc(
.odem
)odulation and demodulation
It converts digital data into analog data /called modulation0
and at the receiving end, it converts analog data into digital data
/called demodulation0)odems usually operate at speeds ranging +rom
B,5$$ to B#,#$$ bits per second over telephone lines, at +aster rates over
leased lines
/IGITA" AN/ ANA"OG TRANS.ISSION+
Data is propagated +rom one point to another by means o+
electrical signal inch can be o+ t-o +orms8/0 analog signals /B0 digital
signals
In "N"O
-
8/11/2019 New Microsoft Office .Document.doc
96/105
,CO..RC+
Short +or electronic commerce( Commercial activity that ta1es place
by means o+ computers connected through a net-or1( Electroniccommerce can occur bet-een a user and a vendor through theInternet, and online in+ormation service, or a bulletin board system/''S0, or bet-een vendor and customer computers through electronicdata interchanged /EDI0(
Types o= Communication .edia
Communication media are the communication channels through -hich
in+ormation is transmitted bet-een computers in a net-or1
Communication media cate)ories
Communication media are broadly divided into t-o categories8
Physical line or -ired media
Wireless media
!ired .edia
T-isted pair cable
Coaxial cable
.iber optic cable
Twisted 7air Ca'le
It consists o+ t-o -ires t-isted into a spiral con+iguration
Wires are usually made up o+ copper Y steel
-
8/11/2019 New Microsoft Office .Document.doc
97/105
-
8/11/2019 New Microsoft Office .Document.doc
98/105
Coa$ial Ca'le
It is a thic1 single -ire consisting a central copper -ire -hich is
surrounded by P&C insulation
-
8/11/2019 New Microsoft Office .Document.doc
99/105
It permit data transmission rates o+ about % Higa bits per
sec/ HigaZ$Gbps
Satellite Communication
These satellites are launched either by roc1ets or by space
shuttles and placed in a geostationary orbit at %$$$1m above thee7uator(
The speed o+ the satellites in this orbit e7uals to the speed o+
rotation o+ the earth(
.S,7O!R 7OINT
INTRO/%CTIOON TO .S,7O!R 7OINT8*
-
8/11/2019 New Microsoft Office .Document.doc
100/105
The importance o+ )S*Po-er Point in todays +ast moving -orld( It gives a
brie+ note on the +eatures in )S*po-er point and teaches the basic
developing a po-er point presentation( Presentations can be used to
display diverse in+ormation in a clear and concise manner(
Startin) .S,7ower 7oint8*
o Turn the computer on(o .rom the start button, choose Programs(
-
8/11/2019 New Microsoft Office .Document.doc
101/105
o This screen prompts you to ma1e a selection +rom the +ollo-ing
o Select 'lan1 presentation( " dialogue box -ill appear(
-
8/11/2019 New Microsoft Office .Document.doc
102/105
o Choose the =irst slide(o Type Titleo= 7resentation! in the title box by clic1ing the mouse(
o Place some text in the subtitle box( "nytime you can edit your text,change +onts, change si9e, or style by using the standard -ordprocessing +unctions(
This -ill be complete your +irst slide(
-
8/11/2019 New Microsoft Office .Document.doc
103/105
o Create a ne- slide by pulling do-n the insert pull do-n menu(Select the second layout, clic1 O(
o Same procedure use in text in second slide(Insert Clip "rt8*
o Place a graphic belo- the text box by pulling do-n the Insert pulldo-n menu( Choose +rom Clip art(
o Choose the Clip art that you -ould li1e to include in your slide byclic1ing on it( Select Copyby right clic1 on your mouse or +rom theditpull do-n menu(
*ac@)round8*
Deselect any elements on your slide( Right clic1 your mouse or go up to
-
8/11/2019 New Microsoft Office .Document.doc
104/105
and Choose Apply( This -ill a++ect the current slide only( Choose Apply
to alland this -ill a++ect all your slides(
Slide Transition8*
o Select Slide S(ow+rom the pull do-n menu(o Choose Slide Transition(
o Select a slide transition +rom the choices(o Choose on mouse clic@(
o ChooseApply(
Custom Animation8*
o Select the +irst text box(
o Select Slide S(ow +rom the pull do-n menu(o Choose Custom Animation(
o Select an entry animation and sound +rom the choices(o Choose O(
Aou can change the slide transition to a timer( Do all 1inds o+ e++ects to
any o+ your slides, graphics or text( These e++ects can transit to anyone
or all o+ your slides(
-
8/11/2019 New Microsoft Office .Document.doc
105/105
top related