หน่วยที่ 3 การจัดรูปแบบข้อมูล (โปรแกรม)

1n11°vh:n'U'U'Ubb~'U.:i1u (Worksheet) a1:i.n1rin1v1u~ 1'1.J u'U'U'1J eN'UeJ:IJ'1 b~el ~nwv11.:i1u btlu1't.J(111U)(1lt1'U1~1;'f.:,r, '1Jv.:i.:i1u l;'f1:1.J11t1(1lmbv1.:i-uv:1.J'1bb'1~bb~m1u1~l;'f1EJ.:i1:1.J 'IJ 'IJ ,J11;'fu1,i ' n11,11 bl;'f'UeJ'UeJ:1.Jff'1~ilr111:1.J'tl~ b'1'U uae btlu't.JwLEJ'll'U 'IJ \" ~1v1fum'lJ i-um'U.m t~E.Jn11~~1'lJ't.Jbbuu-uv:1'l.JJ'1 b'liu n11n1v1u~biu'1Jvu n11n1v1u~~ 1. icrn11~m'Ubb'U'U'Uel:IJ'1 6. n11f11vl'U~bi'U'1JeJ'U (Border) 'IJ 'IJ 7.. n11n1v1u~~bb'1~'11~mE.1 (Patterns) 8. n11~~1'Ubb'U'Uvl1E.I Autoformat 2. n11n1v1u~1'Ubb'LJ'LJ(,)TeJm11 (Font) 'IJ \" 3. n11n1v1u~1'Ubb'LJ'LJ(,)'Jb'1'1J (Number) 9. n11~~'1eJm'Ubb'U'Uv11E.lfl1i.:i Format Painter 'IJ 'IJ 4. n11n1v1u~1'Ubb'U'U1'U~bb'1~nm (Date/Time) 'IJ 5. n11~mwifvm1:1.J (Alignment) 1. ~~1'Ubb'U'U'Del:IJ'11vl 6. f11vl'U~bi'U'1JeJ'U (Border) 1vi 'IJ 'IJ 7. n1v1u~~bb'1~m~mE.1 (Patterns) 1vi 2. f11vl'U~1'Ubb'LJ'LJ(,)'J'eJn'lo/1 (Font) M 8. ~~1\"'Ubb'U'Uv11E.I AutoFormat 1vi' 'IJ 9. ~~'1eJm\"'Ubb'U'Uvl1E.lfl1i.:i Format Painter 1vi' 3. n1v1u~1'Ubb'LJ'LJ(,)'Jb'1'1J (Number) M 4. f11vl'U~;'Ubb'U'U1'U~bb'1~b1'11 (Date/Time) 1vi' 'IJ 5. -:5'~1WDeJf111:IJ (Alignment) M

