new microsoft office .document.doc

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


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


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


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


5/105

PR!"#$

INFORMATION TECHNOLOGYTRAINING

MADE BY VIVEK SINGH

REG NO CRO0!"#00

BATCH NO.$ %t&'System 0(

INDE)


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 -


7/105


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.


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


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


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


12/105

-ecuri)* ,ea)ure aailable in %-;(RD allow )o u&e a +a&&word )o o+en or

odi,* a


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.


14/105

Mi4e* cell re"erencing6

:n )hi& e)hod we can


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.


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?


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.


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


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*


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


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*.


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


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


39/105

:) i& a &*&)e which &u++or)& and anage& )he linking o, in)er'rela)ed


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


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(


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(


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


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


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:#


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#


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#


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


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


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 ?


55/105

*# .AI" .RGR


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*


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


58/105

SC%RIT


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(

*


60/105

A# C"" R


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(


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


63/105

*#


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#


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


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


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#


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


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


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


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


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(


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#


74/105


75/105


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 ;


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(


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#


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


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


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(


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#


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


84/105

@EA


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(


86/105


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


88/105

'* Create ledger ;Security deposit ;


89/105

*, )a1e an entry o+ the transaction in a payment &oucher(


90/105

TH INTRNT

INTRO/%CTION


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


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(


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


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


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


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


97/105


98/105

Coa$ial Ca'le

It is a thic1 single -ire consisting a central copper -ire -hich is

surrounded by P&C insulation


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*


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(


101/105

o This screen prompts you to ma1e a selection +rom the +ollo-ing

o Select 'lan1 presentation( " dialogue box -ill appear(


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(


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


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(


105/105