15f11 ':i~m tlbb'U'U\"LJBlJffV111~ 3 ~B f11':i~~':i'Ubb'U'U<LJmm1~cJf11':ib1cJn1•foviu Home (Vl'W1bb':in) '\\J 'U \\J \\J f11':i~~':itl u'U'U\"LJBlJ~1~cJf11':ifl~n'trn bbmm1':i~~':itl u'U'U\"LJBlJ~1~cJm':i1-&'tllJr11i.:i Format ( ':i'Ubbuu) 'll 'U 'U \\J , '\\J hm~lJ'IJB.:J Cells (b61l~~) zj,:iij,fr'Ll\\,lB'Ll1'Llf11':i'U~D~~,:i,1 Book1 • Microsoft Excel -0 L-ln-mt --Page_L_ay;_out Formula, Data Review View --- -- 9'2_>__;::._c_,-{iJ -!3 • • /( ,.; • • ~ ~- ;;, Gene,ol • [fili Condltlonal formamn; • 9~1nurt• E ... ~ 16 l!1J • % • li!l formau, Tablt • ? Dtltte • Iii • Sort & find & Putt B I ll • • ~ • .L\\ • II: • :9 ~ ii£ ~- ~ !,S Cel!Stylt< • t£j format • 0. • flKtr • Selta • Oipboard r., font r; Alionmtnt r; Nurrtbtr r; Stylts Cells nb'U'Llf11':i~~-rra m 1lJB ~1.:i~1 clbb~~':i1~ b~1~?1 ~ ~a f11':i1-&'bfl~a.:iifou'Ll bbtiu~uu B'U 1un~'lJVl'W1 u':in ' zj,:iiJn~lJ~Bcl'U':i~nB'U~1cl bb'U'UBn'\\~';i f11';i~~bb'U1 ~1b~'IJ ~n°clru~ b61l~~ bb~~f11':ibbm'IJ b~B'Vl1f11':ib~Bn 'b61l~ ~Vl~B<LJm.J~~ ~a.:i f11 ':i~~ ':i'U uuu bb~1 1~fl~ n b~B n m':i~mtl uuuuu~uu B'Ll~1~ uu.:iVllJ1~WJ'IJa.:i '\\J 'll 'll 'U ':itl uuuHbb~1mlJ~~e1.:im':i '\\J f11':i~~~'Ubb'U'U1~cJf11':ifl~n'll11b~Bnr11i.:i Format Cells ~~'U':i1n!J Dialog Box bb~~lJbb'Vl'U1~b~Bn 1-&'.:i1'U1~~.:JVllJ~ 6 bb'Vl'U 4 --c..r...:, ~.,.... .IIUtrt... ,. ,..,_O,r, .....,\"\"' C4attnU ;,,,. \" l'r­ ......-11&: TM c....... 9 ~ Insert Com,ncnc t..-Ctlls... ~ Pict froM Otop..ctown Urt... Octlrl tt\"lffi f... ttypt,Ji,nk. .. 15

n1'af11'Vl'U \\Pl 'a'U u'U'U b6116l~ 'IJ nT~'UeJ'Ll\"UeJ~'1'1-'.l1m61!'1~~1~1'a'1 f11'Vl'Ll \\?l'Vl~B~\\?l'aU uuu1~nu b61l'1 ~J,:i'VI~ \\?l'Vl~B ~m,J uuu b61l'1~ \" \"\" bb~'1 ~ b61l'1'11~ihu u'U'U bb(,l n~1,:i n'Llm~~n~ru~'LJB-'.l\"VB~'1 bdeiii n11 b~B n'1i1,:i b61l'1 ~ bbi1 ~1m'a'1 n1V1t1\\?l \"\" 'au u'U'U b61l'1'11~\\?lt11if11i,:i~1'U'abbm~1~~\\?l'Vl~1\\?l'Vllim1~~1n b~t1r11i,:i Home zj,:iij bfl~ei,:iijeif\\'1i,:i \" \"\" ~'lJ~;j1'lJ1'Um1~m\"ubb'U'U1~ ti'1~ei,:im'an1V1'U\\?l'a1t1'1~bBt1\\?l'LJB-'.lr11i,:im'a~\\?11\"Ubb'U'Ub61l'1~b~~b~~ 'Yl11~~,:it1 ,rt Pag• Layout Formulas Data Rtview Vi•w Calibri ,, .. A\",: l!!o-~ ~- . / ~ Wrap Ttxl Gtneral Cell Siz~ ==•=-B I ]l • EE. ~-A· ~~ Merge & Center • $ •% t .....oo +.o.oo :[ Row J:jeight... Font Ii Ahgnm•nt Ii Number Ii !utoFit Row H•ight fonna!Cels r::] Column Width ... L-. .______________ ......J AutoFjt Column Width Q•lautt Width ... ~~ V'ISl>ib\"\\y Hid• & J.!nhid• Ofganin! Sllem B•nam• Shut .Mo-we or Copy Shut .. , !ab Color Protecti on froted Shttt... lock c,11 Format C~lls ... j Cut - £opy faste -----Paste ~pecial ... jnmt. .. Qtltte ... Cl•ar Cont•nts Filt~r S.Qrt ~ Insert Comment format Cells ... Pie~ From Drop-down List ... Name a Range ... J:!yp erH n k...

i Cut J;opy Paste Options: - [I] Paste ~pecial... Jnsert . Qel<te . Clear Contents Filt_tr S.9.rt Insert Comment format Cells... ~ Pie!; From Drop-down list... Define Nime... Hyperljnk... 4. fl~tb.J~~~~ Ctrl + 1 Vl~B Ctrl + Shift + F ' '1~'\\J11nnV1i!1~1..:inTr~·~1'\\Jbb'U'U (Format Cells) 1~\\~am'\\Jbb'U'U~bbVl'U 6-1 'U 'U 1. Number (;1b~\"IJ) 16tlb'Wfl11~~fl11fl'U;,m,'ll 1 b~btl'W '\\Jm~~r'Un-if~B-.'.lfl11 Formate lls ? .. ~, \" NuTiber I Alionment I Font I eorc1er I fill I Protectien I !;_a~ : Sample Gener al EJBQecinalplaces: ,- 0 !.!Se 1000 Sep,,r a1or (.) Currency !!!eoative rurber s: Accoun ting I Date Tm< 1234.10 Percentage (1234.10) fraction (1234.10) Scientific iext Spe cial custDm ~ - !lunber is used ftir general asplay of rurber s. Currency and Accoun ting ~ specialized fonna tting for ioonetary value. I I: IOK Cancel

2. Alignment (n11~~bb'U'J) b6Ub'U j Genera v]j Ir.dent: 1fl1'a~~ fl1,n'Uielfl'J1l.JVl~e)(,]';J b~'U '!XmJ'l.'U\\9l1 uVltl-:i 'U ~ffioff1,1ei-:im, 'U Jao-~'\"''\"'' H0 D ius,rv cisbi>ui.<! Ttxtcontrol 01Yraptoxt DS!rrtroflt 0!!1.0rQe oo& =8!•xtdtoction: lccntoxt 3. F o n t ( u 'U u el fl ~ 'a ) Fonnat Cells I'.:) ? .. fl 1 , fl 1 VI 'U ~ t,l1 iffl ~, b 'U i 1J u 'U 'U ~ 1 -:J 1 - I Al;m,en t II Fent 11 aor.... I Ft IPr•\"*\"I ffiil,)eJ-:Jfl1'a _.,_Eont: ·, EJB\"f91tst-,tt,:itt: I talc 'U Clibri u 4. Bo rd e r ( b 6\" 'U''I.I eJ u) CMnbtla--· y \"y ., ;,, fl1,fl1Vl'U~b«'U'Uel'Ub'Ui1J~'U'U~1'11 AdoboCd>nPro ffioff1,1ei-:im, AdobeCHOnProeoid AdoboC.V......~ 'V l.r,dorfno : HI\"\"°'' i\"l !l<>nNlfont Prr.lew 1- Elftas Osot.omuo11 f; dAaBbC<YyZZ os.w- 0~ Tl'itil a TrueType ftint. lhe same-fontwl Mused on bod1 'fOU\" Pfflttt' Mid YIM' to\"fe'1 . ~~ Fonnat Cells .• 11111.111 J,urber I Al;m,en t I Fent II eordor 11i......:F..t::..._.1..P:.r:.o.:.1=K110n\"-'----\"\"--- I \"'\"\"\"\"\"' H [ml , r ~ • l [giJ [!SJ

5. Fill (n1'H~~) 1m'l.!f111~flbb~.:J ~Format Cells ,_ bb~'l.1.:11'\\.! (Worksheet) 1~n'11~'11c.l~1il~ m.ffli1el.:im1 Ir+..mbe, Al!rfflent I Font I 8ordor l[JLJIProt«0on [~ 'IJ ~1;o1or, Pttt!m Color: B r No Color II I AuUxna\"< o•o••••••• fa11<mStvte, o•••••••••••••••••••••••D•D•••••D••D••••D•••D••D••D••E••l I I I [ IFJ Effe<ts,,, 11«• Colon.. , 6. Protection (f11'a'UeHf1'U) 1m'l.! S4n'4'i< .nf111U el .:i fl'U uae fo ~1 f111il'U '1 el~ c.11~flU'LJeli'lIJ '1 I 1mb~'l.!.:J1'U (Worksheet) ,_! L ~~ Format~s r+..mbe, I Al!rfflent -y Font I Border I Ft l!Prot«0on !I ~Lodcod 0~ Loddngctls or t'icinQc fom'U,uhas no effect 1,1'\\tl you protect the woo::shett Gt,e'tiew tab, OVinQ,es group, Prott<tShee t button). ~~ n.11a~~~tj,b1t1'1J>\"Y].~}~t:Jnru~~~Dl~j'.Jji~M~ ~<2.UU'j)at~ (~~tj,iJ,u. m) 1'uD.6ljh~~ ~elfs1 ~6l!~6l-~} f111~~1'UbbUU\\i11c.lf1111.ffuiif11i.:inm1b~tlf11i~bbviu Home ('Vl'U1bb1n) bb'1:::f1~nb~eln~Uilf11i.:i 'IJ ' ' Format (~'Ubl'U'U) '1:::ij1-11i.:i~eJc.l1~b~eJf1 Format Cells (f11'5~(;1~'Ubl'U'Ub61!'1~) '1:::'U11f1{l Dialog Box 1~ b~eln1~c.1nbbviu1~b~eln1.ff.:11'\\.!L\\i1~.:J'Vlil~ 6 bbvi'U b\"1!'\\.!b~c.l1flU1fif111f1~mm~'lJ11

flT~~fl bb\\91-:J\\9l1eJfl'Nd1'Lib6116'l~ I6111Jljfl b'U~cl'U1um:u~n'Nru~\\911-:J ~0in1V1'U~zj,:i611:JJ1jflfll'Vl'U~J'U bb'U'U'UeJ-:J\\9l1eJfl'Nj1vlJ-:i'<illflbbVh.J Home (Vli!lbbjfl) Vl~eJ'<illflflljfl~fl'U11 bb6'l~'<illflU:Ur11i-:i Format (j'LJbb'U'U) ' '\\J '<i1-:i-w:u-wie1:u6'lm:u~1d1-:i\\9le11uffi~cJn1V1'U~1vf '\\J 1. ~~~1ie1 \"jlcJzjelbbi:.J'Uflbfl~eJ-:JcJ'U~\" 1vfe1~~-:inm-:ir1e1~:utl Al-Cl '\\J 2. \"zjeJ-'U1:U61n6'l\" \"~lbb'Vl'U-:i\" uae \"b~'Ub~eJ'U\" 1vfe1~~-:inm-:ib6116'l~ ' '\\J 3. 'U'Ul~'Ue)-:J(9)1eJfl'Njb'Vllfl'U 18 4. ie1:u6'l~1mj1-:Jbb61~-:i b'U'U\\9l1Vl'U1 'IJ 5. j'LJbb'U'U\\9l1eJfl'Njffiifimb'U'U BrowalliaUPC '\\J A 8 C 1 'ntit!mb~un A~uslm~/ 2 ~e:i-ina.ian~ \"' ., 20000 'I 12000 ~1~U1sl1U 3 u1tiamJe:i.,, ~1.,,hsl1aJ i1.,'j51ft)aJ 4 u1tJu~~1 a.i:~Ke:iu ... \"a'l..!~el'l..!fl1'a'V11 1. b~eJflfl6l:Ub6116'l~ Al:Cl '<il~bfi~bbfl'U?f r1~n~:uf\\'1i-:i Merge & Center (i:.J611'Ub\"116'l~) j! Cut BtowalliaUPC • 16 • A. ,... • • • ~· ~ W ra pTtxt AB C I_ Copy· B I JI • ':E. il, ·I:!,.. lie• ,a ~ fie l!jMtrt&.Ctnttr. ~ TIU~llUN\\4nL~ll~U\\4/ I Pa:'' .:I Format Pa.int\" Font ~ AJ/gnmtnt r. 2 ~ll-\\41a.la'T}Q 1l141,io14 20000 I Clipboard IJ;. na~ourtllnin1oJO\\JII ~hU~\\4.3 12000 Al •( II A ' B 'c'o EF G 3 141uaa.itlo~ .n~t.na.i 1-11~\\41~1\\4 1 !riutowi11m~u11if 4 141utl~m a.i:fi'lfo14 'liwrloa.i 2 t0.1111JRT)A *1~1'>~ 1311141011 3 111uRul.Jw ~\"Mhnu 1'11'>1fm11 20000 4 111uU,1n ue:,r.11 ,rw!lou 12000

2. b~eJflfl~i!b61l\"1~ A2:C2 lil~bfl{;lbbtl'U~ r1~n~iir11i-1 Center ('<iJ\\;JM-inm-i) bb\"1~ Middle Align ('<il\\;l !i ~1-inm-i) ~-im~ BrowalliaUPC Clipboard • & • A · i~ i:.. ~· \\ A2 r:. -, Ali;nment r. A /,c Center Center text. 1 f--2-\"\"\"\"\"--:Au--\\41-3.J~-n·:~.----G-i1Lw-1,l-· ----· 3 irn.1~3.11.JtJ,3 m,3\\'1,313.1 vi1' '\\lllt1,31\\4 20000 4 '41 t.1u~~1 3J:::~•1fol4 'l\\'1,3'1ie13.1 12000 is'U'Ll1\\;lb'Vl1n'U BrowalliaUPC B I !! • ~lo'~~ ~· Alignment Clipboard r. Font 10 • C 11 tlil,~ 20000 12000 Al 12 1 l;::::===============A=======, =====~1146 D A 1 '51tl'1ielL1'-lil, 181'. 20~ 2 22 24 3 ii,1t1~3J1.la.J m.Jh.J13J 26 28 36 48 C 5 72 B 20000 12000 2 3 u-imn.11.Ja,3 ~'HL\"1-313J ~1Yttt1,31i1, 4 irn.1mm ll::§•Eat1. 'Ji1,3-no3.1

4. b~elflfl~lJ'Vel~~~-:Jbb~ A1:C2 ~~btlvlbbti'U~ bb~~fl~fl~~lJF11i-:i Bold ((111Vl'tJ1) Vl~elflvl bbU'LI'Vlm~ Ctrl+B BrowalliaUPC Clipboard fi Font fi Alignment Al ... A CD C 1 AB 20000 1 12000 1-2-:1---ia--u-1l!~-n·-a ---ii1-u,--,ii.i--, -L~-UL-~a-u· 2 3 u1t1n'll1.la-, ~1-,\\,1--,1\" i'1~it'1--,1u 20000 3 irn.nn.11.lchl m\"h,rn.1 'i1Viu1\"1u 4 U1E.Jl.IT~1 ll!aoffau ,t1-,trlal! 12000 4 u1t1mm 11::atffau -d1\"'rltl\" nTafl1Vl'Wv1';i'Ubb'LJ'U(ll'JeJfl~';ibv1cJfl1';ib\"Ub~.J161 bb~~1-u'ulJf\\'1i-:i Format (';i'Ubb'U'U) b'Wfl~lJ\"I.JM Cells 'U Cl cu , (b611~cl') ?f1lJ1';itlfl1Vl'Uv11111~-:iii 1. fl~flb~elflb6/l~J~~el-:Jfl1'afl1Vl'Wv1';i'Ubb'U'LJ(ll\"Je)fl~';j 'IJ 2. fl~fl~bb'Vl'U Home (Vl1J1bb';ifl) 2.1 b~elf1UlJF11i-:i Format (';i'Ubb'U'U) ~~i1F11i-:i~eicJh~'L~ein Format Cells ... ('1v1TUbb'U'Ub6/l~J) , 'V . 'V A BC !/;(E AutoSum • 4 Ii] Fill T Sort & Filter T a Clear T t~1,f,t~m... CellS-rze ![ Row .!:ieight ... 20000 AutoFit Row Height 12000 ri Column Width ... AutoFjt Column Width Qefault Width ... V-isibility Hide & JJ.nhide Organize Sheets .Bename Sheet ,Move or Copy Sheet... !ab Color • Protecti on frotect Sheet ... lock Cell

2.2 fl~fl61J11b~e:Jflrl1i-:i Format Cells ... (~1i1~'l.Jbb'UUb61l'1~) 'U 2.3 flli1'Ullfl~~li1 Ctrl + 1 ' AB ilei-m~~ll U1!.l~UUD~ ~1~,..-~~~ -c~------~~ 3 ct1I ~opy 4 U1!.l~m U::a'Jl'~ ~ Paste Options: ' 5 Lil Paste ~pedal... 6 jnsert ... 7 Qelete ... 8 Clear Contents 9 Filt,tr S2,rt 10 Insert Comment 11 Format Cells... I'-. tra:­12 Pie! From Drop-down 13 Define Nime ... Hyp erljnk ... 14 [FannNumber Alignment <--CB.co..r.;d._e_r .___Fi_m_..__;___..;..-'----W-------, F;=o.__n t: ~~r~ts_ty~l e_: __,~;=.z_e_: ---~ Bold 18 BrowalliaUPC \" Regular '.Jr Bradley Hand ITC Italic '.Jr Britannic Bold Mt~ Broadway Broadway BT Bold Italic BrowalliaNew G'.]Automatic 0 !ionnal font E~cts Preview d 0 Stri~throug h ~ AaBbCcYyZz 0Su~script 0Su12.script This is a TrueType font. 'fl'\\e same font v,.;H be used on both your printer and your screen. _,! I\"--O_K Cancel

Font : f11'\\ll'U~'j\"tJbb'l.J'U\"llel.:J~1Bfl~'j\" OJ Font style : f11'\\ll'LI~lfl~W~\"llel.:J~1Bfl~'j\"tJ'j\"~flel'\\J~1tJ 0 Regular ~1Bfl~'j\"tJfl~ 0 Italic ~1bBtJ.:J 0 Bold ~1'\\ll'U1 0 Bold Italic ~1'\\ll'LI1bb~~b5ti.:i C, Size : f11'\\ll'U~\"ll'U1~\"llel.:J~1Bfl~'j\" 0 Underline : f11'\\ll'U~fl1'j\";~b~'LI11?1 6) Color : f11'\\ll'U~~~1Bfl~'j\" (t Effects : f11'\\ll'LI~lfl~ru~~bl31~\"llel.:J~1Bfl~'j\"tJ'j\"~flel'U~1tl 0 Strikethrough ;~b~'Uflm.:J~1Bfl~'j\" I ...... I 0 Superscript ~1tlfl I .......,,,,. I 0 Subscript ~1~eJtJ I._.,,,,. I 0 Preview bb61~.:J~1el~1.:J'Ylf11'\\ll'U~ 4. b~eln1vr'Limtlbb'U'U~15n~'j\"b~tJ'U{elmb~1fl~n~tllJ OK OJ , 1'Ufl1'j\"f11'\\ll'U~'OjJ\"tJ u'\\J'\\J~1 b~\"lli!'U611lJ1'j\"tl f11'\\ll'U~1~J.:J'11flbb'Vl'IJ Home (Vl1.J1 bb'j\"fl) '\\ll~elfl1'j\"fl~fl\"ll11 bb~~'11fltllJ1-11i.:i Format ('j\"tJbb'U'U) ~.:id , OJ 'Yiufl11fl1'\\ll'W~J'Llbb'IJ'U~'Jb6l°llb~flb°Ubb Home (Vl'U1 usn) i1-&'U1>1el'U1'Ufl1'j\"t15u~~,:i,Q 1. fl~ m~ el m61l~~~l?lel.:J fl1'j\"f11Vl'U~'j\"tJ uuu~1 b~\"ll ~ • % , ~,;8 .~ 611 .:i '1 ~ el ~1 'U fl~ lJ \"lJ el .:i OJ OJ , vi2. fl~ fl~ 'j\" tJhi fl el 'LI '\\J 'LI u '\\J Home ( '\\11 'W 1 u 'j\" fl) OJ Number b\"U'U fl~fl~bfl~el.:J'\\lllJltJ , (Comma) '<D1'LI1'Ub1'U'1~tJ11flnbfl~el.:JV1mmmmflbb~~'1~'Vll31'WtllJ 2 6../ , , rA 8 C L. . A 8 ·- ~ 1 il1~\"1' J 59000 2h1- \\113-lana C 15000 1 18000 i~m~t1\\I 2 1 U1t.l'lf1m~ a,rUfl'} 17000 ,2 1 ,rn.1'lf1m, m1't.fl'} 59,000.00 3 2 u1uiim L'il~~t'il I 15,000.00 .4 3 U1-l1itf!1 LL'i\"l~a-11-l 3 2 u1u1im ~'il~iyt'il .I 18,000.00 I5 4 ua-.ti°1Hu 11.ha.11.J~ 4 3 U1-l1itfl1 LL'i\"l-la-11-l 17,000.00 5 4 ua-.ti°1Hu Ltha.n.J~

tl1'Hl1'Vi'W~':i'U u uu (91'J b6'1\"ll b~tl n1':ib°ti b1!1lil bb6'1~b°tl'U11 fl1i~ Format ( ':i'U u uu) 'IJ ' 'IJ t111u~u~~~<Q 1. fl~m~Bm61l6'1~~~mm1n1V1'LI~1ubb'U'U~1b6'1\"1J 'lJ 2. fl~tlbl.116'1\"1J11b~'Eltlfl1i~ Format Cells ... (~~1tlbb'U'Ub61l6'1~) 'lJ d ~\".Ito CV 3. fl6'1tl'Vlbb'Vl'U Number (mb6'1\"1J) 4. fl1'Vi'LI~1tlbb'U'lWl1~~mt111bb6'1~fl~tl~1.'.h.J OK 'lJ ' FormatCells ~ ? .. i1urb<r IAqrnen t I Font I Border I Fl IProlffllDni I !;,,tegory: ,. San1)le ' Geno,ai 59,000 .00 CUrency LIDQecimal pl-== AcOUlti'lg Dote .01µ WOO Separ ator~) Tme Percen!a!je f!e9allv• runbors: Fraction Scientific 1,234.10 Text ·1,234 .10 Special -1,234.10 Custom - C /.. B w\"1~a\" 59,000 I a1~1J ila- \"1iiam• 1 15,000 2 1 ll.1 tl'!f1Yl~ ff'1ll.9'l'i 18,0' 00 Jlurb<r is used for general display of nunbors. CUrrency and Accou,ti'lg offer spoclalizod formatting for monetary viwe. 13 2 ll.1v1i.i 1.i~qih 17,000 I I: IOK Cancel 4 3 ll.1,:11'4911 ui.:i.n1.:, 5 4 u,d1w14 1l.l'i1Jl.l~ 11-J'llt111tl'!'U btl~tl'U~tlbb'U'U\"IJeJ,:jfl11bb?1~-:i1'LI~bb6'1~b16'111Vl~ mim1tl~u~~,:j~e) t111fl1'Vi'W~J'UbbUU1'W~ (Date) ?11l.111t1tl~u~1~~-:i<Q 1. fl~flb~€lflb61l'1~v1~€l-:lf11';jli)~f11Vl'U~';i'\\Jbb'\\J'U1'Uv1 'lJ 2. fl~t1'1i11b~'Elt1rhi-:i Format Cells ... (~~1tlbb'U'Ub61l6'1~) 'lJ 3. fl~tl~bb'Vl'U Number (~1b6'1\"1J) bb6'1~b~'Eltl Date (1'W~) 1'LI\"lim Category: (tl1~bf1'Vl) 4. b~'Eltl~tl u'U'\\J\"IJ'El-:i1'U~v161JB-:i Type:

6. ?!1l111fl~(9)1e:J~1..:J'Ue:J..:Jfl11bb?l~..:i~rivi'lie:i.:i Sample 7. bdm?t~~b~cJtJfe:icJm~\\918..:Jfl11bblK1r1~n~tl~ OK , .. A ' ~ 6 Bl Forma t Cells V 7 8 Cuj ,_. ~,,, Al!,wne, ,Gene-al -Font I B«der Fi IProt«tion 9 i;opy 25/12/25S8 10 Paste Options: Cu-rency type: ~ 11 12 18 l'i~l'l~n1l!U 25 Insert... -,.Aa:ou,tino li/03/25+1 25Apnl 201 Qeltte ... ~«'-\\U1.·d\"l P<rcentage 1'1,1)3/25+113:30 •• -Fr6Clian 1'1,1)3/25+11:30 PM Seion tific I~~::{::::•d./n/dtt •n:no \\I. Text local e (location): -CU.tom Clear Contents l'Thal -~ Fitttr ill SRrt CAlen<lo< type: l1fi!1;f;$ i j 0 Input dates\"\"\"'~ to sdectod calendar ~ Insert Comment O.i. r.nn.tsclsi,loydai.and titteserialrurt>e,-s•sdai.v..,._. o.i. r.nn.ts lhotbegi,withM format Ctlls... ~ M-teisk (\") respond to changes il r~da~ and tineRtli'los that are ,peo fied for the QPttatng sys-ten . Formats without M asteisk are not a~by ope,aong Sys:tffll settt1gs. Pict From Orop-down list. .. Define N§.mt ... Hyptrljnk. .. ~.-CNce f11'Hl1'Vl'U~J'Ubb'U'Ub16'11 (Time) ?!1l111fl'U~'IJ~b~~..:id 1. r1~m~e:im61fr1J~\\9le:i..:irn1~~n1V1'UmtJbb'UtJb1m 'U 2. r1~n-u11b~e:inr11i.:i Format Cells ... (i~1'Ubb'U'Ub61frtJ) 'U 3. fl~f1~bb'Vl'U Number ((9)1brt'U) bbrt~b~e:in Time (b16'11) 1'!.J'lie:i..:i Category: ('UWb.fl'Vl) 4. b~e:Jf1J'Ubb'U'U'Ue:J..:Jb1m~'lie:i..:i Type : 5. b~e:Jm'Ubb'U'U'Ue:J..:Jb1mm~vfe:i..:i~'U ijJ..:ibb'U'UL'Vlmbrt~bb'U'U?f1nri~'lie:i..:i Locale (location) : 'U . 6. ?!1l111fl~(9)1e:J~1..:J'Ue:J..:Jfl11bb?l~..:i~rivi'lie:i..:i Sample 7. bdm?t~~b~cJtJ{e:im,n~\\918..:Jfl11bblK1r1~n~tl~ OK ..'\"'' I-1 ' f 2 3 Format Cells V ,. -~._., A11,wne,,~t 1e\";c1er1Fff~ .G..e.n.e..-.a,l 20:10:33 B Cunncy Accou, \"\"' o.i. !YPe: -P<r- e:no:ctrtF,,11 ~ •n:no:d.4' Fr action an:no\\1, - Seion1ffic a:noPM Toxt 1:30:SSPM 13:30:55 Custom l<><•~~m1:_ [- AI B i-·=-nne ftinnats dsoCly date rdirne ser1til rurber s M date vM.Jes . nne ftinnats that be;n with an 25/12/2014 20:10 25/12/2014 8:10 PM ~ M resocn:Ito di.!nges- in regioneldate and tine settings that lire soecimtfor the ~ Mthcut ..,....,.. aronotofforad byaoor~tinQsystem sot1!ngs . 7:25 8:10 PM - 16:25:30 ~[ Concol ]

vh.Jfl1\"j~m1-:iie:ir111ii1m61!'1~?11l.11'H1'V111~~tJfl1\"j1·ffbb Home (V11J1bm1) fl1\"j1.ffbmibb'1~fl1\"j1-fftl'ii r11i-:i Format (\"jDbb'IJ'U) ~-:i\\1 fl1\"j~~11-\":iie:ir111ii1~tJ16tlbb'Vl'\\J Home (V11J1bb\"jn) 1,.mzjii61Je:i-:J Alignment (fl1\"j~~bbtn) ?11l.J1\"jt1D{i1J~ 1. ri~m~e:im61!'1~~~e:i-:im\"jf11Vl'U~\"jDbb'IJ'U \" 2. ri~n~bb'Vl'U Home (V11J1bb\"jn) r1~m~e:innzjiir11i-:i Alignment (fl1\"j~~bb'U1) D\"j~ne:iu~1tJ \"j1tJ'1~ be\"\")tl~~.,-:J'\"U,\", • Top Align (~~:u~~1'U'IJ'U) • Center (~-:inm-:i) • Middle Align (~~m-:inm-:i) ! ~· )Orientation (mrruu'U1) .~ 'ijf Decrease Indent ('1~fl1\"jbtJB-:J) tE::r ., ., =~Wrap Text Wrap Text (\\11~61J€lfl11il) ' Merge & Center • Merge & Center (e.J?f1'Ubb'1~~~n-:inm-:i)

fl1'j~l?l'\"J1-:J'Velrl'J11l11?lclfl1'jl'Ub111i bb~~tl11r11i-:i Format ('jUbbUU) ~11J1'jtJUD'LJ~1~1il-:id ' ~ ;J 1. fl~nb~elfW/j~~~~e)\\)fl1'jfl1Vi'U\\?l'~jUbblJlJfl1'j~l?l'\"J1-:J 2. fl~fl61J'\"J1b~einr\\'1i-:i Format Cells ... (~m~ubbtJlJb61l~~) 3. fl~fl~bb'VllJ Alignment (fl1'j~l?l\\,11bb'Vi'W-:J) -tol:Toxt ........... t cmH Inden t, •·. • . jc,,, te- 3 ..T•xt·~· A8 C D EF G :imical : ~ 2 ll'Hfu 'fwdlewTI hhtA'1 ;lnn1.t 11R1Milltl ;lnn1.ti~1.t ieo,uxn 3 111/2558 Mn· 4 z 111/2558 1iflau 80 3.25 260.00 Mbfycislrtlub,d 5 3 111/2558 1loifl 4 450.00 1,800.00 6 4 211/2558 ,o~l\\f1 8 129.00 1,032.00 T6ta>ntrol 7 5 21112558 1lri'n1TI 5 245.00 1,225.00 Ow,..,..., 2 120.00 240.00 Ost-r>t tofit· 0!:!<fllo cds R;gl,t-tD-left a!ext ci'Ktion : jeontoxt U'j~ neit1~1 cl 'j1 cl~~ bB cl l?llil-:id Text alignment (fl1'j~\\?l\\,11bb'Vi'Ll-:J'Velrl'J11J) 0 Horizontal fl1'j~l?l\\,11bb'Vi'W-:Jl'Ubb'U'\"J'Uel'U 0 Vertical fl1'j~\\?l\\,11bb'Vi'W-:Jl'Ubb'U'\"J~-:J 0' Text control (\\,l'\"Jrl'JlJfl:!..l'VeJFn11l) ' Wrap text \\,l\\?l'Velrl'J11J 0 Shrink to fit ~l?l'VeJr111111~vrn~ 0 Merge cells e.J~1'Ub'@~ ' Right-to-left (:U1fl61l111ui1cl) 0 Text direction,,(vil2l'V11~'1Jel~'UelFn11J) 0 Context \\?111lb'Llel'Vi1 0 Left-to-Right :u1ni1cl1U61J'\"J1 0 Right-to-Left :U1fl61l'\"J11ui1cl Orientation (fl1'j'\"J1-:Jbb'U'\"J'Velrl'J11J)

fl1 'jfl1'Vl'Uvi b~'U'lJ8'U'Vl~eW l1'j1.:J~V111 ~'V11.:J1'Llb~~1 tl bb6'1~?1~vi1 fl~'Ll1vi tl bO'W1~ fl1 'je)1.:J ~.:J?l1:1.J1'jtl'W:W'W 8 8 fl b ~ fl1 'jfl1'Vl'Llvi b~'Ll'll8'U'Vl~8\\?11'j1.:J1vitJvi'11~~.:i~1m bviu Home (Vl'U1bb'jfl) 1'Lln~w-11i.:i'll8.:J Font (u'U'U ' elfl~'j) 'Vl~8~1flfl1'jfl~fl'll11 bb6'1~~1flt'h.Jr11i.:i Format ('~jtfauu) viufl1'jfl1'Vl'L!Ylb61\\!'tlel'Ubvll:lb\"tlbb Home ('Vl'U1bb1fl) i1~.:id J~;;Hfl1'jfl1'Vl'Uvib~'Ll'll8'U'V11L~vitlfl~fl~bbvi'U Home ('Vl'U1bb'jfl) b~8flflzj:wr11i.:i Font (bb'U'Uelfl~'j) bb6'1~fl~fl~~:w Button Borders ~~U'j1fl!Jflzj:wr11i.:ib~'Ll'll8'U1~b~8fl~.:id Borders 'lh~fl8'U~1l:IU•:Wb8flel'Ll ~.:id r-71 NoBorder L2.I (bJij b~'Ll'lJ8'U) Bottom Border ( fl1'Vl'Uvi b~'U'lJ8'U ~1'Ll~1.:J b61l6'1J) Left Border I Top and Thick Bottom Border rr;:;i 1 ~ (fl1'Vl'Llvi b~'U'lJ8'U~1'Ll'U'Llb61l6'1J u'U'U'U1.:J L£::J (fl1'Vl'Llvi b~'Ll'lJ8'U ~1t1i1 tl b61l6'1J) . un~bb6'1~~1'Ll~1.:i b61l6'1JbbuuV1t11) r::;i Right Border r,:;i Outside Borders L2J ( fl1'Vl'Llvi b~'Ll'lJ 8'\\J ~1'Ll'lJ11 b61l6'1J) lH:!j (fl1V1t1vi b~'Ll'll8'U~8m8u b61l6'1Juuuine) Bottom Double Border (fl1'Vl'Llvi b~'Ll'lJ 8'\\J ~1'Ll~ 1-:J b61l6'1J u'U'U b~'Ll ~~ Thick Bottom Border m I Thick Box Border Fl J(fl1'Vl'Llvi b~'Ll'lJ 8'\\J ~1'Ll~ 1-:J b61l6'1 b'U'Llbb'U'U t (fl1'Vl'Llvi b~'Ll'lJ8'U~8m8'U b61l6'1J u'U'U'Vl'Ll1) ~ 'Vl'Ll1) D Top Border J)(fl1'Vl'Ll vi b~'Ll'lJ 8'\\J ~1 u'U'Ll b6116'1

Draw Borders tJ1~ne:iu~1t1tl:w1e:il'!eJ'U ~~,d ' Draw Border ~Draw Border Grid (m111 ~ fl1'Vl'U~ bimmu\"ll eM b\"lfft~beN) C_j(n1111~bi'Ll\"llelU\"1Jel~b6/fft~) Erase Border !enlMore Borders (msau bi'Ll\"llelU\"llel~ b\"/fft~bel~) ~(n11fl1'Vl'U~bi'U\"llelUb~&Jb~1J) Line Color ( n 11 fl1'Vl'Ll ~ ~ bbft ~ n 11fl1'Vl'Ll ~ 1,., tJ uu u \"lleM bi'Ll\"lleJUbeN) n:51 Top Border L=J til(fl1'Vl'U~ bi'U\"llau 1'UU'Ub6/fft~) fl1i'f11'Vi'Wmt9'1.J\"1JeJUb~tlfl1i'b°tib:l.J161 ~11J11titJ5u~11il~~,d 1. Fl~ n b~tl n ' ~eJ~ n11vr~Bn~1J ' n1~'1~ fl1iru~ b~'t.J6VeJu ' b6l.f~~vi b6l.1'1Jvi~eJ~ 2. fl~fl\"ll'J1b~eJnfi'1i~ Format Cells ... ({~1,.,UbbUUb6/fft~) 3. fl~fl~bbviu Border (bi'Ll\"lleJU) fl1'Vl'U~bi'U\"lleJUm&J\\9leJ~n11 Border .. 0 ,., bftelfln1'Vl'U~b~'U\"llelU Line Style b~el m,.,tJ bbUU\"llel~ bi'U\"llelU Presets b~einfl1'V!'U~~1~~~H Color b~e)flfl1'Vl'U~ITTinrni'U\"llelU 4. fl~fl~'U&J OK ' AB C FG .A B D 2 du\\'u 'Swillawff hhll1 11111111 11t11111,l111 11111111111! 6111u' 1'lwlwl1I 3 I 11112.558 Mn· 80 3.25 260.00 2 - -- -4 2 111/2558 ,i,im., 3 11112558 Mn· 4 450.00 1,800.00 4 2 111/2558 MDU 3,0~11r,5 1loi~ 111/2558 - 8 129.00 1,032.00 ,l&h5 111/2558 - •6 21112558 Jf>.1111'1 6 4 21112558 -- 5 245.00 1,225.00 7 s 21112558 llln1w 7 5 2/1/2558 tlifnln - - 8 Jnstrt... Qtittt­ 2 120.00 240.00 Our(oI]ltnts 10 lnstrtComment 11 12 t'i' forma t Cells ... 13 14 Plc:t From Drop.down Ust•• Define N1me.N I,\\ HyptOjnk...

CA 8 r 2 ·················· ···················· --··········· ··················· ··············· 3 1/1/2558 'hi'\\n' 80 3.25 260.00 ·········· ---····-·········· ····················· ············· ··················· ················ 42 4 450.00 1,800.00 -··ltll:~bardel'itf,tc.-ibtai:cl!,::lbT~N;rHot:s.~daO'.. orN~ 5 . s 11112558 r!-evil 8 129.00 1,032.00 ·················· --·················· ············· .;. .. ··············· rn.mr,6 4 :?ll.f2558 5 245.00 1,225.00 utfI,,7 5 2ttt2558 .,,i 120.00 240.00 b'Um-an 1Vl'U~~ bb\"~\"1 ~\" 1 tlb~ ntJ b61l\"~Vllei n~m61l\"~'1'U ?11~ 1-a~vr11~~-:Jlil1 nuVltJ Home ' (Vl°IJ1bb'af1) bb\"~lil1flfl1'arl~fl\"IJ11 Vl~elfl1'ab~elfl~tl~1-11i-:i Format Cells ... (~~<atlbbtJtJb61l\"~) \\ii'-:i'l1 '\" fl1'afl1Vl'U~~bb\"~m~mtJ1~tJfl1'ab'tlbbVltJ Home (V1°1J1bb<afl) i1.fr'U~el'Ub'Ufl1<atl~1J~ 2 lfi \\ii'-:i'l1 15\\li 1 fl1'a1-ff Fill Colors (~b~~) b'Uflzj~1-11i-:i'1Jel-:J Font (bbtJtJeJfl~'a) ?11~1-a~tl~1J~1~\\ii'-:i'l1 1. rl~fl b~elf1b61l\"~Vl~elfl~~b61l\"~~~el-:ifl1'a1~~bb\"~\"1~\"1tl ' 2. ri~n~tl~ & .. ~bbVltJ Home (Vl°IJ1bb'afl) b'Ufl~~1-11i-:i'1Jel-:J Font (bbtJtJeJfl~'a) lil~tl-a1nnme1tJ ' ' ';,,J Copy• Format fl3intcr Clipbo3rd B2 C D AB Qlm.l faai\\1nu1I h!\\l~l I 2 ••••••;Il'M Slandard ColotS t(o Fill 3 M,ore Colors- 4 !, -53 ffl'l'ffll 8 -1-29.00 -~-03-2.00 53 .658 ,loii 5 -45.00 1,225.00 6 4 211/2558 ,-9-1c1m\" 120.00 -40.00 15

15~ 2 rm1i~11fl1i.:i Cell Styles (~mmJ~b·1m~) ?!1111-at1tli)u~1~~.:ii1 1. fl~m~eitw111;,Jvi~ein~i.Jb\"lfr;,J~iei..:im-a1?i~bbr;,~m~mcJ ' 2. =-~- ,.A ~B--C~--~D . E}Ji FG 1illu i\\NftOlliil hau.r, ~3 =.\"'--:.2 t----ir----t---'=-T~J ~ ~ JI ·::::-- ·~ 1ill2SS8 Mn· ~ °\".:\"'\"~ ~c-- !:.!,..': ---~ ~2 1lli2SS8 !l~llU .... 5 11112.5S8 1~0811 11t1e .S::::: ---.-.-6 4 li2558 ,0~111'1 211,2sss tltl'n1ri !Otl·\"'-1 :oio.-~ ~-\"-) :t\"I·~ ~-AtitaS ~-.vaa . --- f11'af11'WU~abb£'l~£'l1~£'l1cJL~Wf11'ab6Ub:IJ16l bb£'l~tfa.Jfl1i.:i Format ('atlbb'l.JU) tJntm1~~.:ii1 ' 'U ..J 1. fl~ fl b~el f1b611'1JV!~el fl~1J b\"lf'1J~iel.:J ms1?1~ bb'1~i;'!'J~'11cJ ' 2. fl~fl~bb'Yl'U Home (V!U1bb'afl) b~eim'.J11f11i.:i Format (<atlbbUU) ':il~iM1i.:it1eicJ fl~m~ein Format . ' 'U Cells... (:5'~Jtlbb'UUb\"lf'1J) ':il~tJ11n~ Dialog Box Vl~elfl~fl\"IJ11b~elflfl1i.:i Format Cells ... (:5'~Jtlbb'UUb\"lf'1J) 3. fl~fl~bb'Yl'U Fill (fl1<ab~1l) n1vr'U~~bb'1~m~mcJ\"1JeJ..:Jbtr;,Jvi~ein~mt'1J~iei..:im-a\\,lmb~.:i 4. b~ein1vt'U~b~cJufeimbii'1F1~n~tJ11 OK ' ' j NCICdrl' --I - o•a••••••• . o••maaamao •••&•••••••••••••••••••••••••••••••m••1a1 •••••••••• lff\"\"\"'--l t-c.tn...j

mfl1';i~\\91';iUbb'U'U6LJtl~'Gl'Wtlfl'<il1ff'il~~~~1c.llWI.Jbtl~bbi1 micJ~?!1~1';itl1 U';ibbfl';i~~~fl1';i';iUbb'U'U\"LJm.m1~ 'U 'U 'U 'U OJ el~l'W~~~1c1m11-1f Table Style zj~b'U'W~n~ru~'1Jt1~~~~111~1'Wfl11t1t1flbb'U'Ui!11~b~t1n1imnmcJ 1~c10i r1~n~1ubb'U'U~m11~ii'<il~ bb?!~~bu~cJ'Wvtu1~11~miim~ b~'W'Vl'Wvi zj~iJl'f5unu~l?i'~d \" '\" ':,.J 1. r1~m~t1flfl~~b\"llG'1~'1Jm\"LJt1~G'1vi~t1~fl11'<il1fl~1t1~1~ B2:F7 '\" 2. fl~fl~bb'Vl'U Home (vtti1bb1fl) b~t1nn~~fl1i~ Style (~n~ru~) bbG'1~b~t1ntl~fl1i~ '' Format as Table (~~~Ubb'U'Ub'U'W~111~) '<il~U11fl{)~Ubb'U'U~111~ Table Style 1~b~tlfl Format as Table: 2 m..._a~~-~-- 1/1 _558 .~CZ] ~~~H- ~~~~~ ~~~~~--------- --------------- c--,--m--m--a-- r--=--!--CI--C--CI --------------- --------------- ----------- 4 2 111\"255S 5 VJJ235S ~~ ~ :::: DbltS!:rtM~11 :: ::::: 6 4 ' li2558 7 211'2558 ~------------ 141'UlW'1ttl611\\'u l111tll1w1I .hlull1 411\\ll\\t 11itVM\\hu ,_ 2 - •so ....,.I 3 I Vl 255S Mn· .I 2 llll'.2558 Ti111nu 3 I zsss ,~ei• Fonnlt As Table • 450.00 1,800 .00 4 4 ?11>'2558 ,..,.,r, ~isftda::afuryos~ 4 2 ltl zsss li'RIIU s 111125 58 tltfniit s :!ii] 3 1,1 sss ,if&;R 129 .00 1,032.00 s t!)'tzillehas~ 211 sss ,o~uf, 245.00 1,225 .00 \"U.658 uti'nirl 2 ~~ 6 7 2 120.00 240 .00

1'u1tJ'rnm~ Microsoft Office Excel 2010 m-ffi;'f1~1'Hl~~~rl~ffe:imtJbb'U'U~1~n1V1'U~Vl~el 'lJ 'lJ ~~v\\'1l-fa~11\"Mfl'Ub611'1~~'W1m~cJhi1?1el-:l~~vr11Vlli~1 umsHu~fl1i-:i Format Painter (~1ri'm1,:i'jtJ u'U'U) ' 'lJ ii.ffzj,:ieitju'Wbbviu Home (Vl1.J1bb·rn) 1'Wnzj~6Uel-:Jfl1i-:i Clipboard (fl~tJuei{~) 'W(;lel'W1'Wfl1'jtJflu&!~-:id 1. fl~rn~eirnh-:i6Uei-:ib611'1~~1?1ei-:im'jfl~'1eimtJbbuu 'lJ [Zj2. fl~fl~bbviu Home (Vl'U1bb'jfl) b~einnzj~fl1i-:i Clipboard (fl~tJuei{~) b~elfl~~ Format Painter (~1rl~11-:J'jUbb'U'U) 'lJ 3. ~~bfl~bG1'!.JU'j~~eimei'Ub611'1~~b~elflbb'1~ Mouse Pointer ~~bU~cJ'WbD'l.J'jU 0.6 'lJ 4. ~1m!'Utl1 b~1i;'1f Ufl~fl~b611'1~~1?1el-:Jfl1'jfl~'1eimtJbbuu 'lJ 5. 1U'jbbm~~~Vl1fl1'jbtJ~cJ'l.J'jUbbuu1\"MbVlijel'Wfl'Ul?l'Wbbuu1\"M~'Wvi (~-:im'W) 'lJ Insert Page Layout Formul5s Data Review DE An9Hn! Ntw ·!16 • A. A. a • a ~ 2 Copy• . <li,·,A·/11:•:11 i)r 3 1111is;s ivin· ../ formot i:_a1nttr lr!.:..l, I ll • AU Clipboard ~ • Font l'i 80 3.25 260.00 fonn>t -~ fl, 2 4 2 1/2558 ffflftll 4 450.00 1,800. 00j E F Copy formatting from one place G 5 -- 3 -- - Ill \"55S - J~ili'I------ ----- S -----129.00 -- 1,012.00 and apply It to anetner. Ooublt-<li ct this button to apply 6 7 2 the same formatting to multiple ilnn\\l ntnnnhu ;lnrna1\\I s ?'J sss tllnhl 245.00 ~ 5.00 pl.sees in the: document. 2 120.00 240.00 83 Pross Ft for motthelp. 80 3.25 260.00 4 2 V1/l551 1\"1D11 4 450.00 1,800.00 01!11 8 129.00 1,032.00 5 245.00 1,225 .00 2 120.00 240.00 C D EF G l\\u\\'u i'will11w\\'I ill&\\11\\'1 ill\\11'11 1lfl\\111UW ;1)'111\\111\\1 I Iii \"558 lv'ln' 80 azs 260.00 4 2 Vl/2558 ffflQIJ 4 45-0.00 1,800.00 8 129.00 I 032.00 53 sss Joil11 5 245.00 J,225.00 2 120.00 240.00 6 4 1/2558 1ll~1'°1 75 sss tlifnin 511P1el-:Jfl1'jfl~'1eJmtJbb'U'U~1flfl11 1 flf-:i 1\"MV11fl1'j~'lJb'D\"1fl~fl~U~ Format Painter 'lJ ' bbi1tl11Ufl~ flb~elflb611'1J~1P1el-:Jfl1'jfl~'1eimtJbbuu1~Vlm t1flf-:1 ~'Wfl11~~n~tl~ Esc 'lJ '

lcf-4,MIM ~al format ceUs have no speci fic number format. NumW CUrrency Accoun ting Da te T= ~!age FractiOn ~tific T6t ~al CUstom OK II ~1 1. tl1\\;1B-:Jf11':ifl1vt'U~':itlbb'\\J'U~1b~\"1J~iJL~m'Uf11':il°l1\\.l1tU b6l1'U vtmm~\"llbVl':i~~Vl 1J1'Ub~\"1J~ fn':ib~8f1 \" tl':i~bf1Vll~ n. Number \"ll. Accounting fl. Date @) Text '<ii. Currency \"IJ. Font -:i. Fill 1~2. tl1\\;1B-:Jf11';jfl1vt'U~b~'U\"1JB'IJ\\;1mb~Bmb'Vl'U n. Alignment @ Border '<ii. Protection \"IJ. Font viu1~3. t11(;1mf11':ifl1vt'U~m~mcJ(;1B-:J b~Bn u D Fill n. Alignment fl. Border '1. Protection

fl. Number G) Alignment fl. Font lil. Fill -:i. Border -veJ1~ btl'Wfi 6~~1'Wm-abtJ~~'W1~1-:im-a~~-atJ uuu b611~1.'i 'lJ @ Ctrl + 1 'l.J. Ctrl + 2 fl. Ctrl + 3 -:i. Ctrl + 4 lil. Ctrl + 5 Format Painter b'U'WA1i-:i~'Vl1~'W1ffi~ fl. rl~~e)fl6V€lfl'J1:IJ @ rl~~eJflJUbbUU -:!. \\9l~'aUbbUU 'lJ lil. 6Ve) fl. uae 'l.J. ~fl ~~6V€lfl'J1:IJ~~'l.J11 a:7. b'U'UA1i-:i1'Wfl1'a~~dUbbUU6V€ll\"l'J1:IJ€!~1-:Jh ~~6V€lfl11:U1~€l~\\?11'WU'W 'lJ 'lJ (ii) ~~6V€lfl11:IJ~~i1tJ 'l.J. fl. ~~<veJrn1:u1~eJ~M-:iflm-:i -:!. 'lJ lil. ~~6V€lfl11:IJ1~e)~\\?11'Wl;l1-:J 'lJ e. <veJ1~btl'Wf1'1i-:i1'Wm-at:-J?11m611~i.'i fl. 'l.J. fl. -:!. ,~Wrap Text (y ~ a Merge & Cente~ • J 9. f1'1i-:1-veJ1~~?11:IJ1'atl~~'aUbbUU1~flU\\,1111-:J bb~~EJ-:!?11:IJ1'atlb'U'W\\911fld€l-:!6V€l:IJ~11?11?11tJ 'lJ 'lJ fl. Format Cell 'l.J. Cell Styles -:i. Condition Formatting @ Format as Table lil. Format Painter 10. -ifo1~ b'U'Ur\\'1i~1'Wfl1'a~~V]iaf'Vl1-:J\"V€lfl11:IJ fl. 'l.J. -:!. ~\\ rapText Ilil. a ~·1erge & Center;•'

•n•uuiilnll!)UMfi• I 1. 1~um~EJ'UbU~hhbbn'alJ Microsoft Excel 2010 bbii'';rv11miih'Vl~bb'i;,~~~iJ'Uvinm,~i'i1'H5m~ 1.1 ~b6/J'i;,~ Al 'Wm1F1111 ?l\"jU\"j1EJ~1m.h~'oJ1b~el'U ' 1.2 'Vlb6/J'i;,~ A2 ~~ A7 'Wl-l'W\\°1111 iim1fll-l f)l-l.fl1~'U5 ~'U1fll-l bl-1~1EJ'U 'V'lt)~.fl1fll-l lJtl'U1EJ'U 1.3 'Wl-l'W~1b'i;,'1m~1'Ub6/J'i;,~ B2 ~~ B7 2000 3000 4000 5000 6000 7000 ~rn.J~1~'U 1.4 bb'Vl\"jn'LJeJl-l'i;,b6/J'i;,61 B2 ~~ B71ub6IJ'i;,61 C2 ~~ C7 \" AB P.C A B C , a1• 1.h1£.1~1£.11.l1::~1l~ir.1u , a1• 1.l11£.1~1£Jll1::~1l~au 2000 3000 2 urmau 2000 2 1Jn'l1fl).J 4000 .n•1JmY.m, 1'i 3000 3 n•1Jn1W.,U1'i 4000 4 1JU1fl1J d 4 1JU1fl).J s UJ1!1'1£JU 5000 l1J1!1'1£JU 5000 6 YH)l!l-111'1).J 6000 6 Wt]l!l-n1fl1J 6000 iln•U1£JU 7000 ih•m1£JU II 7000 s g • C ···································································································································································· ···································································································································································· ···································································································································································· ····································································································································································

., ?f 1l'Wrn~ eu 2 fl'LIe:i e:i n1J1tl1 b?l'LI €l 'Vf1J1-B'm~ ~J'LI ' E 2 1 A1~\\tl~u 1,200.0 3 2 A1u1~11 2,500.0 4 3 A1utln1nf 900.0 ' 3,500.0 600.0 8,700.0 1. 1~-wrn~t1'LI~1J-w-ve:imm~1'Wb6/l6',~~11J~1e:i~1-:i '\\J W2. ~b6/l6',~ ~1 fi-:i c11~r1i'in~ U'Wbbtiu~uue:i'LI 03. 611flb1!T~1fl~1Jb6/l6',~ B2 fi-:i CS bb~1fli'in~ 'U'Wbbtl'U~'U'U€l'LI 1-:-14. b~€lflb6/l6',~ A2 fi-:i AS fli'in~ 'U'Wbbt1'U~'U'U€l'LI. 5. U'Wvinzje:ih,M ~e:i-:i-b6','lJ~- EX3-2 A B 1 i,..,.111.. 1.l1a1le1a miJ II 4i1u \"I \"t, ~ 59000 5900 2 UW~fl'J11l UflltJ 15000 1500 . .3 U1Uft'11U'fjnJ &;iirul;i 18000 1800 \"t, 'U ~ .. ,, 17000 1700 4_t1~:'41l1 lt1ilfll:IUID~ _ 5 ~UlY.U1H11\\4 u1:ul;,

•n•i.JuiiJnu.aumfi• 3 1. 1~um~tl'U'Wll~\"Um.J1;1bbl;1~~mubb'\\J'U~1ll~fl1°vru{;l1~ 'U 'U 2. b'UeJ'U\"UeJlJi;j 'UfleJ~lli.J E m1J~1mh:ib{;ltJ'Wll~1'U~~-:id 'U E2 'Wll~ 10/4/52 E3 'Wll~ 3/9/2552 E4 'Wll~ 12/10/2010 ES 'Wll~ 25/11/2552 3. Vl1fl1\"a~{;l~'Ubb'U'\\Jb{;ltlfl(;l~lJ Ctrl + 1 \\il~'U'a1fl{]Vlii1~1'1 Format Cells b~elfl~bb'Vl'\\J Number ~{;l'a'Ubb'U'U1'U~~-:id 'U b61l1;1~ E2 b~e1m1tim1 Category b~elfl Custom V1ii1~1-:i Type b~elfl d-mmrn-yy b61!1;1~ E3 b~e1m1tifl1'a Category b~elfl Custom V1ii1~1-:i Type b~elfl d mmmmyyyy b61J1;11;1' E4 b1.c;:!1:,Ie1m1tin11 Category iaun.c:!:,I Date '\\ll'U!i.l1~I1'1 Type b1d;i1! 8fl 14/03/2001 b61l1;1~ ES b~e\"Jm1tlfl11 Category b~elfl Date V1ii1~1-:i Type b~elfl ®cdorn/~oo® 4. 1J'Uvinzje11~~ ~e1-:i -b1;1'll~ -EX3-3 A B C D E 1 i1«\"u .,..fl- ,mu,n•a OI .i11nnH 2 l..--1-1'1-4-W_ti_ii_'b1_fi__,r_n'_i u____.1?-_~f_l n_1'i -1--_s_9_,oo_o.o_o·-1---1_0-_A_p_r-_s2 31 2 '141!Jff'i'itff~ty t;J~tyl;i Vl\\4M1\\4'\\11V 15,000.00 03-Sep-4 9 4\" 1,!----3l-in-n~-ilt11-1h-~i-m1.-1it.:-i -1-t~-'\\11-'=tf-l1-'i --4-1-8,0-00.0-+0- 12-0ct-48 • 4 'Uff.\\41l111'14 tl1'14h Vl\\4M1\\4Utyi 17,000.00 ----~ 25-Nov-52 •n•i.Juiilnu.aumfi• 4 I _ A a_....c;'--_\"\"o' -.:cE.---\"F-_.;:G;..__ H - -, - - . •. __, - . .... -'\"\"T\"-' - ·- olA\\J ·nfo jtJitii,;(1 · iiitl~o ~rn11J~mnht·;t~1i1~ 2 -. -- 3 1 AOOl m~inJ'lnlu 1ou.11.53 120 12s is.ooo.oc .................................................... ···········•········ ············-··· 4 2 A002 nmnJ'll1011 12 u.11. 53 so 150 12,000.00 5 3 B003 1foil?1 7 IIJ.O. 53 150 80 12,000.00 6 4 B 004 1fo14fl 911J.O, 53 225 120 27,000.00 oOOOOO••• 00000000 000000•••000•••0000 oOOoooooOOOO•O• .000000000 ooOOH••oOO oooOOOo•oOOOOO•• 7 5 C 005 l~IJ'IJl'I 15 llJ.O. 53 80 70 5 600.00

1. 1~ilm~tJ'LI'WiJ'W'VeJ~~~fmJ~~-aubbuu '\\J '\\J 2. ~b61l~~ 83:BS 1m~iqi~mjUJb~'U'Ul'Vl 3. ~b61l~~ C3:CS 1m~iru~n~ru b~'U~eJ~m{?lvl'fio V~ 4. ~b61l~~ D3:DS 1m~iqi~n~rub~'UUeJ'Ul9l 5. ~b61l~~ E3:ES 1m~iqi~n~rub~'Ubtl'U 6. u'Uvinzje:i1vM ~e:i-:i-b~'11~-EX3-5 l/Jl A I B I C I D E · I Uel~~1Ui~A1~\"elelfl I ,s .1m, &ii\" ~Vl5~ 0, V• 2 !fltlU tlMH]lt 3 l1Jnnm.1 1!1185,000.00 S85,000.00 £54,000.00 ¥350,000.00 4 ,~3.lmwu/ 1!1250,000.00 S75,000.00 £52,000.00 ¥420,000.00 5 liju1A3J 1!1350,000.00 S60,000.00 £48;500.00 ¥325,000.00 ....----... . nuuiiJntJ.oumfi 6 1. 1~ilm~ti'LI?1f1-:iv1111-:iG1e:i'Ut~ti'W~-wv11mbuu-we:i1ii~rhv1'U~1~ 2. ~~iubb'U'Ub1m~miiu Number>Time>Type 13:30 'LI. 3. ue:i'Uie:iii~1'111 b~ti'Limiiv1111-:i b~ti'LI'1J e:i-:iilm~ ti'LI '\\J 4. U'Livinzje:i1-w~ ~e:i-:i-b~'11~-EX3-6 AB C DE G H -.ifo\"i\"i\"L~UU 3 .;lo,J'mtuu A\\i11l~mfl 4 6 (u,e,( A.....Cuu n.-,1Wll(uu 9 1J 40 'll 15 30, 10 11 12 13 ,m,>'!7 14 .,~8 \"

n------·n·i.JuiilntJ.oumfi. 7 1. 1~,Jm~m.Ji:1~1-:i mJu°v'lei1ll1ubi:1~~fob1'W 2. u'Wvinzjei1V'l~ ~ei.:i b616ll~ EX3-7 _l!IA B DE F G 'Q\"l'Mi'l'Mi~'14 2 ~ 0 e,., 3 ,nn~A Q., A 4 1J\"i1:t'Yl 'Yl•\"n1\"i'Yl 98/125 td'qii.t1nLuflf qi_u,.,\"Jm::,rn 1l.Lii1l.,'J'\\.tWY11J,1 .i.i.tU'Yl1J,1 11000 5 6 ~eami, ....................................................................................................................................... d V LS'lll1 7 --····-··-····..·····························································-····························-·········..···-···· Vd 114l1 8 ....................................................................................................................................... 9 10 a,ti11 ni1'1 T1S1l'11 ·\\hM,'l'Mi Tifl\"llM~'lS 12 .TilJ 7% 13 14 m i; 15 TilJLj14 16 17 18 19 20 21 22 23 i1!ini;1 24 25

,,._____ . nuuillnunumfi 8 1. 1~um~cJ'LI?ff1,rn'U'Ul\"JeJ{~?f~(;l';i1cJ1'UJ1hJ ' 2. u'UviflzjeJ1vJ~ ~eJ-:i b~61l~ EX3-8 AB C D . E FG H ~urrn 2 W.fl ....... lll'llii 1fliifl lfl~iiil 3 1iiai. 'II<~ uiyi U1)1 il'.fl. U1)1 il'.fl. 14 j ,.._____ s 6 7 8 9 10 11 12 13 14 . ni.Juillnllnumfi 9 1. 1~um~cJ'U?t{1,rn'U'Ul\"JeJ{~?f~(;l';i1cJ1'U(eJ~'LI~1 ' 2. u'Uviflzjel1vJ~ ~eJ-:i b~61l~ EX3-9 AB C D FG H 2 3 >\"-·\"--~ 111,i/f ~Dl?W> lf ,1.,..,,, Min IFIO\" lffl*fl 4 l~DU -fulf \\tnhnuh(n ,m,M' :>\\ i Uty'! 4ohm ~D ,m,f 6 7 8 9 10 11 12 13 14 15

,.,._____ . nuuiilnl11jum.fi 10 11. ~,!n L~cJ'W?1~1~ m.Ju1,fa4l.l?1l.l~~1 cJ1'W?f~~'W~'Wfl1 LL'1~~1'W1'W~1~'1~ 1 2. 'U'WviflzjeJ1vl~ ~m Ll;'l'lJ~ EX3-10 l.-A B C D E FG H 2 . ..,o. 3 YU'i. lft,,;I fo17iv.d Yi\\l1 ,rnli• .~....dn-nm IJ~ iil~l'iullim m~n 4 ,~ou -furl Debit Note 5 6 7 8 9 10 11 12 13 14 ..--.,...15 . nuuiilnu.aum.fi 11 11. ~\"IJflb~cJ'\\.J?l~1~bb'IJ'Uvlti4lJ?llJ~~1cJ1'\\.J'lJ1cJ~'Wfl1 1 2. 'U'WviflzjeJ1vJ~ ~eJ~ L'1'1l~ EX3-11 AB C D GH 2 '1011'\\,, ,.,r, ,....11. ..o. ?\"\"ii' -- ~3 \".fl. 2567 fo~n11d' riwt,m,.~ i¥ ,,,vaum mi;,,,v 4 1II011 -r,.f{ \\ut\\-m1J htr, 5 6 7 8 9 10 11 12 13 14 15

11. ~'Uflb~tJ'Ul;fh:m 'U'tJYJei{:wl;'f:W\\il~1tJ1'U\"ll1tJ~'Ul·l1 1 hM2. U'Uvif1zjel ~e),:j bl;'l\"lJ~ EX3-12 AB C D E FG H 2 illjti'11U1°llw~llftufi1' u11:-}i111\\l~at1ll-i' 3 \\'I.fl. rn'll~ 1\\1{1 1~0~ ~o,i) QI/,, 4 1«011 ·Ml Credit Note fo9n11d' uiyf fu/111~,i, mmu ijnl\\?,;:,~m 5 6 7 8 9 10 11 ~ -- --·---ll--------·-·-·--·-··-·-··--IU---1-----11'----f------f 12 1-- - - - -11-- -- - - --·- --- -ll---f -- - - -1-- - - -1- - - --1 13 14 15 ,.._______ L-- _....__ ----- ·----- - - . nuuillntJ1)tJmfi 13 11. ~,rm~tJ'Ul;'ff1-:i uuu~ei1:wut1J\"libwn·1.h~ b.fl'Vl~11t1 1~J2. u'Wvinzjei ~ei-:i bl;'l\"ll~ EX3-13 /B C D E F GH J K LM 2 11un·~ 101 3 1U . 11on11 1nT1 l~ii~ 11.n....•••. 11'1!1 4 ,l;u i'uii lJ111 ?U. 5 li!!Ji 11111 ll'.11. il;u 111f 11on11 6 --····--··· -····-- ·-···-·-··--····--·----··--··--·-······-····--··············--·H-··--11---·--·········-······-··· ··-··-- ----· --·-· ···-·-···-····-···---··--·--·---·----------- --- ----·---··--····-··--·· ·--····- 7 ~·---· -·-·· ··-·--······-··--····-----···-··-··--····-···--··-- --11------!--ill----·· ··-·- ·----··---···--···--·----·---ii---------··- -- 8 --r-- ------------- -·-41------lf---H---1-ll--·-------11--·A----1--n 9 ,,__ -D----- ------ll---11---~-ll --1--1---------·----- --ff----- 10 -11 ----- -·-·· ·-----------····-···-·-·--·--··----- --11----l--l!---li--!I----·---·----····--····-···-···-·-·-·····---··-· ··--······1~-····-·-·······-····-······--1 ----- ---·--·-------·\"--\"------'-.L.---'---''--------------- -·--- \"----·-·----··--·· --·--

.----·I·Iuumnu.oum.n. 14 1. 1~°1Jflb~cJ'W6'1~1·:!bb'lJ'LJ~el{1J1J(lJ'UbbcJflth~bf1Vl~elcJ 2. D'Wviflzjelb~~ ~el.:l b~'LJ~ EX3-14 AB C E fGH JK 2 ~ntt6 f111111m,tl\\l tt~1 1fluft lfltflft MlttfiO 3 '1.11. t1unn ll'l\\l, 11111 fffl. 11111 fffl. 11111 fffl. 4 1ilo11 M 5 6 7 8 ·---· ----·---~-,----1-..--- ---- - ·----\"-\"'\" , ,._,,,_, _ -----1---· ----- . . -- --·- - 9 ---·--·- -------------·U-·- , ·--- - 10 ··--.·-·--·-·--···\"··----·---- ··---- _ -------·-·--·· 11 -- _,___ ,-,-u,----·•-- ----· ,,__ .---4- 12 i___,__......._,_,,_,,_,,__,,,..,_,,.,..._. .....-- ---·-- - _,, .._ -- ----·~ .__..•I•Iuumnu.oum.n• 1 s 1. 1~°l!m~cJ'W6'1~1.:ibb'll'll~eJ{11m~~1~v\\'1m1 6 -deJ.:i 2. D'Wviflzjelb~~ ~el.:l b~'LJ~ EX3-15 AB CD GH K MN0 2 r,\" ................................. 4VllffM!1\\l~fl111~11 3 n1iM~1hn11, 'l'o4 ,non '\"'~\" .. 11,n 31 f\\111nU lSu - 6 4oll'ty9 1n,lf 4Ullftft04 4v~1imn1111 ·- 1 8 ll'tyt ,no\" '\"'~\" ,non '\"'~\" 9 1- 10 u 12 13 H 15 16 17 18 19 --·20 21

1~'Um~~ruvh.1~~1~1..:inm L~m.J 1~cJf11'VltJ~1~~i1-uei~.:id 1. l;11~tJ 2. zjei m11?1n~ 3. nmL'U1L~cJtJ ' 4. b1~1b~f)b~cJtJ 'W1J~zjm~eitJ1tJ~el.:J 10 ~tJ uuvim1~1b'U1b~cJtJbb~~b~f)b~cJtJ\"IJel..:Jb~eltJbb(,l~~fltJ ~~~\"tlLLtJtJL611~~1~?!1cJ-.'.1111 uuvin1y.JJzjei Time table 1~'Uf1b~cJtJ'W1J~~1~1-.'.l~..:Jelelf1~tJr11 f11'VltJ~zjel~tJr11 tJ~~b'V1131~~-.'.lelelf1 (mh.:JUelcJ 6 tJ~~b'\\11131) uae f11'VltJ~~1tJ1tJL1tJcJel~\"IJ1cJbel.:J 1~~qj~f1'l~flJ\"IJel.:J L1tJLL(,l~~tJW b'\\111311~~f1\\Plel.:J ~~~tJ bbtJtJb611~~1~?f'JcJ-.'.1111 uuvin1y.JJzjei Currency (;l'JeJ~1..:i~..:i~tl \" -A -B L -C D --E F -G - 1 Gl1'rh'lff\"~11~(100fl1htlil1L~O\" L&l'.lt'UJ\\4i 6 2 ~tJTI1')ff\\U)1 1 2 3 4 5 3 ,i\"11 4 3.ii'tthtl:~l.J 5 \"li111w~ ., Q 6 ,i11t~m.11 7 m\" w